Stay organized with collections
Save and categorize content based on your preferences.
Objective
In this document, we will look into how to use the Address Validation API in
Google Sheets in order to test the service in a quick and light way.
As a non-developer, while willing to work with data coming from Google Maps
Platform such as Address Validation
API,
you may wish to find a way to get started with the service without too much help
from technical teams.
Use cases
Now let's understand the use cases where Address Validation API in Google Sheets
is useful:
Trial: As a business you may want to quickly test the capabilities of
the Address Validation
API
using your own addresses.
Compare: Compare Address Validation API results with other endpoints
results such as Geocoding API or Places API.
A/B Test: A/B Test variations of the same dataset to understand what
might provide more suitable results.
In the “API Key + Dashboard” Sheets tab, replace B2 cell with your API Key.
Copy/Paste Addresses in the template (in a separate sheet to format the data: concatenate street number, name, city, postcode)
Select sheets cells and then select from Menu “Address Validation” >
“Address Validation API selection”
On first execution, you will an “Authorization Required” message will
appear to provide access to the Apps Script.
Google Maps Platform Terms
The Solution is provided for test purposes on a limited set of addresses:
Caching period allowed: 30 consecutive calendar days, after which Customer must
(1) delete the cached Google Maps Content or (2) replace with End User data
provided through End User confirmation or correction. Refer to Google Maps
Platform Terms of Service Table 11.3.1 (Caching
Permissions):
placeId
Location: latitude values, longitude values
verdict
formattedAddress
postalAddress
addressComponent: componentName
USPS Data standardizedAddress
Considerations
Performance: Proceed in chunks of 1000 rows not more at once. The script can
eventually stop, for instance when exceeding API quota per second, proceed
from row where the script stopped.
You can access the code from Menu > Extensions > Apps Script and make your
own version of the script tailored to your need
Address Validation API in Google Sheets allows non-developers to start querying
the Address Validation API and understand how it can be strategic to their
business. This document attempts to demonstrate how anyone can start querying
the API by creating an API Key and using the provided Google Sheets template.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[[["\u003cp\u003eThis guide helps non-developers test Google's Address Validation API using a Google Sheets template with custom functions.\u003c/p\u003e\n"],["\u003cp\u003eThe template allows users to quickly trial the API, compare it with other Google Maps Platform services, and perform A/B testing on address data.\u003c/p\u003e\n"],["\u003cp\u003eUsers need a Google Account, an API key with Address Validation API enabled, and should adhere to Google Maps Platform Terms, including data caching limits.\u003c/p\u003e\n"],["\u003cp\u003eThe solution is intended for initial exploration and small-scale testing, with considerations for performance and pricing for larger datasets.\u003c/p\u003e\n"],["\u003cp\u003eUsers can further customize the provided Apps Script code and explore advanced use cases through provided resources.\u003c/p\u003e\n"]]],["This document guides non-developers on using the Address Validation API in Google Sheets for testing and analysis. Key actions include copying a provided Google Sheets template, enabling the Address Validation API, and generating an API key. Users input addresses, execute API calls via custom Apps Script functions, and interpret the results. Data must be deleted or replaced after 30 days. The tool is intended for trial, comparison, and A/B testing of address data.\n"],null,["Objective\n\nIn this document, we will look into how to use the Address Validation API in\nGoogle Sheets in order to test the service in a quick and light way.\n\nAs a non-developer, while willing to work with data coming from [Google Maps\nPlatform](https://mapsplatform.google.com/) such as [Address Validation\nAPI](https://developers.google.com/maps/documentation/places/web-service/overview),\nyou may wish to find a way to get started with the service without too much help\nfrom technical teams.\n\nUse cases\n\nNow let's understand the use cases where Address Validation API in Google Sheets\nis useful: \n\n- **Trial** : As a business you may want to quickly test the capabilities of the [Address Validation\n API](https://developers.google.com/maps/documentation/places/web-service/overview) using your own addresses.\n- **Compare**: Compare Address Validation API results with other endpoints results such as Geocoding API or Places API.\n- **A/B Test** : A/B Test variations of the same dataset to understand what might provide more suitable results. \n\nGoogle Sheets template\n\nThe solution is a [Google Sheets](https://www.google.com/sheets/about/) that\ncomes with custom [Apps Script](https://developers.google.com/apps-script)\nfunctions which will perform requests in sequence to the [Address Validation\nAPI](https://developers.google.com/maps/documentation/places/web-service/overview).\n| **Tip:** This example is meant for integration guidance only. You should ensure quality before use with your applications. Support is available on the products such as Address Validation API used by this example.\n\nYou can run addresses by the API following the steps below (requires a [Google\nAccount](https://support.google.com/accounts/answer/27441) and an [API\nKey](https://developers.google.com/maps/documentation/address-validation/get-api-key?#creating-api-keys)): \n\n1. Navigate to the [Sample\n Spreadsheet](https://docs.google.com/spreadsheets/d/1NoEjMNIlKPhMHbMCaAant3TCF4wgcW-p27zpmEnaCkY/edit?usp=sharing&resourcekey=0-TmBtRxAmgzlyIXlWgEdwjg) and from the Menu select: File \\\u003e Make a copy \n (you need to Log in your [Google Account](https://www.google.com/account/about/) or create one) \n2. Enable [Address Validation\n API](https://developers.google.com/maps/documentation/address-validation/get-api-key?#creating-api-keys) and generate an API Key from [Cloud\n Console](https://console.cloud.google.com). \n3. In the \"API Key + Dashboard\" Sheets tab, replace B2 cell with your API Key. \n4. Copy/Paste Addresses in the template (in a separate sheet to format the data: concatenate street number, name, city, postcode) \n5. Select sheets cells and then select from Menu \"Address Validation\" \\\u003e \"Address Validation API selection\" \n6. On first execution, you will an \"Authorization Required\" message will appear to provide access to the Apps Script. \n\n| **Caution:** Secure your API key by restricting its use to the Address Validation API only. To prevent unexpected usage, make sure to only share your sheet with trusted parties, and delete your key in the Console after you are done with your analysis. \n|\n\u003cbr /\u003e\n\n\n\u003cbr /\u003e\n\n| **Tip:** in order to comply with the Google Maps Platform Terms, make sure to delete the Spreadsheet after 30 days as Google Sheets has built-in history.\n\nGoogle Maps Platform Terms\n\nThe Solution is provided for test purposes on a limited set of addresses:\nCaching period allowed: 30 consecutive calendar days, after which Customer must\n(1) delete the cached Google Maps Content or (2) replace with End User data\nprovided through End User confirmation or correction. Refer to [Google Maps\nPlatform Terms of Service Table 11.3.1 (Caching\nPermissions)](https://cloud.google.com/maps-platform/terms/maps-service-terms): \n\n- placeId \n- Location: latitude values, longitude values \n- verdict \n- formattedAddress \n- postalAddress \n- addressComponent: componentName \n- USPS Data standardizedAddress \n\nConsiderations\n\n- Performance: Proceed in chunks of 1000 rows not more at once. The script can eventually stop, for instance when exceeding API quota per second, proceed from row where the script stopped.\n- You can access the code from Menu \\\u003e Extensions \\\u003e Apps Script and make your own version of the script tailored to your need\n- [Pricing](https://developers.google.com/maps/documentation/address-validation/usage-and-billing) for Address Validation API.\n\nConclusion\n\nAddress Validation API in Google Sheets allows non-developers to start querying\nthe Address Validation API and understand how it can be strategic to their\nbusiness. This document attempts to demonstrate how anyone can start querying\nthe API by creating an API Key and using the provided Google Sheets template.\n\nNext Actions\n\nSuggested Further Reading:\n\n- [Address Validation for Ecommerce Checkout](https://developers.google.com/maps/architecture/ecommerce-checkout-address-validation)\n- [High Volume Address Validation library](https://developers.google.com/maps/architecture/high-volume-address-validation-library-oss)\n\n\u003cbr /\u003e\n\nContributors\n\nGoogle maintains this article. The following contributors originally wrote it. \n\nPrincipal author:\n\n[Thomas Anglaret](https://www.linkedin.com/in/thomas-anglaret/) \\| Solutions Engineer\\\\"]]
