EDS + Google Sheets
Calculate load in EDS when a row is updated or created in Google Sheets
Create a Google Sheets spreadsheet with the required columns (address, zip code, name, email, phone) as well as any other fields you have data for. Then, once this template is active, every new or updated row will be used to run a load in EDS automatically.
Create a Google Sheets spreadsheet with the required columns (address, zip code, name, email, phone) as well as any other fields you have data for. Then, once this template is active, every new or updated row will be used to run a load in EDS automatically.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
- automatically do this!Calculate Load
Calculates Heating and Cooling Load with provided address and home construction variables.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
