Effortlessly keep your records organized and up to date by connecting Google Sheets to ThriveCart. With this streamlined workflow, every new purchase can be sent directly into your order tracking spreadsheet, giving you real-time visibility into customer activity.
This powerful setup unlocks ecommerce reporting automation, helping you centralize insights, simplify sales data management, and maintain clean, accurate data—all without manual entry.
How to connect to Google Sheets
The below video is taken directly from our integration page within the platform. Some of the steps mentioned will be specific to where this video originally shows within your dashboard.
You can integrate with your Google Sheets account under your Settings > Integrations > Google Sheets area.
In the video above, we look at how you can connect your Google account to ThriveCart and then create an automation rule so that you can automatically send customer information to a Google Sheet.
Google Sheets Integration Steps:
- Head to Settings > Integrations > Google Sheets
- Click “Authorize with Google Sheets” to login to your Google account and grant permissions
- You will be redirected back to ThriveCart and Google Sheets is connected
Once integrated you can easily pass customer information based on a whole range of automation rules through to a spreadsheet (such as cart abandonment, purchase, refund, subscription-related triggers, and more).
Create an automation rule for customer data sync
To start pushing data to Google Sheets, head to your product’s automation settings (or course options, upsell/downsell automations, coupon automations, etc.).
- Create a new automation rule
- Choose Google Sheets from the integrations dropdown
- Select the option to add customers to a spreadsheet
- Choose from a list of ThriveCart-created spreadsheets (if you have already created sheets through this integration), or create a new one
- Choose whether to exclude any data from the sheet if necessary
- Save the rule
- Save the overall product
- Finally, run through a test order to confirm the data is passed through to your sheet as expected
See more in our guide on how to add customers to your autoresponder for a walkthrough on creating your product’s automation rules.
Information that is passed to Sheets
By default, we’ll send all of the information below to the Sheets document. However, by checking the relevant boxes you can prevent certain groups of data from being sent. This is helpful if you want to provide information to 3rd parties, but maybe not everything (such as the pricing the customer paid).
Checking the boxes in the rules EXCLUDES the data.
When you exclude shipping information, the following columns are not populated in the Google Sheets data
- shipping_amount
- shipping_provider
- shipping_label
- shipping_address_street
- shipping_address_city
- shipping_address_zip
- shipping_address_country
- shipping_address_state
When pricing is excluded the following columns aren’t populated in Google Sheets
- item_type
- item_amount
- item_quantity
- order_currency
- order_processor
- order_id
- invoice_id
When personal info is excluded the following columns aren’t populated in Google Sheets
- first_name
- last_name
- ip_address
- address_street
- address_city
- address_zip
- address_country
- shipping_address_street
- shipping_address_city
- shipping_address_zip
- shipping_address_country
- address_state
- shipping_address_state
Even if all three checkboxes are enabled, the data that we always pass to Google sheets includes:
- event
- item_name
- item_plan_name
- date
- checkbox_confirmation (email opt-in, if enabled)
Important notes:
- You can only add to spreadsheets created with ThriveCart, not existing spreadsheets in your account. This is so that they are formatted correctly.
Wanting to add specific customer/order data to an existing Google Sheet not created by ThriveCart? Consider using our mutual Zapier apps to pass data to Zapier and then onto Google Sheets.
- You can reorder columns in the spreadsheet should you want to, but do not rename the columns as the system uses this to know where to insert new data.
- Changing your Google login credentials or removing linked accounts from within your Google account can break the connection to ThriveCart. If this happens, you will need to authorize the connection again by de-authorizing Google Sheets and then Authorizing the connection again within your Integration settings. Existing automation rules will be retained when de-authorizing and re-authorizing the account.
Frequently Asked Questions (FAQs)
- Q: An order didn’t pass information through to Google Sheets, why not?
- A: If you have updated your Google password, this can break the sync to Google Sheets. You can always de-authorize Google Sheets and then re-authorize the connection again to ensure that customer data sync continues.
Additionally, make sure that your automation rule does not have the “exclude locations” checkbox enabled. If it does, compare the customers address to the location(s) excluded from the rule
- A: If you have updated your Google password, this can break the sync to Google Sheets. You can always de-authorize Google Sheets and then re-authorize the connection again to ensure that customer data sync continues.
- Q: Order data is passing through, but why doesn’t it include their upsell purchase details?
- A: To track upsell/downsell purchase details, you’ll want to create an automation rule on that specific upsell product as well as the main product. You can choose to add it to the same sheet as the main product, or create a new sheet specific to those funnel purchases.
- Q: Why am I seeing an error code 403 “Request has insufficient authentication scopes” when trying to choose a sheet?
- A: This would be related to a change in your Google password, or a change in your Google linked accounts, and you’ll need to go disconnect Google Sheets from ThriveCart and then Authorize again.