In this tutorial you will learn how to create and configure a connection between CopeCart and Google Sheets via Zapier.
In Google Sheets, create a spreadsheet where you’d like all required information to be transferred to and name it accordingly. Then, add headers to columns—these would be the parameters you're looking for.
For example, let’s create a spreadsheet named “Test Product (digital)” and assume that we need to track next parameters:
- The order date
- Some customers data
- Payment method the customer has used
- Payment plan to differentiate the orders we are interested in
- Payment status
What you do next is tell Zapier, which exact thing it should react to and in what exact way.
To make Zapier know it should "listen" to your product sale process, you need to create a Webhook. In other words, you need to establish a mechanism of notifying the system that something had happened.
To do that, go to your Zapier account and follow next steps:
- Go to Zaps menu
- Click on Make a New Zap button
- Scroll down to Built-In Apps and select Webhooks by Zapier
- Choose Catch Hook as trigger event and press Continue
What you just did is created a Webhook Endpoint. It is a unique address where the specific messages will be sent to when some action happens.
Next, you need to configure an IPN connection between Zapier and CopeCart so that every time when the product is purchased, CopeCart would send a notification to Webhook Endpoint.
To do that, open your CopeCart home page in a new tab, click on your username in the upper-right corner, and proceed to IPN connections:
Create and name a new Generic IPN integration:
Now you need to tell CopeCart to send notifications to the Webhook Endpoint that you have created at Zapier. To do that, simply copy the Webhook URL from Zapier to Notification URL field at CopeCart, enter a key, and press Save changes:
Go to Product edit page and enable an IPN integration with Zapier:
Then, go to product Checkout page and proceed to Test order—fill in the fields with whatever user information you want, select a payment plan and Test payment option, and click on Order now:
You have just completed a test order. Now, switch to Zapier and proceed to next step by clicking on Continue button. You will be redirected to test step. We strongly recommend you to proceed to testing by pressing Test & Continue. If integration between CopeCart and Zapier works, you will be redirected to the next step:
Next, you should configure interface between Zapier and Google Sheets:
- Select Google Sheets App
- Choose Create Spreadsheet Row as an action event and press Continue. This means that every time when the product is purchased, a new row will be created in a specific Google sheet with corresponding parameters.
- Select Google account (your personal or your business account) where you already have created a spreadsheet as a very first step, and press Continue.
Next, you will need to configure what information you'd like to be displayed at Google sheets. Select the Google Drive, Spreadsheet and Worksheet, and proceed to configuring the parameters dispaly.
Remember, you have already set the column headers, so now you should select what data from IPN message corresponds to what column:
When you click on Continue button, you will be redirected to another test step. Proceed to testing to see if everything works right.
Go to your Google Sheets to check the result:
If configurations are correct, there will be no errors, and you can turn your Zap on!
After you have enabled the Zap, every time when the product is purchased, a corresponding record appears in your spreadsheet:
If you'd like to integrate CopeCart and Google Sheets via Zapier for another your products, enable Zapier interface for every product at a Product Edit page.