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...
- 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!
- Free forever for core features
- 14 day trial for premium features & apps
BusinessName
Address
Address2
City
State
PostalCode
BusinessName
Address
Address2
City
State
PostalCode
