{"id":3734,"date":"2026-07-16T10:30:51","date_gmt":"2026-07-16T10:30:51","guid":{"rendered":"https:\/\/wpbot.pro\/docs\/?post_type=kbx_knowledgebase&#038;p=3734"},"modified":"2026-07-16T11:13:37","modified_gmt":"2026-07-16T11:13:37","slug":"google-service-account-setup-guide-google-sheets-integration-wpbot-automator","status":"publish","type":"kbx_knowledgebase","link":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/","title":{"rendered":"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator"},"content":{"rendered":"<div id=\"kbx_toc_container\" class=\"kbx_toc_basic no_bullets\"><ul class=\"kbx_toc_list\"><li><a href=\"#step-1-create-a-google-cloud-project\">Step 1: Create a Google Cloud Project<\/a><\/li><li><a href=\"#step-2-enable-google-sheets-api\">Step 2: Enable Google Sheets API<\/a><\/li><li><a href=\"#step-3-create-a-service-account\">Step 3: Create a Service Account<\/a><\/li><li><a href=\"#step-4-create-the-service-account-json-key\">Step 4: Create the Service Account JSON Key<\/a><\/li><li><a href=\"#step-5-get-the-service-account-email\">Step 5: Get the Service Account Email<\/a><\/li><li><a href=\"#step-6-share-your-google-sheet\">Step 6: Share Your Google Sheet<\/a><\/li><li><a href=\"#step-7-get-the-sheet-id\">Step 7: Get the Sheet ID<\/a><\/li><li><a href=\"#step-8-get-the-sheet-name\">Step 8: Get the Sheet Name<\/a><\/li><li><a href=\"#final-configuration\">Final Configuration<\/a><\/li><li><a href=\"#1-service-account-json\">1. Service Account JSON<\/a><\/li><li><a href=\"#2-sheet-id\">2. Sheet ID<\/a><\/li><li><a href=\"#3-sheet-name\">3. Sheet Name<\/a><\/li><li><a href=\"#example-configuration\">Example Configuration<\/a><\/li><\/ul><\/div>\n<p class=\"PDq2pG_selectionAnchorContainer\" data-start=\"66\" data-end=\"223\">This guide explains how to configure a <strong data-start=\"105\" data-end=\"131\">Google Service Account<\/strong> and connect it to a <strong data-start=\"152\" data-end=\"168\">Google Sheet<\/strong>. At the end, you will have the following three values:<\/p>\n<ol data-start=\"225\" data-end=\"300\">\n<li data-section-id=\"1gubdxa\" data-start=\"225\" data-end=\"252\"><strong data-start=\"228\" data-end=\"252\">Service Account JSON<\/strong><\/li>\n<li data-section-id=\"1niprbm\" data-start=\"253\" data-end=\"275\"><strong data-start=\"256\" data-end=\"275\">Google Sheet ID<\/strong><\/li>\n<li data-section-id=\"1hcl8rd\" data-start=\"276\" data-end=\"300\"><strong data-start=\"279\" data-end=\"300\">Google Sheet Name<\/strong>\n<ul data-start=\"225\" data-end=\"300\">\n<li data-section-id=\"1hcl8rd\" data-start=\"276\" data-end=\"300\"><strong style=\"font-size: 16px;\" data-start=\"304\" data-end=\"321\">Prerequisites<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul data-start=\"326\" data-end=\"396\">\n<li data-section-id=\"xmvd1d\" data-start=\"326\" data-end=\"344\">A Google account<\/li>\n<li data-section-id=\"1jlf2pw\" data-start=\"347\" data-end=\"371\">A Google Cloud Project<\/li>\n<li data-section-id=\"fxdby6\" data-start=\"374\" data-end=\"396\">A Google Spreadsheet<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr data-start=\"398\" data-end=\"401\" \/>\n<h1 data-section-id=\"1cs46uv\" data-start=\"403\" data-end=\"442\"><span id=\"step-1-create-a-google-cloud-project\">Step 1: Create a Google Cloud Project<\/span><\/h1>\n<ol data-start=\"444\" data-end=\"675\">\n<li data-section-id=\"f6x07q\" data-start=\"444\" data-end=\"477\">Open the Google Cloud Console.<\/li>\n<li data-section-id=\"acx6u4\" data-start=\"478\" data-end=\"504\">Go to <strong data-start=\"487\" data-end=\"503\">Console Home<\/strong>.<\/li>\n<li data-section-id=\"1oto4rp\" data-start=\"505\" data-end=\"533\">Click <strong data-start=\"514\" data-end=\"532\">Select Project<\/strong>.<\/li>\n<li data-section-id=\"18q5dpy\" data-start=\"534\" data-end=\"559\">Click <strong data-start=\"543\" data-end=\"558\">New Project<\/strong>.<\/li>\n<li data-section-id=\"n5r72i\" data-start=\"560\" data-end=\"616\">Enter:\n<ul data-start=\"573\" data-end=\"616\">\n<li data-section-id=\"idyd22\" data-start=\"573\" data-end=\"587\">Project Name<\/li>\n<li data-section-id=\"1p3j7q4\" data-start=\"591\" data-end=\"616\">Organization (optional)<\/li>\n<\/ul>\n<\/li>\n<li data-section-id=\"1ysbv38\" data-start=\"617\" data-end=\"675\">Click <strong data-start=\"626\" data-end=\"636\">Create<\/strong>.<\/li>\n<\/ol>\n<hr data-start=\"677\" data-end=\"680\" \/>\n<h1 data-section-id=\"1eaks1c\" data-start=\"682\" data-end=\"716\"><span id=\"step-2-enable-google-sheets-api\">Step 2: Enable Google Sheets API<\/span><\/h1>\n<ol data-start=\"718\" data-end=\"775\">\n<li data-section-id=\"1qegk32\" data-start=\"718\" data-end=\"760\">Open <strong data-start=\"726\" data-end=\"745\">APIs &amp; Services<\/strong> \u2192 <strong data-start=\"748\" data-end=\"759\">Library<\/strong>.<\/li>\n<li data-section-id=\"1jgr5xy\" data-start=\"761\" data-end=\"775\">Search for:<code style=\"font-style: inherit; font-weight: inherit;\">Google Sheets API<\/code><\/li>\n<\/ol>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<ol start=\"3\" data-start=\"804\" data-end=\"837\">\n<li data-section-id=\"14afvz9\" data-start=\"804\" data-end=\"816\">Click it.<\/li>\n<li data-section-id=\"19ko3ku\" data-start=\"817\" data-end=\"837\">Click <strong data-start=\"826\" data-end=\"836\">Enable<\/strong>.<\/li>\n<\/ol>\n<p data-start=\"891\" data-end=\"1003\">This is useful if your application needs to locate or manage spreadsheets.<\/p>\n<hr data-start=\"1005\" data-end=\"1008\" \/>\n<h1 data-section-id=\"b51wtg\" data-start=\"1010\" data-end=\"1044\"><span id=\"step-3-create-a-service-account\">Step 3: Create a Service Account<\/span><\/h1>\n<p data-start=\"1046\" data-end=\"1051\">Open:<\/p>\n<p data-start=\"1053\" data-end=\"1111\"><a class=\"decorated-link\" href=\"https:\/\/console.cloud.google.com\/iam-admin\/serviceaccounts\" target=\"_new\" rel=\"noopener\" data-start=\"1053\" data-end=\"1111\">https:\/\/console.cloud.google.com\/iam-admin\/serviceaccounts<\/a><\/p>\n<p data-start=\"1113\" data-end=\"1128\">or navigate to:<\/p>\n<p data-start=\"1130\" data-end=\"1164\"><strong data-start=\"1130\" data-end=\"1164\">IAM &amp; Admin \u2192 Service Accounts<\/strong><\/p>\n<p data-start=\"1166\" data-end=\"1171\">Click<code style=\"font-style: inherit; font-weight: inherit;\">Create Service Account<\/code><\/p>\n<p data-start=\"1205\" data-end=\"1213\">Fill in:<\/p>\n<div class=\"TyagGW_tableContainer\">\n<div class=\"group TyagGW_tableWrapper flex flex-col-reverse w-fit\" tabindex=\"-1\">\n<table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"1215\" data-end=\"1379\">\n<thead data-start=\"1215\" data-end=\"1234\">\n<tr data-start=\"1215\" data-end=\"1234\">\n<th class=\"last:pe-10\" data-start=\"1215\" data-end=\"1223\" data-col-size=\"sm\">Field<\/th>\n<th class=\"last:pe-10\" data-start=\"1223\" data-end=\"1234\" data-col-size=\"sm\">Example<\/th>\n<\/tr>\n<\/thead>\n<tbody data-start=\"1256\" data-end=\"1379\">\n<tr data-start=\"1256\" data-end=\"1295\">\n<td data-start=\"1256\" data-end=\"1279\" data-col-size=\"sm\">Service Account Name<\/td>\n<td data-col-size=\"sm\" data-start=\"1279\" data-end=\"1295\">sheet-access<\/td>\n<\/tr>\n<tr data-start=\"1296\" data-end=\"1335\">\n<td data-start=\"1296\" data-end=\"1317\" data-col-size=\"sm\">Service Account ID<\/td>\n<td data-col-size=\"sm\" data-start=\"1317\" data-end=\"1335\">auto-generated<\/td>\n<\/tr>\n<tr data-start=\"1336\" data-end=\"1379\">\n<td data-start=\"1336\" data-end=\"1350\" data-col-size=\"sm\">Description<\/td>\n<td data-col-size=\"sm\" data-start=\"1350\" data-end=\"1379\">Google Sheets Integration<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p data-start=\"1381\" data-end=\"1386\">Click<code style=\"font-style: inherit; font-weight: inherit;\">Create and Continue<\/code><\/p>\n<p data-start=\"1417\" data-end=\"1516\">You can skip assigning roles if your application only needs access to specific shared spreadsheets.<\/p>\n<p data-start=\"1518\" data-end=\"1523\">Click<code style=\"font-style: inherit; font-weight: inherit;\">Done<\/code><\/p>\n<p data-start=\"1539\" data-end=\"1613\">Your Service Account is now created.<\/p>\n<hr data-start=\"1615\" data-end=\"1618\" \/>\n<h1 data-section-id=\"1p0xn8\" data-start=\"1620\" data-end=\"1665\"><span id=\"step-4-create-the-service-account-json-key\">Step 4: Create the Service Account JSON Key<\/span><\/h1>\n<p data-start=\"1667\" data-end=\"1693\">Open your Service Account.<\/p>\n<p data-start=\"1695\" data-end=\"1704\">Go to the<code style=\"font-style: inherit; font-weight: inherit;\">Keys<\/code>tab. Click<\/p>\n<p data-start=\"1695\" data-end=\"1704\"><code style=\"font-style: inherit; font-weight: inherit;\">Add Key-&gt;<\/code><code style=\"font-style: inherit; font-weight: inherit;\">Create New Key<\/code><span style=\"font-size: 16px;\">Choose-&gt;<\/span><code style=\"font-style: inherit; font-weight: inherit;\">JSON<\/code><span style=\"font-size: 16px;\">Click<\/span><code style=\"font-style: inherit; font-weight: inherit;\">Create<\/code><\/p>\n<p data-start=\"1822\" data-end=\"1879\">A JSON file will automatically download to your computer.<\/p>\n<p data-start=\"1881\" data-end=\"1889\">Example:<code style=\"font-style: inherit; font-weight: inherit;\">my-service-account.json<\/code><\/p>\n<p data-start=\"1924\" data-end=\"2085\">Keep this file secure. Google only lets you download the private key once; if you lose it, you&#8217;ll need to create a new key.<\/p>\n<hr data-start=\"2087\" data-end=\"2090\" \/>\n<h1 data-section-id=\"1qegns4\" data-start=\"2092\" data-end=\"2131\"><span id=\"step-5-get-the-service-account-email\">Step 5: Get the Service Account Email<\/span><\/h1>\n<p data-start=\"2133\" data-end=\"2163\">Open the downloaded JSON file.<\/p>\n<p data-start=\"2165\" data-end=\"2170\">Find:<\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>{\r\n  \"client_email\": <span class=\"\u037ck\">\"sheet-access@my-project.iam.gserviceaccount.com\"<\/span>\r\n}<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2257\" data-end=\"2274\">Copy the value of<code style=\"font-style: inherit; font-weight: inherit;\">client_email<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2298\" data-end=\"2306\">Example:<code style=\"font-style: inherit; font-weight: inherit;\">sheet-access@my-project.iam.gserviceaccount.com<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"2365\" data-end=\"2368\" \/>\n<h1 data-section-id=\"1my85ia\" data-start=\"2370\" data-end=\"2403\"><span id=\"step-6-share-your-google-sheet\">Step 6: Share Your Google Sheet<\/span><\/h1>\n<p data-start=\"2405\" data-end=\"2434\">Open your Google Spreadsheet.<\/p>\n<p data-start=\"2436\" data-end=\"2441\">Click<code style=\"font-style: inherit; font-weight: inherit;\">Share<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2458\" data-end=\"2488\">Add the Service Account email<code style=\"font-style: inherit; font-weight: inherit;\">sheet-access@my-project.iam.gserviceaccount.com<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2547\" data-end=\"2558\">Permission:<code style=\"font-style: inherit; font-weight: inherit;\">Editor<\/code><\/p>\n<p data-start=\"2576\" data-end=\"2581\">Click<code style=\"font-style: inherit; font-weight: inherit;\">Send<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p data-start=\"2597\" data-end=\"2699\">Without sharing the sheet, the Service Account cannot access it.<\/p>\n<hr data-start=\"2701\" data-end=\"2704\" \/>\n<h1 data-section-id=\"kuo6d0\" data-start=\"2706\" data-end=\"2732\"><span id=\"step-7-get-the-sheet-id\">Step 7: Get the Sheet ID<\/span><\/h1>\n<p data-start=\"2734\" data-end=\"2757\">Open your Google Sheet.<\/p>\n<p data-start=\"2759\" data-end=\"2771\">Example URL:<code style=\"font-style: inherit; font-weight: inherit;\">https:\/\/docs.google.com\/spreadsheets\/d\/1AbCdEfGhIjKlMnOpQrStUvWxYz123456789\/edit#gid=0<\/code><\/p>\n<p data-start=\"2869\" data-end=\"2889\">The <strong data-start=\"2873\" data-end=\"2885\">Sheet ID<\/strong> is:<code style=\"font-style: inherit; font-weight: inherit;\">1AbCdEfGhIjKlMnOpQrStUvWxYz123456789<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"2937\" data-end=\"2940\" \/>\n<h1 data-section-id=\"1dylpg1\" data-start=\"2942\" data-end=\"2970\"><span id=\"step-8-get-the-sheet-name\">Step 8: Get the Sheet Name<\/span><\/h1>\n<p data-start=\"2972\" data-end=\"3036\">At the bottom of the spreadsheet, you&#8217;ll see the worksheet tabs.<\/p>\n<p data-start=\"3038\" data-end=\"3046\">Example:<code style=\"font-style: inherit; font-weight: inherit;\">Sheet1<\/code><\/p>\n<p data-start=\"3106\" data-end=\"3143\">This tab name is your <strong data-start=\"3128\" data-end=\"3142\">Sheet Name<\/strong>.<\/p>\n<p data-start=\"3145\" data-end=\"3153\">Example:<code style=\"font-style: inherit; font-weight: inherit;\">Products<\/code><\/p>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"3173\" data-end=\"3176\" \/>\n<h1 data-section-id=\"njmhx6\" data-start=\"3178\" data-end=\"3199\"><span id=\"final-configuration\">Final Configuration<\/span><\/h1>\n<p data-start=\"3201\" data-end=\"3235\">You should now have the following:<\/p>\n<h3 data-section-id=\"1ii7r4t\" data-start=\"3237\" data-end=\"3264\"><span id=\"1-service-account-json\">1. Service Account JSON<\/span><\/h3>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\"><\/div>\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>my-service-account.json<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"\">\n<div class=\"\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"3299\" data-end=\"3302\" \/>\n<h3 data-section-id=\"1up7shk\" data-start=\"3304\" data-end=\"3319\"><span id=\"2-sheet-id\">2. Sheet ID<\/span><\/h3>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\"><\/div>\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>1AbCdEfGhIjKlMnOpQrStUvWxYz123456789<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"3367\" data-end=\"3370\" \/>\n<h3 data-section-id=\"4ei7tf\" data-start=\"3372\" data-end=\"3389\"><span id=\"3-sheet-name\">3. Sheet Name<\/span><\/h3>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\"><\/div>\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>Products<\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<hr data-start=\"3409\" data-end=\"3412\" \/>\n<h1 data-section-id=\"xkiice\" data-start=\"3414\" data-end=\"3437\"><span id=\"example-configuration\">Example Configuration<\/span><\/h1>\n<div class=\"relative w-full mt-4 mb-1\">\n<div class=\"\">\n<div class=\"contents\">\n<div class=\"relative\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"h-full min-h-0 min-w-0\">\n<div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\">\n<div class=\"h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\">\n<div class=\"pointer-events-none absolute end-1.5 top-1 z-2 md:end-2 md:top-1\"><\/div>\n<div class=\"relative\">\n<div class=\"pe-11 pt-3\">\n<div class=\"relative z-0 flex max-w-full\">\n<div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\">\n<div class=\"cm-scroller\">\n<pre class=\"cm-content q9tKkq_readonly m-0\"><code>Service Account JSON:\r\ncredentials.json\r\n\r\nSheet ID:\r\n1AbCdEfGhIjKlMnOpQrStUvWxYz123456789\r\n\r\nSheet Name:\r\nProducts\r\n<img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-3738\" src=\"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png\" alt=\"\" width=\"2258\" height=\"1222\" srcset=\"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png 2258w, https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM-300x162.png 300w, https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM-1024x554.png 1024w, https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM-768x416.png 768w, https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM-1536x831.png 1536w, https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM-2048x1108.png 2048w\" sizes=\"(max-width: 2258px) 100vw, 2258px\" \/><\/code><\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Step 1: Create a Google Cloud ProjectStep 2: Enable Google Sheets APIStep 3: Create a Service AccountStep 4: Create the [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"kbx_category":[24],"kbx_tag":[],"class_list":["post-3734","kbx_knowledgebase","type-kbx_knowledgebase","status-publish","hentry","kbx_category-default-section"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator - WPBot Pro Docs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator - WPBot Pro Docs\" \/>\n<meta property=\"og:description\" content=\"Step 1: Create a Google Cloud ProjectStep 2: Enable Google Sheets APIStep 3: Create a Service AccountStep 4: Create the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/\" \/>\n<meta property=\"og:site_name\" content=\"WPBot Pro Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-16T11:13:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2258\" \/>\n\t<meta property=\"og:image:height\" content=\"1222\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/\",\"url\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/\",\"name\":\"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator - WPBot Pro Docs\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Screenshot-2026-07-16-at-7.10.55-PM.png\",\"datePublished\":\"2026-07-16T10:30:51+00:00\",\"dateModified\":\"2026-07-16T11:13:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Screenshot-2026-07-16-at-7.10.55-PM.png\",\"contentUrl\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/Screenshot-2026-07-16-at-7.10.55-PM.png\",\"width\":2258,\"height\":1222},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Knowledgebase\",\"item\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/knowledgebase\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/#website\",\"url\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/\",\"name\":\"Get the #1 ChatBot for WordPress \u2013 WPBot\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/#\\\/schema\\\/person\\\/770bebd298cfb4e7525960a804bfd88d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/#\\\/schema\\\/person\\\/770bebd298cfb4e7525960a804bfd88d\",\"name\":\"WPBot\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/chatbot-for-wordpress-wpbot-logo-1.png\",\"url\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/chatbot-for-wordpress-wpbot-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/chatbot-for-wordpress-wpbot-logo-1.png\",\"width\":202,\"height\":70,\"caption\":\"WPBot\"},\"logo\":{\"@id\":\"https:\\\/\\\/wpbot.pro\\\/docs\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/chatbot-for-wordpress-wpbot-logo-1.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator - WPBot Pro Docs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/","og_locale":"en_US","og_type":"article","og_title":"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator - WPBot Pro Docs","og_description":"Step 1: Create a Google Cloud ProjectStep 2: Enable Google Sheets APIStep 3: Create a Service AccountStep 4: Create the [&hellip;]","og_url":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/","og_site_name":"WPBot Pro Docs","article_modified_time":"2026-07-16T11:13:37+00:00","og_image":[{"width":2258,"height":1222,"url":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/","url":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/","name":"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator - WPBot Pro Docs","isPartOf":{"@id":"https:\/\/wpbot.pro\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/#primaryimage"},"image":{"@id":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/#primaryimage"},"thumbnailUrl":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png","datePublished":"2026-07-16T10:30:51+00:00","dateModified":"2026-07-16T11:13:37+00:00","breadcrumb":{"@id":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/#primaryimage","url":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png","contentUrl":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2026\/07\/Screenshot-2026-07-16-at-7.10.55-PM.png","width":2258,"height":1222},{"@type":"BreadcrumbList","@id":"https:\/\/wpbot.pro\/docs\/knowledgebase\/google-service-account-setup-guide-google-sheets-integration-wpbot-automator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpbot.pro\/docs\/"},{"@type":"ListItem","position":2,"name":"Knowledgebase","item":"https:\/\/wpbot.pro\/docs\/knowledgebase\/"},{"@type":"ListItem","position":3,"name":"Google Service Account Setup Guide (Google Sheets Integration) \u2014 WPBot Automator"}]},{"@type":"WebSite","@id":"https:\/\/wpbot.pro\/docs\/#website","url":"https:\/\/wpbot.pro\/docs\/","name":"Get the #1 ChatBot for WordPress \u2013 WPBot","description":"","publisher":{"@id":"https:\/\/wpbot.pro\/docs\/#\/schema\/person\/770bebd298cfb4e7525960a804bfd88d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpbot.pro\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/wpbot.pro\/docs\/#\/schema\/person\/770bebd298cfb4e7525960a804bfd88d","name":"WPBot","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2024\/09\/chatbot-for-wordpress-wpbot-logo-1.png","url":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2024\/09\/chatbot-for-wordpress-wpbot-logo-1.png","contentUrl":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2024\/09\/chatbot-for-wordpress-wpbot-logo-1.png","width":202,"height":70,"caption":"WPBot"},"logo":{"@id":"https:\/\/wpbot.pro\/docs\/wp-content\/uploads\/2024\/09\/chatbot-for-wordpress-wpbot-logo-1.png"}}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/kbx_knowledgebase\/3734","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/kbx_knowledgebase"}],"about":[{"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/types\/kbx_knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/comments?post=3734"}],"version-history":[{"count":4,"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/kbx_knowledgebase\/3734\/revisions"}],"predecessor-version":[{"id":3736,"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/kbx_knowledgebase\/3734\/revisions\/3736"}],"wp:attachment":[{"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/media?parent=3734"}],"wp:term":[{"taxonomy":"kbx_category","embeddable":true,"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/kbx_category?post=3734"},{"taxonomy":"kbx_tag","embeddable":true,"href":"https:\/\/wpbot.pro\/docs\/wp-json\/wp\/v2\/kbx_tag?post=3734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}