{"id":2578,"date":"2021-12-29T14:39:44","date_gmt":"2021-12-29T09:09:44","guid":{"rendered":"https:\/\/westerndeal.com\/?p=2578"},"modified":"2026-03-27T07:04:41","modified_gmt":"2026-03-27T07:04:41","slug":"save-new-woocommerce-orders-to-google-sheets","status":"publish","type":"post","link":"https:\/\/westerndeal.com\/elementorkit\/save-new-woocommerce-orders-to-google-sheets\/","title":{"rendered":"Save New WooCommerce Orders to Google Sheets"},"content":{"rendered":"<p><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 nofollow\"><strong>WooCommerce<\/strong><\/a>\u00a0and\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><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\/\" rel=\"nofollow noopener\" target=\"_blank\">WooCommerce<\/a>\u00a0installed<\/li>\n<li><a href=\"http:\/\/www.google.com\/sheets\/about\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheets<\/a>\u00a0account<\/li>\n<li><a href=\"https:\/\/wordpress.org\/plugins\/wc-gsheetconnector\/\" target=\"_blank\" rel=\"noopener nofollow\">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 nofollow\">WooCommerce Google Sheet<\/a>)<\/li>\n<\/ul>\n<h2>Installation of WooCommerce Google Sheet<\/h2>\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<h4><strong>Navigate to WooCommerce\u00a0 \u21d2\u00a0 Google Sheet\u00a0 \u2192 Integration Tab<\/strong><\/h4>\n<p>You will see two methods to connect with Google, For quick connection use (Auto Google API Configuration)<\/p>\n<div class=\"wp-pic-wrapper align-center large\" ><div class=\"wp-pic large plugin scheme11\"  id=\"wp-pic-wc-gsheetconnector\" ><div class=\"wp-pic-large\" style=\"display: none;\">\n\t<div class=\"wp-pic-large-content\">\n\t\t<a class=\"wp-pic-asset-bg\" href=\"https:\/\/wordpress.org\/plugins\/wc-gsheetconnector\/\" target=\"_blank\" title=\"WordPress.org Plugin Page\" rel=\"nofollow noopener\">\n\t\t\t<img decoding=\"async\" src=\"https:\/\/ps.w.org\/wc-gsheetconnector\/assets\/banner-772x250.png?rev=3491672\" alt=\"GSheetConnector for WooCommerce \u2013 Send your Orders and Products to Google Sheet in Real-Time\" title=\"| | |\">\t\t\t<span class=\"wp-pic-asset-bg-title\"><span>GSheetConnector for WooCommerce \u2013 Send your Orders and Products to Google Sheet in Real-Time<\/span><\/span>\n\t\t<\/a>\n\t\t<div class=\"wp-pic-half-first\">\n\t\t\t<a class=\"wp-pic-logo\" href=\"https:\/\/wordpress.org\/plugins\/wc-gsheetconnector\/\" style=\"background-image: url(https:\/\/ps.w.org\/wc-gsheetconnector\/assets\/icon-128x128.gif?rev=3232726 );\" target=\"_blank\" title=\"WordPress.org Plugin Page\" rel=\"nofollow noopener\"><\/a>\n\t\t\t<p class=\"wp-pic-author\">Author(s):\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/profiles.wordpress.org\/westerndeal\/\" rel=\"nofollow noopener\" target=\"_blank\">WesternDeal<\/a>\n\t\t\t\t\t\t\t<\/p>\n\t\t\t<p class=\"wp-pic-version\"><span>Current Version:<\/span> 1.4.7<\/p>\n\t\t\t<p class=\"wp-pic-updated\"><span>Last Updated:<\/span> May 20, 2026<\/p>\n\t\t\t<p><a class=\"wp-pic-dl-link\" href=\"https:\/\/downloads.wordpress.org\/plugin\/wc-gsheetconnector.1.4.7.zip\" title=\"Direct download\" rel=\"nofollow noopener\" target=\"_blank\">Direct Download<\/a><\/p>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"wp-pic-half-last\">\n\t\t\t<div class=\"wp-pic-bottom\">\n\t\t\t\t<div class=\"wp-pic-bar\">\n\t\t\t\t\t<a href=\"https:\/\/wordpress.org\/support\/view\/plugin-reviews\/wc-gsheetconnector\" class=\"wp-pic-rating\" target=\"_blank\" title=\"Ratings\" rel=\"nofollow noopener\">\n\t\t\t\t\t\t100%<em>Ratings<\/em>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t<a href=\"https:\/\/downloads.wordpress.org\/plugin\/wc-gsheetconnector.1.4.7.zip\" class=\"wp-pic-downloaded\" target=\"_blank\" title=\"Direct download\" rel=\"nofollow noopener\">\n\t\t\t\t\t\t3,000+<em>Installs<\/em>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t<a href=\"https:\/\/wordpress.org\/plugins\/wc-gsheetconnector\/\" class=\"wp-pic-requires\" target=\"_blank\" title=\"WordPress.org Plugin Page\" rel=\"nofollow noopener\">\n\t\t\t\t\t\tWP 5.3+<em>Requires<\/em>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div>\n<\/div><\/div><!-- .wp-pic-wrapper--><link rel='stylesheet' id='dashicons-css' href='https:\/\/westerndeal.com\/elementorkit\/wp-includes\/css\/dashicons.css?ver=7.0' media='all' \/>\n<link rel='stylesheet' id='wppic-style-css' href='https:\/\/westerndeal.com\/elementorkit\/wp-content\/plugins\/wp-plugin-info-card\/dist\/wppic-styles.css?ver=6.3.0' media='all' \/>\n<script id=\"jquery-core-js\" src=\"https:\/\/westerndeal.com\/elementorkit\/wp-includes\/js\/jquery\/jquery.js?ver=3.7.1\"><\/script>\n<script id=\"jquery-migrate-js\" src=\"https:\/\/westerndeal.com\/elementorkit\/wp-includes\/js\/jquery\/jquery-migrate.js?ver=3.4.1\"><\/script>\n<script id=\"wppic-script-js-extra\">\nvar wppicAjax = {\"ajaxurl\":\"https:\/\/westerndeal.com\/elementorkit\/wp-admin\/admin-ajax.php\"};\n\/\/# sourceURL=wppic-script-js-extra\n<\/script>\n<script id=\"wppic-script-js\" src=\"https:\/\/westerndeal.com\/elementorkit\/wp-content\/plugins\/wp-plugin-info-card\/assets\/js\/wppic-script.js?ver=6.3.0\"><\/script>\n\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\" src=\"https:\/\/ps.w.org\/wc-gsheetconnector\/assets\/screenshot-1.gif\" alt=\"| | |\" title=\"| | |\"><\/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:\/\/ps.w.org\/wc-gsheetconnector\/assets\/screenshot-2.gif\" alt=\"WooCommerce Google Sheet Settings\" title=\"| | |\"><\/p>\n<p>Now Whenever you get a new order in real-time, the order details will be sent to google sheet.<\/p>\n<h3>Benefits of WooCommerce Google Sheet Connector PRO version<\/h3>\n<table>\n<thead>\n<tr>\n<th>Feature \/ Capability<\/th>\n<th><strong>Free Version<\/strong><\/th>\n<th><strong>PRO Version<\/strong><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\ud83d\udcb0 Price<\/td>\n<td>Free<\/td>\n<td>Paid (~$49\/year) (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udd17 Google Sheets API<\/td>\n<td>\u2705 Basic integration<\/td>\n<td>\u2705 Advanced + latest API support (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udd10 Authentication<\/td>\n<td>Basic setup<\/td>\n<td>One-click authentication + email display (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udcca Real-time Order Sync<\/td>\n<td>\u2705 Available<\/td>\n<td>\u2705 Enhanced + more control (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udcc1 Create Google Sheets<\/td>\n<td>Limited<\/td>\n<td>Auto + manual sheet creation (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udcd1 Sheet &amp; Tab Naming<\/td>\n<td>Basic<\/td>\n<td>Auto + custom naming options (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udce6 Order Sync<\/td>\n<td>\u2705 Orders only<\/td>\n<td>\u2705 Orders + status-wise sheets (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udd04 Order Status Sync<\/td>\n<td>Limited<\/td>\n<td>Full 7 status sync + custom status tabs (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83e\uddfe Product Data Sync<\/td>\n<td>\u274c Not included<\/td>\n<td>\u2705 Products sync to sheets (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udc64 Customer Data Sync<\/td>\n<td>\u274c Not included<\/td>\n<td>\u2705 Customer data sync (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83c\udf9f\ufe0f Coupons Data<\/td>\n<td>\u274c<\/td>\n<td>\u2705 Coupons sync (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udd01 Two-Way Sync<\/td>\n<td>\u274c<\/td>\n<td>\u2705 Update WooCommerce from Sheets (<a title=\"Google Sheet Connector - WooCommerce Marketplace\" href=\"https:\/\/woocommerce.com\/products\/google-sheet-connector\/?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">WooCommerce<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udcca Rows Management<\/td>\n<td>Basic (order-wise)<\/td>\n<td>Order-wise + product-wise rows (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83c\udfaf Filters (Category, Orders)<\/td>\n<td>\u274c<\/td>\n<td>\u2705 Advanced filters (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udd24 Custom Headers<\/td>\n<td>\u274c<\/td>\n<td>\u2705 Fully customizable headers (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83c\udfa8 Sheet Formatting<\/td>\n<td>\u274c<\/td>\n<td>\u2705 Freeze headers, color rows (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udcc8 Sorting Options<\/td>\n<td>\u274c<\/td>\n<td>\u2705 Asc\/Desc sorting (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\ud83d\udd0c Plugin Compatibility<\/td>\n<td>Basic<\/td>\n<td>Advanced (Woo addons + 3rd party) (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<tr>\n<td>\u2699\ufe0f Automation<\/td>\n<td>Limited<\/td>\n<td>Advanced automation &amp; sync control (<a title=\"WooCommerce Google Sheet Connector - WooCommerce Orders to Google Sheets\" href=\"https:\/\/www.gsheetconnector.com\/woocommerce-google-sheet-connector-pro?utm_source=chatgpt.com\" rel=\"nofollow noopener\" target=\"_blank\">Google Sheet Connector<\/a>)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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>\n","protected":false},"excerpt":{"rendered":"<p>WooCommerce Google Sheet Connector is a reliable plugin that connects your store with Google Sheets. With GSheetConnector, you can automatically sync WooCommerce orders, products, and customer details for easy access and analysis.<\/p>\n","protected":false},"author":3,"featured_media":15670,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,8,17,16],"tags":[150,149,147,148],"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-and-customer-details-for-easy-access-and-analysis","tag-products","tag-woocommerce-google-sheet-connector-is-a-reliable-plugin-that-connects-your-store-with-google-sheets-with-gsheetconnector","tag-you-can-automatically-sync-woocommerce-orders"],"_links":{"self":[{"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/posts\/2578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/comments?post=2578"}],"version-history":[{"count":6,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/posts\/2578\/revisions"}],"predecessor-version":[{"id":15708,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/posts\/2578\/revisions\/15708"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/media\/15670"}],"wp:attachment":[{"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/media?parent=2578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/categories?post=2578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/westerndeal.com\/elementorkit\/wp-json\/wp\/v2\/tags?post=2578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}