{"id":3847,"date":"2023-11-08T13:50:40","date_gmt":"2023-11-08T13:50:40","guid":{"rendered":"https:\/\/addify.store\/documentation\/?page_id=3847"},"modified":"2023-11-08T13:50:42","modified_gmt":"2023-11-08T13:50:42","slug":"setting-up-google-sheet-connector-for-woocommerce","status":"publish","type":"page","link":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/","title":{"rendered":"Setting Up Google Sheet Connector for WooCommerce\u00a0"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Connecting Google Sheets to Your Store<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Adding Multiple Google Sheets<\/h3>\n\n\n\n<p>Go to <strong>WooCommerce <\/strong>&gt;<strong> Google Sheets<\/strong>.<\/p>\n\n\n\n<p>Here you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>View a complete list of Google Sheets created<\/li>\n\n\n\n<li>Perform bulk actions to edit or delete a Google Sheet<\/li>\n\n\n\n<li>Filter Google Sheets by dates<\/li>\n\n\n\n<li>Search for a specific Google Sheet using the search bar<\/li>\n<\/ul>\n\n\n\n<p>Click on the <strong>&#8220;Add New Post&#8221;<\/strong> button to create a new Google Sheet.&nbsp;<\/p>\n\n\n\n<p>Fill in the following details:<\/p>\n\n\n\n<p><strong>Add Title: <\/strong>Enter a title for your Google Sheet<\/p>\n\n\n\n<p><strong>Google Sheets Connector:<\/strong><\/p>\n\n\n\n<p>Click on<strong> \u201cAdd New Sheet\u201d<\/strong><\/p>\n\n\n\n<p><strong>Google Sheet ID: <\/strong>Enter the Google Sheet ID<\/p>\n\n\n\n<p><strong>Google Sheet Name and Range: <\/strong>Define the range of the sheet, which must be selected from A to AM<\/p>\n\n\n\n<p><strong>Map Form Fields:<\/strong><\/p>\n\n\n\n<p><strong>Webhook Key:<\/strong> Provide a webhook key<\/p>\n\n\n\n<p><strong>Form Field: <\/strong>Select the desired field from the dropdown menu<\/p>\n\n\n\n<p>Add multiple rows or take action to delete any form field as needed.<\/p>\n\n\n\n<p>Click on<strong> &#8220;Sync Entries&#8221; <\/strong>to synchronize your data with the Google Sheet. Please remember to save your changes before initiating the sync<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/bI-FY3I5o5H9ItzGWGHEeZVKmi6CnZuXiDUgk1miNbIyB0wcKLBmhzqzjG843esrfVxiqvZ3ulf8k7TgKXQx5acqSzZpWFcrI-5CcurVXg8jLCVilH7G2hG7iJGq4GqCPY2cVxgTdb0Dj4gIrBYajYQ\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Configuring Authentication Settings<\/h3>\n\n\n\n<p>Authentication settings ensure secure access to your Google Sheets.&nbsp;<\/p>\n\n\n\n<p>Go to <strong>WooCommerce <\/strong>&gt;<strong> Google Sheets<\/strong> &gt; <strong>Google Sheet Connector Settings<\/strong>.<\/p>\n\n\n\n<p><strong>Authentication Settings:<\/strong><\/p>\n\n\n\n<p><strong>Upload Credentials.json File: <\/strong>Upload the credentials.json file associated with your Google account<\/p>\n\n\n\n<p><strong>App Name: <\/strong>Enter the name of your application<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-us.googleusercontent.com\/FpIoGHJrVR5EjppFO-G5NGneRw5OIyYYY0fUllYhdQW4hI3-z_aY6ZmcHXqLNyAdlWaD1xLQKeREW2TTr4dP95xnMnW-KoP2eCjpdBAVNxymJ7_AbbrxrI0G8cJ0JBy06dNn83ZtvX-zmZIIxdCaDL8\" alt=\"\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Connecting Google Sheets to Your Store Adding Multiple Google Sheets Go to WooCommerce &gt; Google Sheets. Here you can: Click on the &#8220;Add New Post&#8221; button to create a new Google Sheet.&nbsp; Fill in the following details: Add Title: Enter a title for your Google Sheet Google Sheets Connector: Click on \u201cAdd New Sheet\u201d Google [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1753,"parent":3839,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"template-parts\/documentation-template.php","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"class_list":["post-3847","page","type-page","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Setting Up Google Sheet Connector for WooCommerce\u00a0 - Documentation<\/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:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting Up Google Sheet Connector for WooCommerce\u00a0 - Documentation\" \/>\n<meta property=\"og:description\" content=\"Connecting Google Sheets to Your Store Adding Multiple Google Sheets Go to WooCommerce &gt; Google Sheets. Here you can: Click on the &#8220;Add New Post&#8221; button to create a new Google Sheet.&nbsp; Fill in the following details: Add Title: Enter a title for your Google Sheet Google Sheets Connector: Click on \u201cAdd New Sheet\u201d Google [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/\" \/>\n<meta property=\"og:site_name\" content=\"Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T13:50:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/06\/database-usage.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\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:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/\",\"url\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/\",\"name\":\"Setting Up Google Sheet Connector for WooCommerce\u00a0 - Documentation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/addify.store\\\/documentation\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/database-usage.png\",\"datePublished\":\"2023-11-08T13:50:40+00:00\",\"dateModified\":\"2023-11-08T13:50:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/#primaryimage\",\"url\":\"https:\\\/\\\/addify.store\\\/documentation\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/database-usage.png\",\"contentUrl\":\"https:\\\/\\\/addify.store\\\/documentation\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/database-usage.png\",\"width\":512,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/setting-up-google-sheet-connector-for-woocommerce\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/addify.store\\\/documentation\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WooCommerce\",\"item\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Google Sheet Connector for WooCommerce\",\"item\":\"https:\\\/\\\/addify.store\\\/documentation\\\/woocommerce\\\/google-sheet-connector-for-woocommerce\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Setting Up Google Sheet Connector for WooCommerce\u00a0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/#website\",\"url\":\"https:\\\/\\\/addify.store\\\/documentation\\\/\",\"name\":\"Documentation\",\"description\":\"Documentation for Addify Extensions\",\"publisher\":{\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/addify.store\\\/documentation\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/#organization\",\"name\":\"Documentation\",\"url\":\"https:\\\/\\\/addify.store\\\/documentation\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/addify.store\\\/documentation\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Asset-21-2x.png\",\"contentUrl\":\"https:\\\/\\\/addify.store\\\/documentation\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/Asset-21-2x.png\",\"width\":6761,\"height\":1853,\"caption\":\"Documentation\"},\"image\":{\"@id\":\"https:\\\/\\\/addify.store\\\/documentation\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Setting Up Google Sheet Connector for WooCommerce\u00a0 - Documentation","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:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/","og_locale":"en_US","og_type":"article","og_title":"Setting Up Google Sheet Connector for WooCommerce\u00a0 - Documentation","og_description":"Connecting Google Sheets to Your Store Adding Multiple Google Sheets Go to WooCommerce &gt; Google Sheets. Here you can: Click on the &#8220;Add New Post&#8221; button to create a new Google Sheet.&nbsp; Fill in the following details: Add Title: Enter a title for your Google Sheet Google Sheets Connector: Click on \u201cAdd New Sheet\u201d Google [&hellip;]","og_url":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/","og_site_name":"Documentation","article_modified_time":"2023-11-08T13:50:42+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/06\/database-usage.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:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/","url":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/","name":"Setting Up Google Sheet Connector for WooCommerce\u00a0 - Documentation","isPartOf":{"@id":"https:\/\/addify.store\/documentation\/#website"},"primaryImageOfPage":{"@id":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/#primaryimage"},"image":{"@id":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/#primaryimage"},"thumbnailUrl":"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/06\/database-usage.png","datePublished":"2023-11-08T13:50:40+00:00","dateModified":"2023-11-08T13:50:42+00:00","breadcrumb":{"@id":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/#primaryimage","url":"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/06\/database-usage.png","contentUrl":"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/06\/database-usage.png","width":512,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/setting-up-google-sheet-connector-for-woocommerce\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/addify.store\/documentation\/"},{"@type":"ListItem","position":2,"name":"WooCommerce","item":"https:\/\/addify.store\/documentation\/woocommerce\/"},{"@type":"ListItem","position":3,"name":"Google Sheet Connector for WooCommerce","item":"https:\/\/addify.store\/documentation\/woocommerce\/google-sheet-connector-for-woocommerce\/"},{"@type":"ListItem","position":4,"name":"Setting Up Google Sheet Connector for WooCommerce\u00a0"}]},{"@type":"WebSite","@id":"https:\/\/addify.store\/documentation\/#website","url":"https:\/\/addify.store\/documentation\/","name":"Documentation","description":"Documentation for Addify Extensions","publisher":{"@id":"https:\/\/addify.store\/documentation\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/addify.store\/documentation\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/addify.store\/documentation\/#organization","name":"Documentation","url":"https:\/\/addify.store\/documentation\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/addify.store\/documentation\/#\/schema\/logo\/image\/","url":"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/11\/Asset-21-2x.png","contentUrl":"https:\/\/addify.store\/documentation\/wp-content\/uploads\/2023\/11\/Asset-21-2x.png","width":6761,"height":1853,"caption":"Documentation"},"image":{"@id":"https:\/\/addify.store\/documentation\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/pages\/3847","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/comments?post=3847"}],"version-history":[{"count":1,"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/pages\/3847\/revisions"}],"predecessor-version":[{"id":3848,"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/pages\/3847\/revisions\/3848"}],"up":[{"embeddable":true,"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/pages\/3839"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/media\/1753"}],"wp:attachment":[{"href":"https:\/\/addify.store\/documentation\/wp-json\/wp\/v2\/media?parent=3847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}