In the video above, we look at how you can connect your Google account to ThriveCart so that you can automatically send customer information to a Google Sheet.
Once integrated you can easily pass customer information based on a whole range of behaviour rules through to a spreadsheet (such as cart abandonment, purchase, refund, subscription-related triggers, and more).
Watch the video below to see how easy it is to create a rule that passes information to your Google Sheets document.
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).
When you exclude shipping information, the following columns are not populated in the Google Sheets data
When pricing is excluded the following columns aren’t populated in Google Sheets
When personal info is excluded the following columns aren’t populated in Google Sheets
Please note that you can only add to spreadsheets created with ThriveCart, not existing spreadsheets in your account. This is so that they are formatted correctly.
You can reorder columns in the spreadsheet should you want to, but not rename the columns as the system uses this to know where to insert new data.