3/19/2024 0 Comments Google maps lookup ip locationLet firstMatch = result.matches || The place_id of the place, or null if none was found. * api_key = "YOUR_API_KEY" // An unrestricted key is recommended for local use only (deployment is NOT recommended). * * LookupRegionByUnitCode looks up a region with the specified unit code. * * LookupRegionByName looks up a region with the specified name. * * SearchRegionByPlaceId searches for a region whose boundary contains the specified place ID. * * SearchRegionByAddress searches for a region whose boundary contains the specified address. * * SearchRegionByLocation searches for a region whose boundary contains the specified latitude/longitude coordinates. * Provides custom Geo functions in Google Sheets for matching boundaries. Replace YOUR_API_KEY with an unrestricted API key belonging to a project.Copy and paste the code from the example below into the script editor.Select the menu item Extensions > Apps Script.ForĮrrors which prevent the script from running properly (such as omitting a validĪPI key), the error will appear as a comment for the cell containing the Replace YOURAPIKEY with an unrestricted API key belonging to a project that has the region lookup API enabled. Copy and paste the code from the example below into the script editor. In the preceding example, the request succeeded so the error cell is blank. Select the menu item Extensions > Apps Script. In theįollowing example, if the function were pasted into cell A1, the results would ![]() Region name and polygon in Google Maps is provided for verification. If candidate place IDs are available, results for those place IDs The results are output in the cell containing the function, and the two cells Call custom functions from the sheet like this: The functions as you would call any other spreadsheet function. gs scriptĬode to the Apps Script script editor. To use the custom functions, you must first add the custom functions. LookupRegionByUnitCode looks up a place with the specified unit code.Ĭaution: The Region Lookup API and App Script code areĮxperimental Releases.LookupRegionByName looks up a place with the specified name. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |