{"id":39737,"date":"2022-08-08T15:00:26","date_gmt":"2022-08-08T13:00:26","guid":{"rendered":"https:\/\/qodeinteractive.com\/magazine\/?p=39737"},"modified":"2022-08-12T09:21:32","modified_gmt":"2022-08-12T07:21:32","slug":"how-to-connect-woocommerce-and-google-sheets","status":"publish","type":"post","link":"https:\/\/qodeinteractive.com\/magazine\/how-to-connect-woocommerce-and-google-sheets\/","title":{"rendered":"How to Connect WooCommerce and Google Sheets"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]Google Sheets is one of those handy and flexible Google tools<\/a> that every serious WordPress owner should consider having in their arsenal. Due to its highly customizable nature, Google Sheets can be used for managing and tracking all sorts of data<\/strong> \u2013 from employee tasks and schedules all the way to invoices and store orders. So, if you\u2019re using WooCommerce<\/a> to run your online store, it\u2019s highly recommended that you utilize the power of Google Sheets and connect it to WooCommerce.<\/strong>[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]By connecting Google Sheets with your WooCommerce store, you will be able to have a complete overview of your order and customer data in real time<\/strong>. The WooCommerce Google Sheets integration includes sorting and filtering different order and customer data by location, order id, order status, payment method, and plenty more. Plus, your team members won\u2019t even have to log into your WordPress site to keep up to date with the most important happenings in your store. All you have to do is share a link to your Google Sheet of choice and they will have access to all the relevant data in no time.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Earlier, we showed you how to easily embed Google Sheets on your WordPress site<\/a>. This time around, however, we will talk about how to connect your Google Sheets and WooCommerce. We are going to use the help of a WordPress plugin and explain the entire process step-by-step<\/strong>, so make sure to stay tuned.[\/vc_column_text][vc_empty_space height=”80px”][vc_widget_sidebar sidebar_id=”new-ecommerce-banner”][vc_empty_space height=”80px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

Connecting WooCommerce and Google Sheets Using the Help of a Plugin<\/h2>\n

[\/vc_column_text][vc_column_text]If you plan to connect WooCommerce and Google Sheets quickly and efficiently, there is a great plugin that will help you do just that. The plugin called WooCommerce Google Sheet Connector<\/a> will allow you to create a bridge between the two in a way that creates a new row in Google Sheets every time a new order is placed on your WooCommerce store<\/strong>. The sheet will contain all the available order details and it will be moved to the appropriate Google Sheet tabs according to the status of said order (on hold, completed, pending, etc.). Then, each dedicated tab will contain order information for separate customers, including data such as order id, shipping and billing addresses, order total, payment method, and so on.[\/vc_column_text][vc_empty_space height=”50px”]

\n
\n \"WooCommerce <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]There\u2019s also the ability to upgrade to the pro version of the plugin<\/a> (starting from $29) and have access to some advanced features. These include the ability to create an entirely new sheet directly from the plugin settings, manage and synchronize existing orders, products, and users, add background row color in an odd and even manner, and plenty more.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]With that said, let\u2019s see how you can use this plugin to easily connect Google Sheets and WooCommerce and have complete management of your order and customer data.
\n[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]After installing the plugin<\/a> and activating it, you should click on WooCommerce >> Google Sheets<\/em><\/strong>. Then, choose the Integration tab. Once there, you will see the field to insert the code from Google Drive that will allow you to get access to your spreadsheets. You should hit the Get Code<\/em> button<\/strong> to retrieve it.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Get <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]This will cause the new window to open with a message letting you know that \u201cGSheetConnector wants to access your Google account\u201d. Make sure to check the two available fields (as seen in the picture below). Then, hit the Continue<\/em> button<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"GSheetConnector\" <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]You should copy the authorization code<\/strong> that will show up on the next screen.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Authorization <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]After copying the code, you need to go back to your WooCommerce Google Sheets page (on your WordPress site) and paste the authorization code into the \u201cGoogle Access Code\u201d field<\/strong>. Finally, click on Save & Authenticate<\/em>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Google <\/div>\n<\/div>[vc_empty_space height=”60px”]
\n
\n \"Authorised <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]You will now see that there\u2019s a message in the Google Access Code<\/em> field that reads \u201cCurrently Active\u201d. This means that your site is now authenticated with Google and you can proceed to connect with Google Sheets.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Connected <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Navigate to the WooCommerce Data Settings<\/em> tab<\/strong> (in WooCommerce >> Google Sheets<\/em>) and select the desired Google Sheet Name<\/em><\/strong>. You will be able to choose your file from the dropdown.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"WooCommerce <\/div>\n<\/div>[vc_empty_space height=”60px”]
\n
\n \"Google <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Then, you can proceed to select (or unselect) the specific sheet tabs (pending orders, processing orders, etc.) you want to appear in your Google Sheet. You can also do the same for many different headers, such as Order ID, Status, Order Total, Payment Method, Billing First (and Last) Name, and the list goes on. There\u2019s a toggle switch right next to every sheet tab and header that you can turn on or off according to your preferences.
\n[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Submit <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Once you\u2019re done, hit the Submit Data<\/em> button<\/strong>.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Last but not least, make sure to check if everything is working by going into WooCommerce test mode<\/a> and \u201cordering\u201d your product of choice. Then, you need to select a specific order status i.e. Processing, On Hold, Completed, and so on). After that, go to your Google Sheet in question and see if the info about the selected order status has appeared in the sheet.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Completed <\/div>\n<\/div>[vc_empty_space height=”78px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

Wrapping Things Up<\/h2>\n

[\/vc_column_text][vc_column_text]And that completes our step-by-step tutorial on connecting your WooCommerce-powered store with Google Sheets. If you make sure to use this popular and convenient Google software when running and managing your store, you and the rest of your team will always be able to access all important files and information related to your customers and orders in no time.
\n[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]We highly recommend using the WooCommerce Google Sheet Connector plugin for this task. Not only can this plugin be used entirely for free, it\u2019s also quite easy to handle, allowing you to manage specific sheets related to your WooCommerce orders with ease and also enable or disable specific data directly from your WordPress dashboard. Just make sure to follow the instructions above when attempting to connect WooCommerce with your Google Sheets, and you\u2019ll be all set within minutes.
\n[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

We will show you how to connect WooCommerce and Google Sheets and ensure that your team members have access to all the relevant customer and order data.<\/p>\n","protected":false},"author":2,"featured_media":39772,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[81,231,4,99],"class_list":["post-39737","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-google","tag-productivity","tag-tips","tag-woocommerce"],"_links":{"self":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/39737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/comments?post=39737"}],"version-history":[{"count":0,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/39737\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media\/39772"}],"wp:attachment":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media?parent=39737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/categories?post=39737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/tags?post=39737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}