{"id":17215,"date":"2025-01-19T12:39:26","date_gmt":"2025-01-19T03:39:26","guid":{"rendered":"https:\/\/84office.jp\/?p=17215"},"modified":"2025-01-22T15:14:19","modified_gmt":"2025-01-22T06:14:19","slug":"get-google-maps-api-geocoding","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/get-google-maps-api-geocoding\/","title":{"rendered":"How to Get a Google Maps API Key: Retrieve Latitude and Longitude from Addresses in Google Sheets"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>Have you ever wanted to automatically retrieve latitude and longitude from addresses to enhance data analysis or improve workflow efficiency?<\/p>\n\n\n\n<p>With the Google Maps API, this becomes possible.<\/p>\n\n\n\n<p>However, to get started, you first need to obtain an API key.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">In this article, we\u2019ll walk you through the step-by-step process of obtaining your Google Maps API key.<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-60\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d-1-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/run-google-maps-api-geocoding\/\">How to Automatically Convert Addresses to Latitude and Longitude in Google Sheets Using Google Ma&#8230;<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">In the previous article, we introduced how to obtain an API key for using the Google Maps API. In this article, we will show you how to use the Google Maps A&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">About Google Maps API<\/h2>\n\n\n\n<p>The Google Maps API is a platform provided by Google that allows you to access various map-related features.<\/p>\n\n\n\n<p>It supports a wide range of applications, including map display, route navigation, and retrieving location information.<\/p>\n\n\n\n<p>To meet diverse mapping needs, Google offers specialized APIs tailored to specific purposes.<\/p>\n\n\n\n<p>For example, the Google Maps API is commonly used in the following scenarios:<\/p>\n\n\n\n<ul class=\"wp-block-list u-mb-ctrl u-mb-50 has-swl-pale-02-background-color has-background\">\n<li><strong>Geocoding API<\/strong>: Converts addresses to latitude and longitude, and vice versa.<\/li>\n\n\n\n<li><strong>Directions API<\/strong>: Provides route navigation and calculates travel distances.<\/li>\n\n\n\n<li><strong>Places API<\/strong>: Searches for nearby places and retrieves detailed information about them.<\/li>\n<\/ul>\n\n\n\n<p>The <strong>Geocoding API<\/strong> specializes in retrieving latitude and longitude from addresses (known as &#8220;geocoding&#8221;).<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">In this guide, we\u2019ll focus on obtaining the API key required to use the <strong>Geocoding API<\/strong>, one of the many features offered by the Google Maps API.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Obtain a Google Maps API Key<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Obtaining a Google Maps API Key<\/strong><\/h3>\n\n\n\n<p class=\"is-style-icon_pen u-mb-ctrl u-mb-40\">The API key created through <strong>Google Cloud Platform (GCP)<\/strong> can be used not only for the <strong>Google Maps API<\/strong> but also for other Google Cloud-related APIs, such as the <strong>YouTube Data API<\/strong> and <strong>Google Drive API<\/strong>.<br><br>However, for better <strong>security<\/strong> and easier <strong>troubleshooting<\/strong>, it is recommended to manage API keys separately for each service or purpose.<br><br>In this guide, we will create an API key specifically for <strong>Google Maps API-related purposes<\/strong> and refer to it as the <strong>Google Maps API Key<\/strong>.<\/p>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Creating a Google Cloud Platform (GCP) Account<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"413\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65-1024x413.png\" alt=\"\" class=\"wp-image-17216\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65-1024x413.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65-300x121.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65-768x309.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65-1536x619.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65-2048x825.png 2048w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-65.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Visit the official <strong><a href=\"https:\/\/cloud.google.com\/?hl=en\">Google Cloud Platform (GCP)<\/a><\/strong> website.<\/p>\n\n\n\n<p>If you\u2019re using GCP for the first time, click on <strong>\u201cGet Started for Free\u201d<\/strong> and log in with your Google account or create a new one.<\/p>\n\n\n\n<p>You\u2019ll receive <strong>$300 in free credits<\/strong> to use for various GCP services, including the Google Maps API.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Selecting a Project<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"499\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-1024x499.png\" alt=\"\" class=\"wp-image-16758\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-1024x499.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-300x146.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-768x375.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-1536x749.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/04a10e276c89a728840e9ef4cf88840b-2048x999.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-0b0f55ee-a0f6-482b-a0a6-947344ea0e3f\">After logging in, click on <strong>&#8220;Select a Project&#8221;<\/strong> located in the top-left corner of the screen.<\/p>\n\n\n\n<p>Create a new project here to begin setting up and preparing for API usage.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Creating a Project<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-1024x335.png\" alt=\"\" class=\"wp-image-16760\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-1024x335.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-300x98.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1-768x251.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/8db3632bc0b3af893100f73e59d0d817-1.png 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Click on <strong>&#8220;New Project&#8221;<\/strong> to create a new project.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Naming Your Project<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"697\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-1024x697.png\" alt=\"\" class=\"wp-image-16761\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-1024x697.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-300x204.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de-768x523.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/9399bf10e4e696d459503801bed471de.png 1211w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p id=\"block-b53aeee0-629c-434f-9050-a1738af05a1b\">Choose a name for your project and click the <strong>&#8220;Create&#8221;<\/strong> button.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Example: <strong>My Maps Project<\/strong><\/li>\n\n\n\n<li>A default project name will be pre-filled, but you can change it to any name you like.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Selecting the Created Project<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-1024x362.png\" alt=\"\" class=\"wp-image-16762\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-1024x362.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-300x106.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf-768x271.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/06fb786e06b91995adcb212892bc59cf.png 1494w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-435494c9-eeb2-4f86-a4a2-731b07508a95\">Go to <strong>&#8220;Select a Project&#8221;<\/strong> and choose the project you just created.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Selecting &#8220;APIs &amp; Services&#8221;<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"602\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-1024x602.png\" alt=\"\" class=\"wp-image-16763\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-1024x602.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-300x176.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-768x452.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-1536x903.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7615d657f8977e2cbd7650dcac0fc701-2048x1204.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-bf8a9aa3-9578-4de8-ae76-e4b94f6c0c61\">After selecting your project, click on <strong>&#8220;APIs &amp; Services&#8221;<\/strong> from the menu.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Accessing the Library<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"500\" height=\"552\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/65b73cfa59a7b8fa63282bf9bad62310.png\" alt=\"\" class=\"wp-image-16766\" style=\"width:324px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/65b73cfa59a7b8fa63282bf9bad62310.png 500w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/65b73cfa59a7b8fa63282bf9bad62310-272x300.png 272w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-9b7762c6-a6a3-4bea-aee9-77f05795f15e\">Next, click on <strong>&#8220;Library&#8221;<\/strong> under the <strong>APIs &amp; Services<\/strong> section.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Searching for Geocoding API<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"386\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-66-1024x386.png\" alt=\"\" class=\"wp-image-17217\" style=\"width:693px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-66-1024x386.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-66-300x113.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-66-768x290.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-66.png 1098w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Use the search bar to look for <strong>&#8220;Geocoding API&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Enabling the API<\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"357\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7ed83e5bf08b6a60c4046efc1d478e93-1024x357.png\" alt=\"\" class=\"wp-image-16693\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7ed83e5bf08b6a60c4046efc1d478e93-1024x357.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7ed83e5bf08b6a60c4046efc1d478e93-300x105.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7ed83e5bf08b6a60c4046efc1d478e93-768x268.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/7ed83e5bf08b6a60c4046efc1d478e93.png 1038w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"548\" height=\"224\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/3c721bbbe8d439bcff33eb69ecf61fe1.png\" alt=\"\" class=\"wp-image-16694\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/3c721bbbe8d439bcff33eb69ecf61fe1.png 548w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/3c721bbbe8d439bcff33eb69ecf61fe1-300x123.png 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/figure>\n\n\n\n<p>From the search results, select <strong>&#8220;Geocoding API&#8221;<\/strong>.<\/p>\n\n\n\n<p>Click the <strong>&#8220;Enable&#8221;<\/strong> button to activate the API.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Obtaining the API Key<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"393\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-1024x393.png\" alt=\"\" class=\"wp-image-16771\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-1024x393.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-300x115.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-768x295.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4-1536x590.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/ed84c46da89b6b57635c409781770bb4.png 1726w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Navigate to <strong>&#8220;APIs &amp; Services&#8221; &gt; &#8220;Credentials&#8221;<\/strong> from the menu.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Click <strong>&#8220;Create Credentials&#8221;<\/strong> and select <strong>&#8220;API Key&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Copying the API Key<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"571\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-1024x571.png\" alt=\"\" class=\"wp-image-16772\" style=\"width:774px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-1024x571.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-300x167.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6-768x428.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/00f94bacb58d4c426cce0fdb58ae9aa6.png 1101w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Copy the generated <strong>API key<\/strong>.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Save it securely for later use in <strong>Google Apps Script<\/strong> or other integrations.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Saving the API Key in Script Properties<\/h3>\n\n\n\n<p>To use the API key in <strong>Google Apps Script (GAS)<\/strong>, store it in the <strong>script properties<\/strong>.<\/p>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-onborder_ttl u-mb-ctrl u-mb-40\" data-colset=\"col2\"><div class=\"cap_box_ttl\"><span><span class=\"swl-fz u-fz-l\"><strong>Why Use Script Properties?<\/strong><\/span><\/span><\/div><div class=\"cap_box_content\">\n<dl class=\"swell-block-dl\">\n<dt class=\"swell-block-dl__dt\"><strong>Security<\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>By storing the API key in script properties, you avoid hardcoding it into the script, reducing the risk of exposure to third parties.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Ease of Maintenance<\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>If the API key needs to be updated, you can simply modify the property without editing the script itself.<\/p>\n<\/dd>\n\n\n\n<dt class=\"swell-block-dl__dt\"><strong>Reusability<\/strong>:<\/dt>\n\n\n\n<dd class=\"swell-block-dl__dd\">\n<p>The same API key can easily be reused across different functions or projects without duplicating code.<\/p>\n<\/dd>\n<\/dl>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open the Apps Script Editor.<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"939\" height=\"614\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e.png\" alt=\"\" class=\"wp-image-16773\" style=\"width:453px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e.png 939w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e-300x196.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/c7f349a88f00b3af8118318ca0b11a4e-768x502.png 768w\" sizes=\"(max-width: 939px) 100vw, 939px\" \/><\/figure>\n<\/div>\n\n\n<p id=\"block-b72d9194-4148-4e05-9ac1-dbecdb09694b\">Open your <strong>Google Sheets<\/strong>, go to the <strong>&#8220;Extensions&#8221;<\/strong> menu, and click on <strong>&#8220;Apps Script&#8221;<\/strong> to open the editor.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Open the Project Settings<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"555\" height=\"660\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/b17152a330aa1cf28d99ed3ffffce21d.png\" alt=\"\" class=\"wp-image-16774\" style=\"width:361px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/b17152a330aa1cf28d99ed3ffffce21d.png 555w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/b17152a330aa1cf28d99ed3ffffce21d-252x300.png 252w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60\">In the Apps Script editor, select <strong>&#8220;Project Settings&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Add Script Properties<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"1024\" height=\"236\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-1024x236.png\" alt=\"\" class=\"wp-image-16775\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-1024x236.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-300x69.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808-768x177.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/12\/46edac4eac930bc218a3364cd9a1d808.png 1518w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Select <strong>&#8220;Add Script Properties&#8221;<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"227\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-67-1024x227.png\" alt=\"\" class=\"wp-image-17218\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-67-1024x227.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-67-300x66.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-67-768x170.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-67-1536x340.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-67.png 1570w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Enter the key name (e.g., <strong>&#8220;Maps_API_KEY&#8221;<\/strong>) and the API key.<\/p>\n\n\n\n<p>Once entered, click <strong>&#8220;Save Script Properties&#8221;<\/strong>.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Free Tier for Google Maps API<\/h2>\n\n\n\n<p>The <strong>Google Maps API<\/strong> offers a free usage tier of <strong>$200 per month<\/strong>.<\/p>\n\n\n\n<p>This allows many projects to operate without incurring any costs.<\/p>\n\n\n\n<p>For more details, visit the <strong><a href=\"https:\/\/mapsplatform.google.com\/pricing\/\" data-type=\"link\" data-id=\"https:\/\/mapsplatform.google.com\/pricing\/\">Google Maps Platform<\/a><\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">Conclusion<\/h2>\n\n\n\n<p>You\u2019ve now successfully obtained your <strong>Google Maps API key<\/strong>.<\/p>\n\n\n\n<p>With this API key, you can not only retrieve latitude and longitude from addresses but also leverage other features of the Google Maps API.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-30\">In the next article, we\u2019ll show you how to integrate this API key with Google Sheets to fetch latitude and longitude from addresses. Stay tuned!<\/p>\n\n\n<div class=\"swell-block-postLink u-mb-ctrl u-mb-30\">\t\t\t<div class=\"p-blogCard -internal\" data-type=\"type1\" data-onclick=\"clickLink\">\n\t\t\t\t<div class=\"p-blogCard__inner\">\n\t\t\t\t\t<span class=\"p-blogCard__caption\">\u3042\u308f\u305b\u3066\u8aad\u307f\u305f\u3044<\/span>\n\t\t\t\t\t<div class=\"p-blogCard__thumb c-postThumb\"><figure class=\"c-postThumb__figure\"><img decoding=\"async\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/513f3a0811e53a7de868b7f72fa4eb1d-1-300x158.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" width=\"320\" height=\"180\"><\/figure><\/div>\t\t\t\t\t<div class=\"p-blogCard__body\">\n\t\t\t\t\t\t<a class=\"p-blogCard__title\" href=\"https:\/\/84office.jp\/en\/run-google-maps-api-geocoding\/\">How to Automatically Convert Addresses to Latitude and Longitude in Google Sheets Using Google Ma&#8230;<\/a>\n\t\t\t\t\t\t<span class=\"p-blogCard__excerpt\">In the previous article, we introduced how to obtain an API key for using the Google Maps API. In this article, we will show you how to use the Google Maps A&#8230;<\/span>\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-30\"><ul class=\"p-postList -type-simple\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/googlesheet-barcode-formula\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-12-23\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7412\u670823\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"8\">Workflow Optimization<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Generate Barcodes Easily: A Step-by-Step Guide Using Google Sheets<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/get-google-maps-api-geocoding\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-19\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u670819\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"8\">Workflow Optimization<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Get a Google Maps API Key: Retrieve Latitude and Longitude from Addresses in Google Sheets<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/slack-webhook-url-get\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__body\">\n\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2024-12-06\" aria-label=\"\u516c\u958b\u65e5\">2024\u5e7412\u67086\u65e5<\/time><\/div>\n\t\t<span class=\"p-postList__cat u-thin icon-folder\" data-cat-id=\"8\">Workflow Optimization<\/span>\n\t\t\t\t<\/div>\n\t\t\t<h2 class=\"p-postList__title\">How to Get Slack Webhook URL: Automate Notifications with External Integration<\/h2>\t\t<\/div>\n\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>Have you ever wanted to automatically retrieve latitude and longitude from addresses to enhance data analysis  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17220,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=16691","footnotes":""},"categories":[8],"tags":[],"class_list":["post-17215","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-8","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=17215"}],"version-history":[{"count":2,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17215\/revisions"}],"predecessor-version":[{"id":17248,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17215\/revisions\/17248"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/17220"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=17215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=17215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=17215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}