[null,null,["最后更新时间 (UTC)：2025-09-10。"],[[["\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\\\\"]]
