{"id":154,"date":"2026-10-17T14:16:04","date_gmt":"2026-10-17T14:16:04","guid":{"rendered":"http:\/\/plugin-docs.com\/?post_type=doc&#038;p=154"},"modified":"2026-10-18T11:52:50","modified_gmt":"2026-10-18T11:52:50","slug":"google-sheets-integration","status":"publish","type":"doc","link":"https:\/\/dragwyb.com\/docs\/google-sheets-integration\/","title":{"rendered":"Send Workflow Data to Google Sheets"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The plugin registers Google Sheets actions for spreadsheet, worksheet, and row operations. These actions use a saved Google OAuth 2 connection. You provide the spreadsheet ID and sheet tab or other action-specific values; the inspected builder does not make a universal spreadsheet-and-worksheet picker available for every action.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prepare Google OAuth<\/h2>\n\n\n\n\n<li>Create OAuth client credentials in Google Cloud Console using a Web application client.<\/li>\n\n\n<li>Enable the <strong>Google Sheets API<\/strong> and <strong>Google Drive API<\/strong> for that project.<\/li>\n\n\n<li>Open <strong>Agent Workflows \u2192 Connections \u2192 Add New<\/strong>. Set the Integration identifier to <code>google_sheets<\/code>, enter a label, and choose <strong>OAuth 2<\/strong>.<\/li>\n\n\n<li>Copy the displayed <strong>Callback URL<\/strong> into the Google OAuth client&#8217;s authorized redirect URIs. Enter the <strong>Client ID<\/strong> and <strong>Client Secret<\/strong>, then save the connection.<\/li>\n\n\n<li>Edit the saved connection and click <strong>Connect with Google<\/strong>. Complete Google&#8217;s authorization flow and return to WordPress.<\/li>\n\n\n\n\n\n<p class=\"wp-block-paragraph\">Screenshot to add: Google OAuth connection form with Callback URL and Connect with Google<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Choose a Google Sheets action<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The built-in action catalog includes <strong>Google Sheets Create Spreadsheet<\/strong>, <strong>Google Sheets Find Spreadsheets<\/strong>, <strong>Google Sheets Delete Spreadsheet<\/strong>, <strong>Google Sheets Create Sheet<\/strong>, <strong>Google Sheets Find Sheet<\/strong>, <strong>Google Sheets Copy Sheet<\/strong>, <strong>Google Sheets Delete Sheet<\/strong>, <strong>Google Sheets Clear Sheet<\/strong>, <strong>Google Sheets Export Sheet<\/strong>, <strong>Google Sheets Add Row<\/strong>, <strong>Google Sheets Append Row<\/strong> (legacy), <strong>Google Sheets Update Row<\/strong>, <strong>Google Sheets Append or Update Row<\/strong>, <strong>Google Sheets Get Row<\/strong>, <strong>Google Sheets Get All Rows<\/strong>, <strong>Google Sheets Delete Row<\/strong>, and <strong>Google Sheets Create Column<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For new row-insertion workflows, prefer <strong>Google Sheets Add Row<\/strong>. The legacy <strong>Google Sheets Append Row<\/strong> action remains registered for backward compatibility.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Configure a row action<\/h2>\n\n\n\n\n<li><strong>Google connection:<\/strong> Select the saved Google OAuth connection.<\/li>\n\n\n<li><strong>Spreadsheet ID (from the sheet URL):<\/strong> Enter the ID from the Google Sheets URL.<\/li>\n\n\n<li><strong>Sheet tab name:<\/strong> Enter the worksheet tab name. The default is <code>Sheet1<\/code>.<\/li>\n\n\n<li><strong>Row values, comma-separated (supports {{trigger.fields.*}}):<\/strong> Supply values in the order they should be written. Use the supported trigger-field tokens when mapping submission data.<\/li>\n\n\n<li>Some actions expose extra fields, such as <strong>Row number (1-based)<\/strong>, <strong>Target range (optional, e.g. A5:E5)<\/strong>, or <strong>Column to match on (letter or index, e.g. A or 0)<\/strong>. Use the fields shown for the selected action.<\/li>\n\n\n\n\n\n<p class=\"wp-block-paragraph\">Screenshot to add: Google Sheets Add Row configuration with connection, spreadsheet ID, sheet tab, and row values<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Review results and protect spreadsheet data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Google Sheets actions return a success flag and response data; row-write actions can include an updated range when the API returns one. A successful node result is evidence of the API response, not a separate manual confirmation that every expected cell is correct. Inspect the action output and verify the target sheet during testing.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Use a test spreadsheet first, map only necessary fields, and avoid sending sensitive customer information to a sheet unless its access permissions and retention are appropriate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use supported Google Sheets actions to store or update workflow data.<\/p>\n","protected":false},"author":0,"featured_media":0,"parent":151,"menu_order":0,"template":"","class_list":["post-154","doc","type-doc","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/doc\/154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/doc"}],"about":[{"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/types\/doc"}],"version-history":[{"count":1,"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/doc\/154\/revisions"}],"predecessor-version":[{"id":888,"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/doc\/154\/revisions\/888"}],"up":[{"embeddable":true,"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/doc\/151"}],"wp:attachment":[{"href":"https:\/\/dragwyb.com\/docs\/wp-json\/wp\/v2\/media?parent=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}