{"id":13365,"date":"2023-05-06T02:22:00","date_gmt":"2023-05-06T06:22:00","guid":{"rendered":"https:\/\/buzapps.net\/info\/?post_type=knowledgebase&#038;p=13365"},"modified":"2023-11-04T23:32:46","modified_gmt":"2023-11-05T03:32:46","slug":"how-to-get-your-google-sheets-api-key","status":"publish","type":"knowledgebase","link":"https:\/\/buzapps.net\/info\/knowledgebase\/how-to\/how-to-get-your-google-sheets-api-key\/","title":{"rendered":"How to get your Google Sheets API Key?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Follow the instructions below to obtain your Google Sheets API Key.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(01) <\/strong>Go to the <a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Google Cloud Console<\/strong><\/a>. If you haven\u2019t used Cloud Console before then Google may ask you to identify your country and agree to its terms of service. Then click on <strong>Agree and Continue<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(02) <\/strong>If you already used the Cloud console before then click on <strong>Select a project<\/strong> from the menu bar and then click on <strong>New Project<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_01-1024x362.jpg\" alt=\"\" class=\"wp-image-14729\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_01-1024x362.jpg 1024w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_01-300x106.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_01-768x272.jpg 768w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_01-1536x543.jpg 1536w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_01.jpg 1575w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(03)<\/strong> In the <strong>Project Name<\/strong> field, enter the name of the new project, for example GS2TABLE and click on <strong>Create<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"949\" height=\"227\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_02.jpg\" alt=\"\" class=\"wp-image-14730\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_02.jpg 949w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_02-300x72.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_02-768x184.jpg 768w\" sizes=\"(max-width: 949px) 100vw, 949px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(04) <\/strong>Now click on a menu icon (three dashes in the upper left corner) and click on <strong>APIs &amp;; Services and Dashboard<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"856\" height=\"264\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_03.jpg\" alt=\"\" class=\"wp-image-14731\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_03.jpg 856w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_03-300x93.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_03-768x237.jpg 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(05)<\/strong> Now check that your project is selected and click on <strong>Enable APIs and Services<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"856\" height=\"753\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04.jpg\" alt=\"\" class=\"wp-image-14732\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04.jpg 856w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04-300x264.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04-768x676.jpg 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Then select:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"856\" height=\"753\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04-1.jpg\" alt=\"\" class=\"wp-image-14733\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04-1.jpg 856w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04-1-300x264.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_04-1-768x676.jpg 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(06) <\/strong>A page with all API services will be opened. Search for <strong>Google Sheets API<\/strong> there and <strong>click on it<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"448\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_06.jpg\" alt=\"\" class=\"wp-image-14734\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_06.jpg 900w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_06-300x149.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_06-768x382.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Then select:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"337\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_07.jpg\" alt=\"\" class=\"wp-image-14735\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_07.jpg 900w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_07-300x112.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_07-768x288.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(07)<\/strong> Click on the <strong>Enable button<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"600\" height=\"439\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_08.jpg\" alt=\"\" class=\"wp-image-14736\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_08.jpg 600w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_08-300x220.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(08)<\/strong> Now select <strong>Credentials<\/strong> from the left side menu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"280\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_09.jpg\" alt=\"\" class=\"wp-image-14737\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_09.jpg 900w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_09-300x93.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_09-768x239.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(09)<\/strong> Now click on <strong>Credentials in APIs and Services<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"495\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_10a.jpg\" alt=\"\" class=\"wp-image-14738\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_10a.jpg 900w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_10a-300x165.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_10a-768x422.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(10)<\/strong> Now click on <strong>CREATE CREDENTIALS<\/strong> and select <strong>API Key<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(11)<\/strong> Now in few seconds <strong>your API Key will be displayed<\/strong> on your screen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"900\" height=\"464\" src=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_11.jpg\" alt=\"\" class=\"wp-image-14740\" srcset=\"https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_11.jpg 900w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_11-300x155.jpg 300w, https:\/\/buzapps.net\/info\/wp-content\/uploads\/2023\/11\/knowledgebase_googel_sheets_api_key_11-768x396.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(12) <\/strong><strong>Copy the API Key<\/strong> and <strong>paste it in the appropriate section in your App Manager<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>(13)<\/strong> If not already, get your <a rel=\"noreferrer noopener\" href=\"https:\/\/buzapps.net\/pages\/dwkb\/how-do-i-get-my-google-sheets-id-name\/\" target=\"_blank\"><strong>Google Sheets ID and Name, and set the Permissions<\/strong><\/a> for your Spreadsheet.  If you did this already, you&#8217;re done. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Follow the instructions below to obtain your Google Sheets API Key. (01) Go to the Google Cloud Console. If you haven\u2019t used Cloud Console before then Google may ask you to identify your country and agree to its terms of service. Then click on Agree and Continue. (02) If you already used the Cloud console before then click on Select a project from the menu bar and then click on New Project. (03) In the Project Name field, enter the name of the new project, for example GS2TABLE and click on Create. (04) Now click on a menu icon (three<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","knowledgebase_cat":[35],"class_list":["post-13365","knowledgebase","type-knowledgebase","status-publish","hentry","knowledgebase_cat-how-to"],"_links":{"self":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase\/13365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase"}],"about":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/types\/knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/comments?post=13365"}],"version-history":[{"count":3,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase\/13365\/revisions"}],"predecessor-version":[{"id":14741,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase\/13365\/revisions\/14741"}],"wp:attachment":[{"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/media?parent=13365"}],"wp:term":[{"taxonomy":"knowledgebase_cat","embeddable":true,"href":"https:\/\/buzapps.net\/info\/wp-json\/wp\/v2\/knowledgebase_cat?post=13365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}