Connect Copecart and Google Sheets

Copecart sends a payment notification (IPN) for each sale on your checkout pages. FlowMattic turns those notifications into Google Sheets rows, so course creators and digital product sellers can track sales per product, keep a buyer list and hand the bookkeeper a clean ledger, without downloading reports from the Copecart dashboard every month.

Try FlowMattic free See example workflows

7 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Copecart1 trigger

Do this in Google Sheets19 actions

1. TriggerInstant Payment Notification

2. ActionAdd New Row

When Copecart fires Instant Payment Notification, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Copecart and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Log each Copecart payment in a sales sheet

Every payment notification adds a row with the order ID, buyer, product, amount and date, so you see sales as they come in and keep a ledger for tax time.

Instant Payment NotificationAdd New Row

View the template

Keep refunds and chargebacks off the sales tab

Notifications carry a type or status. A Router writes sales to one tab and refunds or chargebacks to another, so the sales total is not inflated by money that went back.

Instant Payment NotificationRouterAdd New Row

Turn product IDs into names you recognise

A Lookup Table maps each Copecart product ID to the course or ebook name, so the sheet reads Masterclass rather than a number and pivots by product make sense.

Instant Payment NotificationLookup TableAdd New Row

Build a buyer list with one row per customer

Search the buyer's email first. Repeat buyers get their latest product and total updated, new buyers get a row, which shows who your best customers are.

Instant Payment NotificationLookup Row DataRouterUpdate RowAdd New Row

Log affiliate sales for commission checks

A Filter passes payments that came through an affiliate and writes them to a partner tab, so you can check commissions against Copecart's figures at payout time.

Instant Payment NotificationFilterAdd New Row

Format amounts and dates for your bookkeeper

Number Formatter and Date/Time Formatter write amounts with the decimal separator and date style your accountant uses, so the sheet imports into their tool without edits.

Instant Payment NotificationNumber FormatterDate/Time FormatterAdd New Row

Set up: Copecart payments in a sheet

At the end, each payment notification from Copecart adds a row to your sales sheet.

Create the sales sheet
Add a header row with Date, Order ID, Buyer, Email, Product, Amount and Type.
Start with the payment trigger
Create a workflow with Copecart and the payment notification trigger, and copy the webhook URL it shows.
Add the URL in Copecart
Paste that URL as the IPN address in your Copecart product or account settings, then make a test purchase so FlowMattic captures one notification.
Write the row
Connect Google Sheets, add Add New Row, map the order and buyer fields to the columns, test and switch on.

Import the ready-made template Beginner, about 5 min to set up

From Copecart	To Google Sheets
Order ID	Order ID
Buyer name	Buyer
Buyer email	Email
Product name	Product
Amount	Amount
Event type	Type
Date	Date

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Copecart can send notifications for more than first sales. Check the type or status field in your test data before mapping, and route refunds and chargebacks away from the sales tab.
Field names depend on the notification Copecart sends, so the mapping above is an example.
The workflow runs from Copecart to Sheets. Deleting a row does not refund or cancel anything in Copecart.

Copecart

Integration page

Triggers (1)

Instant Payment NotificationTriggers when a payment is received in Copecart.

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Copecart and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

A ledger that fills itself

Sales, refunds and affiliate orders sit on tabs of one spreadsheet you can hand to your accountant at month end.

Buyer data stays on your server

Names, emails and amounts go from Copecart through your own WordPress site to Google, not through an outside automation account.

Launch days cost the same

Runs are unlimited, so a product launch with hundreds of orders in a day is logged at no extra charge.

Common questions

How do Copecart payments reach Google Sheets?

Copecart posts a payment notification to the webhook URL from FlowMattic's Copecart trigger. Each notification starts the workflow, and Add New Row writes the fields you mapped.

Will refunds show up as sales?

Only if you send everything to one tab. Use a Router on the notification's type or status so refunds and chargebacks go to their own tab.

Can I see sales per product?

Yes. Map the product to its own column, or use a Lookup Table to turn product IDs into names, then build a pivot table by product in Google Sheets.

Can I keep one row per buyer?

Yes. Look up the buyer's email with Lookup Row Data and use a Router: Update Row for existing buyers, Add New Row for new ones.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Copecart and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 27 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Copecart integration 1.0.0, Google Sheets integration 2.2.4.