Google Sheets integration

Send payment data and submissions to Google Sheets spreadsheet every time you make a sale.

Learn how to integrate with Google Sheets to instantly track payment data and submissions, forecast sales, use it as a CRM and streamline your workflow. You can also use this integration for lead tracking, sales forecasting, task management, and CRM.

How it works

A new sheet will be created with the same name as your checkout. Each time a new payment, subscription, or submission is made, it will instantly appear in your Google sheet without any delays or hassle.

You have to activate the integration for every checkout individually.

Once set up, you can:

  • Change the name of the sheet
  • Move the sheet to a different folder in your drive
  • Rearrange columns in the sheet, and the integration will adjust accordingly
  • If you add new variants or fields to your checkout, new columns will automatically be added
  • You can delete rows (payments)

How to connect Checkout Page with Google Sheets

Here’s how you can set up the integration:

  1. From your Checkout Page dashboard, click on Store Settings from the left-side menu
  2. Open the Integrations tab
image-949d02.png

3. Click Add integration for Google Sheets

4. Click Create sheet to integrate the page to your Google Sheet

image-74e521.png

5. Your page is now connection to a Google Sheet, where you can

  • Open the sheet to see the information populated whenever a purchase has been made
  • Open the Events log to see an overview of all the purchases
  • Edit the integration
  • Delete the integration

Example spreadsheet

image-bd99dc.png

This is how it looks once you have set up the integration.

We recommend that you make a couple of test payments to ensure that everything works as expected.

You can then delete those test payments rows and move columns around in the order of your preference.