How to Connect WooCommerce to Google Sheets? (5 Powerful Uses Cases)

Editorial Team
August 4, 2022
How to Connect WooCommerce to Google Sheets? (5 Powerful Uses Cases)

Are you looking for a way to connect Google Sheets with WooCommerce?

Maybe you need information related to customers, products, or new orders in one place.

But manually keeping track of every order or every customer detail on Google Sheets can be inconvenient. This is where Autonami fills the gap and automates the entire data collection process for you.

Autonami lets you sync your store data with Google Sheets, WITHOUT CODING!

In this article, you will learn how to integrate your WooCommerce store with Google Sheets and 5 powerful use cases that you may not know you needed till now.

How to Connect Google Sheets with WooCommerce Store?

With this WooCommerce and Google Sheets integration, you can implement various automations.

You can export your store orders to Google Sheets, update order-related information, pull crucial lead details from forms, see customer reviews at a glance, and SO MUCH MORE!

Today, we will use Autonami to propel this integration and see how you can do more with your store data.

Achieve more from your eCommerce marketing campaigns with Autonami - the most powerful WordPress marketing automation tool.

Imagine being able to automate all your workflows such as winback campaigns, abandoned cart recovery, post-purchase sequences, and many more.

Not just that, create beautiful broadcast email and SMS campaigns that you can schedule or send right away.

Right out of WordPress.

No limit on contacts - store as many contacts as you want!

That's Autonami for you.

Download and Install Autonami

Autonami comes in two versions - a free version and a pro version.

Although the free version allows you to get a headstart in eCommerce marketing automation efforts, the pro version allows you to build advanced workflows and integrate with other WordPress tools as well.

Today, we are going to use the pro version of Autonami to illustrate how to connect WooCommerce and Google Sheets.

Once you purchase your pro version, you will find these files in your WooFunnels account dashboard. Download the zip files of the plugins.

downloading autonami plugins

The next step is to upload the plugins. Click on plugins and select Add New.

Upload the zip files you downloaded and click on Install.

uploading the plugins woocommerce-google sheets integration

Once it gets installed, activate the plugin from here.

Installing and activating the plugins

Well done! You have installed the Autonami core plugin.

Note: Upload, Install, and Activate each plugin one by one in the same way.

To activate the license, go to your WooFunnels account and copy the activation code as shown below.

activating the license

Go to Autonami settings and paste both (Autonami Pro and Connectors plugins) the activation codes here:

entering the license activation code

Then, click on Activate.

Once both the plugins are activated, click on the Save Settings button.

save setting - activating autonami pro license

That's it! You've successfully activated the license of Autonami.

Activate Google Sheets Connector

Head to the Autonami dashboard and click on Connectors.

connecting autonami account with Google sheets

Under the Connectors section, scroll down to Google Spreadsheets.

connecting autonami with google sheets - 2

A pop-up window will appear; press the ‘Click to Get Token’ button.

click to get the authorization token

Choose a Google account to connect with Autonami.

selecting google account

Grant permissions to allow Autonami to exchange data with Google Sheets.

granting accesss to autonami

Now, you need to copy the Token activation code and paste it into our pop-up.

copying the token authorization code

Paste the Authorization code into the Token box. Click on Connect.

pasting the authorization token

5 Use Cases You Can Achieve by Connecting WooCommerce and Google Sheets

Today, we will show you 5 advanced use cases to use this WooCommerce-Google Sheets integration.

These use-cases will help you collect and organize your store-related information in a much more useful manner and convert it into visual reports to share with your team members.

1. See order-related data at a glance

This automation will help you analyze all the order-related information in one place.

In the Autonami dashboard, head to Campaigns and select Automations (Next Gen).

And select Add New Automation.

adding a new automation

Click on Create from Scratch and assign a suitable name to your automation.

naming the new automation

Here, you will see our Canvas interface. Click on Select Trigger and choose Order Created under WooCommerce.

selecting trigger - order related woocommerce-google sheets integration

Now, you need to configure the Order settings. This way, you can collect information about only those orders (completed/draft/on-hold/processing) which you want to see.

configuring trigger - order related woocommerce-google sheets integration

Now, you need to add an Action. This action will be executed whenever somebody places an order.

Click on the “+” icon and select Action.

adding action - order related woocommerce-google sheets integration

Navigate to Send Data section and select Insert Row under Google Sheets.

sending data - order related woocommerce-google sheets integration

Create a Spreadsheet in a separate tab, and copy the ID of the sheet as shown below.

Important note: The URL of the spreadsheet is NOT the ID of the sheet; the ID is the part of the URL, as shown below.

copying the sheet ID - order related woocommerce-google sheets integration

Paste the ID of the spreadsheet into the “Enter Google Spreadsheet ID” space. Click on Get Sheet to sync the spreadsheet.

If you have multiple worksheets, select the one where you want to see the data.

syncing the sheet - order related woocommerce-google sheets integration

Under the Data section, click on Add New. Use merge tags to see the information you need. We need the customer’s name, email address, and cart total.

adding merge tags - order related woocommerce-google sheets integration

Copy the respective merge tags as shown in the above picture, and paste them into the data columns.

merge tags - order related woocommerce-google sheets integration

Click on Save, and your automation is ready.

order related woocommerce-google sheets integration

Place a test order to check the task execution.

test order - order related woocommerce-google sheets integration

Now go to Contacts in Automation.

Here you’d be able to see a new active contact for the order you just placed.

new order - order related woocommerce-google sheets integration

Check the connected spreadsheet. You can see the order-related data in the sheet.

information in spreadsheet - order related woocommerce-google sheets integration

2. Collect and analyze customer reviews

A big advantage of WooCommerce-Google Sheets integration is that you don’t have to log into your website to see product-related information.

Say, for example, you want to see all of your product reviews under one roof, then pulling them from your store and displaying them in a systematic manner in a spreadsheet is a much better way to analyze how your customers are reacting to your products.

So, add a new automation and select your trigger as “Review Received” under WooCommerce.

adding a event - review related woocommerce-google sheets integration

Add an Action that will be executed whenever you receive a product review.

adding an action - review related woocommerce-google sheets integration

Under Send Data section, click on Insert Row.

sending a data - review related woocommerce-google sheets integration

Now, do the sheet configurations as mentioned in previous automations as well.

adding a sheet - review related woocommerce-google sheets integration

Click on Add New, and now go to Merge tags {{..}} on the top right corner to collect relevant data.

Go to the Review section, copy both the merge tags one by one and paste it under the Data fields.

adding merge tags - review related woocommerce-google sheets integration

Paste the merge tags as shown below and Save them.

saving the merge tags - review related woocommerce-google sheets integration

Now, whenever a customer reviews your product, like the one below.

adding a test review - review related woocommerce-google sheets integration

Then you will see the review and the rating reflected in the added spreadsheet.

information in google sheets - review related woocommerce-google sheets integration

3. Manage SMS responses

If you do SMS marketing for your WooCommerce stores, then storing all the responses in a spreadsheet can help you see all the SMSs at a glance and quickly analyze how your customers are responding to your SMSs.

Add a new automation and assign a suitable name.

Once you are on the automation builder Canvas interface. Select a Trigger.

Under Messaging, click on SMS Received.

adding a trigger - SMS-related woocommerce-google sheets integration

Add an Action that follows the trigger.

Click on Action, and go to Send Data >> Google Sheets >> Insert Row

adding an action - SMS-related woocommerce-google sheets integration
inserting a row - SMS-related woocommerce-google sheets integration

Now, you need to configure the Google Sheets settings, i.e., add the spreadsheet ID and select the worksheet.

adding a sheet - SMS-related woocommerce-google sheets integration

Go to Merge Tags to fetch the relevant data for your spreadsheets. Select the columns where you want to display the data and paste the corresponding merge tags.

adding a merge tag - SMS-related woocommerce-google sheets integration

Copy the relevant merge tags as shown below. You can choose any of the available merge tags as per your needs.

copying the relevant merge tags - SMS-related woocommerce-google sheets integration

Paste the merge tags under the Data section.

pasting the relevant merge tags - SMS-related woocommerce-google sheets integration

Click on Save to complete the automation setup. But, there is one more step that you need to do to make this automation work.

Click on the SMS Received trigger and copy the Custom Webhook URL.

copying the webhook url - SMS-related woocommerce-google sheets integration

You need to have a Twilio premium account to link this automation with your Twilio account and run your SMS campaigns smoothly.

Head to your Twilio console and click on Monitor.

integrating with twilio account

Now, follow this path: Logs >> Errors >> Webhooks and Alerts

Click on the (+) icon under Customize Email Alerts.

integrating twilio account 2

Create a new alert trigger by entering all the information with your copied webhook URL. 

trigger a webhook

Once done, click on Save.

The alert trigger will get created here:

trigger set

To read more about how you can do more with this automation, head to this document.

4. Manage canceled subscribers

If you run a subscription-based WooCommerce store, you know that the subscription churn is real.

We have listed various automations that you can create to prevent churning. The information about how many users canceled recently can help you understand the severity of your store’s churn rate.

So, let’s build a simple automation for this.

Create new automation and assign a suitable name.

Select a trigger: Subscription Status Changed under WooCommerce.

adding an action - subscriptions-related woocommerce-google sheets integration

Now, you need to configure the trigger. So, click on the trigger and change the subscriptions statuses settings as shown below.

setting statuses - subscriptions-related woocommerce-google sheets integration

Add an Action. This step will be the same as the above automations.

adding an action - subscriptions-related woocommerce-google sheets integration

Under Send Data, go to Google Sheets and select Insert Row.

inserting a row - subscriptions-related woocommerce-google sheets integration

On the right-hand side, you will see merge tags. Copy the relevant merge tags from the Contact section and WooCommerce Subscriptions section.

adding a merge tag - subscriptions-related woocommerce-google sheets integration

You can configure the Subscription Start Date to the format you want it. Seeing the date of the subscribers will inform you which subscribers are unsubscribing more: new ones or the old ones.

As per the data, you can tweak your current marketing strategies, or you can create a new one.

Configure the data in the format that you want and copy the created merge tag.

Configure the date in the format that you want and copy the created merge tag.

Paste the relevant merge tags in the data fields and click on Save.

saving the merge tags

The automation is complete and ready to be executed.

5. Collect lead-related information

Autonami integrates with various popular form builders like Elementor Forms, Gravity Forms, WP Forms, and more.

Syncing these forms with Google Sheets can help you collect information in real-time and see your new contacts everything at a glance.

If you do not know how to create a form, then read this article.

Now, you need to integrate the form with your automation.

To do that, first click on Select Trigger and select Form Submits under Forms.

adding a trigger - form related woocommerce-google sheets integration

Select the form you want to pull information from.

adding a form - form related woocommerce-google sheets integration

Now map the form fields with Autonami fields. This simply means matching the form fields with the corresponding automation fields.

Note: these fields will be different according to the form you’ve built to collect data.

  • Email > Email
  • First name > Name

After mapping the fields, click on Save.

mapping the form fields - form related woocommerce-google sheets integration

Now, just like we did in the above automation, you need to add an Action.

adding an action - form related woocommerce-google sheets integration

Now, go to Send Data >> Google Sheets >> Insert Row

sending data - form related woocommerce-google sheets integration

Configure the spreadsheet settings - add spreadsheet ID and select the worksheet.

Now, click on Add New, and select Merge Tags on the top right corner.

adding merge tags - form related woocommerce-google sheets integration

In the merge tag section, you will see multiple form-related merge tags. Select the ones you want.

Click the gear icon next to Form Field.

configuring merge tags - form related woocommerce-google sheets integration

Now select a field, we will select the Name field first.

configuring form fields - form related woocommerce-google sheets integration

A merge tag will be generated. Copy this merge tag.

copying the configured merge tag - form related woocommerce-google sheets integration

Paste the merge tag under the Data field.

pasting the merge tags - form related woocommerce-google sheets integration

Similarly, select Email and then Comment or Message merge tags.

Once you’ve added your merge tags, save it.

saving the merge tags - form related woocommerce-google sheets integration

Turn the toggle (right top corner) on to activate the automation.

form related woocommerce-google sheets integration

Now, whenever somebody fills the form.

testing the form related woocommerce-google sheets integration

You can see their contact information in the Google Sheet directly.

information in sheet - form related woocommerce-google sheets integration

So, Are You Ready to Connect Your Google Sheets with WooCommerce Store?

The Google Sheets and WooCommerce integration gives you the ability to sync your WooCommerce store data with Google Sheets.

These 5 automated recipes can help you collect data and manage your store more effeciently.

Get on the bandwagon and make your online store management a smooth sail with the most powerful WordPress marketing automation engine - Autonami.

See new WooCommerce orders or pull all the data from an embedded form and perform analysis to make better decisions.

With Autonami, you can do it all.

Author: Editorial Team
The Editorial Team at WooFunnels is a passionate group of writers and copy editors. We create well-researched posts on topics such as WordPress automation, sales funnels, online course creation, and more. We aim to deliver content that is interesting and actionable.
Ready to create revenue-generating funnels in Wordpress?
Click Here

Increase your sales, starting today.

Get WooFunnels Now
chevron-down
[class^="wpforms-"]
[class^="wpforms-"]