Google Sheets is a web-based spreadsheet program offered by Google as part of the free, web-based Google Workspace (formerly G Suite) Office software. It offers functions similar to those of Microsoft Excel and allows users to create, edit and collaborate on spreadsheets online.
To create the connection to Zapier for now, follow this link.
In the next step, create your Google spreadsheet. Example: Table name “Zapier” Spreadsheet with the name “Test product (digital)” and with the following parameters.
The order date
Customer data (customer name and e-mail address)
Payment method used by the customer
Payment schedule to differentiate the orders we are interested in
Payment status
Log in to your Zapier account and select your already created “Webhook” Zap.
Select “Connect Google Sheets” and then “Create Spreadsheet Row” as the action event and click Continue.
This means that each time the product is purchased, a new row will be created in a specific Google Spreadsheet with the appropriate parameters. You may need to log in to your Google account first if you haven't used Google with Zapier yet (Zapier will redirect you to the login page).
Select Google Account (your personal or business account where you have already created a spreadsheet as the very first step) and click Continue.
Next, you need to configure what information you want to display in the Google Spreadsheet. Select Google Drive, Table and Spreadsheet and proceed to configure the parameters display.
Please note that you have already set the column headers, so now you should select which data from the IPN message should correspond to which column:
You will then be redirected to another test step.
Go to your Google spreadsheets to check the result.
Your connection to Google Spreadsheets has been successfully created.
After you enable the Zap, each time the product is purchased, a corresponding record will appear in your spreadsheet.
If you want to integrate CopeCart and Google Spreadsheets via Zapier for another of your products, enable the Zapier interface for each product on a product edit page.
Feel free to contact our support team if you have any further questions.
Best regards
Your CopeCart Team