How to Connect WooCommerce to Google Sheets? (5 Powerful Uses Cases)
Editorial Team
August 4, 2022
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 FunnelKit Automations fills the gap and automates the entire data collection process for you.
FunnelKit Automations 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.
Contents
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 FunnelKit Automations to propel this integration and see how you can do more with your store data.
FunnelKit Automations 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 FunnelKit Automations to illustrate how to connect WooCommerce and Google Sheets.
Once you purchase your pro version, you will find these files in your FunnelKit account dashboard. Download the zip files of the 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 the 'Install Now' button.
Once it gets installed, activate the plugin from here.
Well done! You have installed the FunnelKit Automations core plugin.
Note: Upload, Install, and Activate each plugin one by one in the same way.
To activate the license, go to your FunnelKit (formerly WooFunnels) account and copy the activation code as shown below.
Go to FunnelKit Automations settings and paste both (FunnelKit Automations Pro and Connectors plugins) the activation codes here:
Then, click on Activate.
Once both the plugins are activated, click on the Save Settings button.
That's it! You've successfully activated the license of FunnelKit Automations.
Head to the FunnelKit Automations dashboard and click on Connectors.
Under the Connectors section, scroll down to Google Spreadsheets.
A pop-up window will appear; press the ‘Click to Get Token’ button.
Choose a Google account to connect with FunnelKit Automations.
Grant permissions to allow FunnelKit Automations to exchange data with Google Sheets.
Now, you need to copy the Token activation code and paste it into our pop-up.
Paste the Authorization code into the Token box. Click on Connect.
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.
This automation will help you analyze all the order-related information in one place.
In the FunnelKit Automations dashboard, head to Campaigns and select Automations (Next Gen).
And select Add New Automation.
Click on Create from Scratch and assign a suitable name to your automation.
Here, you will see our Canvas interface. Click on Select Trigger and choose Order Created under WooCommerce.
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.
Now, you need to add an Action. This action will be executed whenever somebody places an order.
Click on the “+” icon and select Action.
Navigate to Send Data section and select Insert Row under Google Sheets.
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.
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.
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.
Copy the respective merge tags as shown in the above picture, and paste them into the data columns.
Click on Save, and your automation is ready.
Place a test order to check the task execution.
Now go to Contacts in Automation.
Here you’d be able to see a new active contact for the order you just placed.
Check the connected spreadsheet. You can see the order-related data in the sheet.
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.
Add an Action that will be executed whenever you receive a product review.
Under Send Data section, click on Insert Row.
Now, do the sheet configurations as mentioned in previous automations as well.
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.
Paste the merge tags as shown below and Save them.
Now, whenever a customer reviews your product, like the one below.
Then you will see the review and the rating reflected in the added spreadsheet.
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.
Add an Action that follows the trigger.
Click on Action, and go to Send Data >> Google Sheets >> Insert Row
Now, you need to configure the Google Sheets settings, i.e., add the spreadsheet ID and select the worksheet.
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.
Copy the relevant merge tags as shown below. You can choose any of the available merge tags as per your needs.
Paste the merge tags under the Data section.
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.
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.
Now, follow this path: Logs >> Errors >> Webhooks and Alerts
Click on the (+) icon under Customize Email Alerts.
Create a new alert trigger by entering all the information with your copied webhook URL.
Once done, click on Save.
The alert trigger will get created here:
👉 Learn more about how you can do more by automating your SMS responses.
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.
Now, you need to configure the trigger. So, click on the trigger and change the subscriptions statuses settings as shown below.
Add an Action. This step will be the same as the above automations.
Under Send Data, go to Google Sheets and select Insert Row.
On the right-hand side, you will see merge tags. Copy the relevant merge tags from the Contact section and WooCommerce Subscriptions section.
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.
Paste the relevant merge tags in the data fields and click on Save.
The automation is complete and ready to be executed.
FunnelKit Automations 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.
👉 Learn how to create a form here.
Now, you need to integrate the form with your automation.
To do that, first click on Select Trigger and select Form Submits under Forms.
Select the form you want to pull information from.
Now map the form fields with FunnelKit Automations 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.
After mapping the fields, click on Save.
Now, just like we did in the above automation, you need to add an Action.
Now, go to Send Data >> Google Sheets >> Insert Row
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.
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.
Now select a field, we will select the Name field first.
A merge tag will be generated. Copy this merge tag.
Paste the merge tag under the Data field.
Similarly, select Email and then Comment or Message merge tags.
Once you’ve added your merge tags, save it.
Turn the toggle (right top corner) on to activate the automation.
Now, whenever somebody fills the form.
You can see their contact information in the Google Sheet directly.
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 efficiently.
Get on the bandwagon and make your online store management a smooth sail with the most powerful WordPress marketing automation engine - FunnelKit Automations.
See new WooCommerce orders or pull all the data from an embedded form and perform analysis to make better decisions.
With FunnelKit Automations, you can do it all.