Google Sheets + Service Objects
Validate new addresses in Google Sheets rows with Service Objects
This automation validates an address when it is added as a new row in a Google Sheets spreadsheet. After validation, the template can add a new row to a spreadsheet. We recommend adding it to a different worksheet than the initial one used for the input. This template will call Service Objects' production endpoint and will only work with a production key.
This automation validates an address when it is added as a new row in a Google Sheets spreadsheet. After validation, the template can add a new row to a spreadsheet. We recommend adding it to a different worksheet than the initial one used for the input. This template will call Service Objects' production endpoint and will only work with a production key.
- When this happens...New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
- automatically do this...
- then do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- 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?
