{"id":2578,"date":"2021-12-29T14:39:44","date_gmt":"2021-12-29T09:09:44","guid":{"rendered":"https:\/\/westerndeal.com\/?p=2578"},"modified":"2021-12-29T14:39:44","modified_gmt":"2021-12-29T09:09:44","slug":"save-new-woocommerce-orders-to-google-sheets","status":"publish","type":"post","link":"https:\/\/westerndeal.com\/westerndeal-new\/blog\/save-new-woocommerce-orders-to-google-sheets\/","title":{"rendered":"Save New WooCommerce Orders to Google Sheets"},"content":{"rendered":"<div class=\"vgblk-rw-wrapper limit-wrapper\"><em><strong>WooCommerce Google Sheet Connector<\/strong><\/em>\u00a0is a powerful, flexible, and best connector plugin, a bridge between\u00a0<a href=\"https:\/\/wordpress.org\/plugins\/woocommerce\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>WooCommerce<\/strong><\/a>\u00a0and\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Google Sheet<\/strong><\/a>. GSheetConnector For the\u00a0<strong><em>WooCommerce<\/em>\u00a0<\/strong>plugin sync with your WooCommerce Orders, Products, Customers, Coupons, and Events to a single Google Spreadsheet.<\/p>\n<p>To setup you need:<\/p>\n<ul>\n<li>WordPress website with\u00a0<a href=\"http:\/\/woocommerce.com\/\" target=\"_blank\" rel=\"noopener\">WooCommerce<\/a>\u00a0installed<\/li>\n<li><a href=\"http:\/\/www.google.com\/sheets\/about\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a>\u00a0account<\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wc-gsheetconnector\/\" target=\"_blank\" rel=\"noopener\">WooCommerce Google Sheet<\/a> Add-on Plugin (PRO version of <a href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro\" target=\"_blank\" rel=\"noopener\">WooCommerce Google Sheet<\/a>)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h1>Installation of WooCommerce Google Sheet<\/h1>\n<p>Installing of WooCommerce Google Sheet Addon is simple like other plugins, After Installing the plugin, it requires to authenticate with Google, which is safe and secure.<\/p>\n<p><strong>Navigate to WooCommerce\u00a0 \u21d2\u00a0 Google Sheet\u00a0 \u2192 Integration Tab<\/strong><\/p>\n<p>You will see two methods to connect with Google, For quick connection use (Auto Google API Configuration)<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-2585\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Auth-1.png\" alt=\"\" width=\"1256\" height=\"872\" srcset=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Auth-1.png 1256w, https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Auth-1-300x208.png 300w, https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Auth-1-1024x711.png 1024w, https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Auth-1-768x533.png 768w\" sizes=\"(max-width: 1256px) 100vw, 1256px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Click on Sign in with Google to get the Auth Code, It requires enabling the Permissions of<span style=\"text-decoration: underline;\"><em><strong> Google Drive<\/strong><\/em><\/span> and <span style=\"text-decoration: underline;\"><em><strong>Google Sheets<\/strong><\/em><\/span> Manually.<br \/>\nYou must have to allow the permissions, then only orders will be sent to google sheets, without permission it will not work.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2584\" src=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Permisssions-1.1.png\" alt=\"\" width=\"515\" height=\"1078\" srcset=\"https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Permisssions-1.1.png 515w, https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Permisssions-1.1-143x300.png 143w, https:\/\/westerndeal.com\/westerndeal-new\/wp-content\/uploads\/2021\/12\/WooCommerce-Google-Permisssions-1.1-489x1024.png 489w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/><\/p>\n<p>Once you click on Continue, you will get a code, copy the code and paste in the box and click on <span style=\"text-decoration: underline;\"><strong>Save &amp; Authenticate<\/strong><\/span><\/p>\n<p>Once you Save, it will reload and show you a connected email account, and you are done with the google integration.<\/p>\n<p>Then <strong>Navigate to WooCommerce\u00a0 \u21d2\u00a0 Google Sheet\u00a0 \u2192 Integration Tab<\/strong> to configure.<\/p>\n<p>Select the Spreadsheet, Select the Sheet Names below and you are done.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2584\" src=\"https:\/\/www.gsheetconnector.com\/wp-content\/uploads\/2021\/11\/WooCommerce-Google-Sheet-Settings-2.png\" alt=\"WooCommerce Google Sheet Settings\" \/><\/p>\n<p>Now Whenever you get a new order in real-time, the order details will be sent to google sheet.<\/p>\n<h1>Benefits of WooCommerce Google Sheet Connector PRO version<\/h1>\n<ul>\n<li>You&#8217;ll get the <strong>Click here to fetch button<\/strong> to get all the past records.<\/li>\n<li>More Sheets will be created, like <strong>All Orders<\/strong> to get all the Status details in one sheet, which can be sortable easily.<\/li>\n<li>Freeze Header which helps to scroll the large sheets easily<\/li>\n<li>Various Header Color Options<\/li>\n<li>Various Odd\/Even Color Options<\/li>\n<li>Sync Order and Download Order Options<\/li>\n<li>Compatible with multisite and multi-language sites.<\/li>\n<li>Compatible with various addons.<\/li>\n<li>and many more.<\/li>\n<\/ul>\n<p>If you have any queries then reach the developer at <a href=\"mailto:helpdesk@gsheetconnector.com\"><strong>helpdesk@gsheetconnector.com<\/strong><\/a><\/p>\n<p>Hope you like the article, feel free to give comments below. Thanks<\/p><\/div>\n<p><!-- .vgblk-rw-wrapper --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>WooCommerce Google Sheet Connector\u00a0is a powerful, flexible, and best connector plugin, a bridge between\u00a0WooCommerce\u00a0and\u00a0Google Sheet. GSheetConnector For the\u00a0WooCommerce\u00a0plugin sync with your WooCommerce Orders, Products, Customers, Coupons, and Events to a single Google Spreadsheet. To setup you need: WordPress website with\u00a0WooCommerce\u00a0installed Google Sheets\u00a0account WooCommerce Google Sheet Add-on Plugin (PRO version of WooCommerce Google Sheet) &nbsp; Installation&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2601,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[64,63,66,65],"tags":[78,79,80,81,82],"class_list":["post-2578","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ecommerce","category-wordpress","category-wordpress-beginner","category-wp-plugins","tag-ecommerce","tag-google-sheets","tag-woocommerce","tag-woocommerce-google-sheets","tag-woocommerce-to-google-sheet"],"_links":{"self":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/2578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/comments?post=2578"}],"version-history":[{"count":0,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/posts\/2578\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/media\/2601"}],"wp:attachment":[{"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/media?parent=2578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/categories?post=2578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/westerndeal.com\/westerndeal-new\/wp-json\/wp\/v2\/tags?post=2578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}