1. Home
  2. Integrations
  3. Notification Platforms
  4. Google Sheets integration & how to

Google Sheets integration & how to

You can integrate with your Google Sheets account under your Settings > Integrations > Google sheets area.

There is a video there that walks you through the steps you need to take.

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

  • 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
  • email
  • 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

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.

Updated on October 28, 2020

Was this article helpful?

Related Articles

Can't find the answer?
Can't find the answer to your question after searching the helpdesk and our extensive content? Click below to submit a ticket and get in touch with us.
Submit A Ticket