With your Google Spreadsheets you can quickly and easily filter information, create data and never lose track of it.
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