GoogleSheetsV2API logoShipEngineCLIAPI@1.0.0 logoGoogleSheetsV2API logoGoogleSheetsV2API logo

Validate Addresses from Google Sheets with ShipEngine

“Nothing is more frustrating than delayed or incorrect deliveries due to typos in your recipient’s mailing address! Whenever you add a recipient’s address to a spreadsheet, validate the address and update the same row with the corrected address.”

Ariel Lecreated by Ariel Le
How Zapier works (57 sec)
How Zapier works (57 sec)
Try this Zap FREE for 14 days

Trusted at companies large and small

This Zap works in 4 steps …

  • Step 1 - Trigger

    Anytime a new spreadsheet row (team drive) is created in Google Sheets

    2 notes from the creator …

    1. Ariel LeAriel Le (creator)Make sure each part of an address is its own column. Recipient Name, Address Line 1, City, etc.
    2. Ariel LeAriel Le (creator)This can be for crowdfunded projects, thank you gifts to colleagues or partners, or if you just want to keep a clean digital address book. All to make sure your packages make it to your recipients in a timely manner.
  • Step 2 - Action

    Validate an address in ShipEngine

    1 note from the creator …

    1. Ariel LeAriel Le (creator)ShipEngine supports address validation for virtually every country on Earth, including the United States, Canada, Great Britain, Australia, Germany, France, Norway, Spain, Sweden, Israel, Italy, and over 160 others.
  • Step 3 - Action

    Lookup spreadsheet row in Google Sheets

    2 notes from the creator …

    1. Ariel LeAriel Le (creator)Now that ShipEngine has validated an address, we need to find the row we need to update.
    2. Ariel LeAriel Le (creator)Names, phone numbers, email addresses, or anything unique to the recipient from the Google Sheet row you added will tell this Zap which row needs to be appended with the correct information from ShipEngine.
  • Step 4 - Action

    Update spreadsheet row in Google Sheets

    3 notes from the creator …

    1. Ariel LeAriel Le (creator)This step tells Zapier: Now that we have a valid address AND we know which row to update, update some columns in this row with the new valid address.
    2. Ariel LeAriel Le (creator)While you build the zap, have the Google Sheet open in a new window next to Zapier so you can see your results automatically fill in!
    3. Ariel LeAriel Le (creator)When the Zap is turned on, remember to use "Zap History" if you see any issues come up.
    • 2 minutes to set up
    • Get back 1.2 hrs /week
    • 4585 people use this app pairing

    This Zap uses the following 2 apps

    • Google Sheets logo
    • ShipEngine logo

    Google Sheets + ShipEngine

    Check out all the other ways you can connect Google Sheets and ShipEngine.
    Learn More