This script works exclusively with this https://docs.google.com/spreadsheets/d/1PRr_s6Nsus3ATx9hHl8LJOjRCvZpQ5IyXRHnBzwOAUs/edit?usp=sharing template. Basic purpose of the script is to save the selection of material for the customer and generate the proposal.
Works with:
1
Overview
This script works exclusively with this https://docs.google.com/spreadsheets/d/1PRr_s6Nsus3ATx9hHl8LJOjRCvZpQ5IyXRHnBzwOAUs/edit?usp=sharing template. Basic purpose of the script is to save the selection of material for the customer and generate the proposal.

Create a copy of the template for each client.
Select Roofing type, Shingle or Metal for your client.
Select the appropriate package Silver, Gold or Platinum. Its the cell L3.
Select the required material and labor cost from the tables below.
If you are unable to complete the selection then you can save your work by selecting "Yes" from the drop down that says "Save". Its the cell L5.
If you are done then Create the order by clicking "Create Order" from the appropriate menu item inside  "MET Script 3" which is in the Add-ons menu.
Go to the "Pdf Generator" Sheet and select the required Proposal Sheets. Fill in the name of the Proposal and clients email address fields.
Click "Generate Pdf" which is inside the MET Script 3 menu item which is under Add-ons menu.
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
MET Script 3 will ask for the permissions shown below. Learn more
MET Script 3 will need access to your Google account
This will allow MET Script 3 to :
See, edit, create, and delete all your Google Docs documents
See, edit, create, and delete all of your Google Drive files
View and manage your forms in Google Drive
See, edit, create, and delete all your Google Sheets spreadsheets
Read, compose, send, and permanently delete all your email from Gmail
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu