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
Triggered when a new row is added to the bottom of a spreadsheet.
- automatically do this...GetBestMatches-Production
Our industry-leading, GetBestMatches operation combines Delivery Point Validation (DPV) to verify an address is deliverable, Residential Delivery Indicator (RDI) to identify residential or business, and SuiteLink (SLK) to add secondary suite information for businesses, into one robust API call to our USPS CASS Certified database engine.
- 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