Connect Payhip and Google Sheets

Payhip handles checkout for your ebooks, courses and memberships. FlowMattic adds each successful transaction to a Google Sheet on its way through your WordPress site, so you have a sales ledger for your accountant, a running picture of which products sell, and a list of buyers you own.

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 Payhip1 trigger

Do this in Google Sheets19 actions

1. TriggerSuccessful Transaction

2. ActionAdd New Row

When Payhip fires Successful Transaction, 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

Payhip 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 every successful Payhip transaction as a row

Each sale becomes a row with buyer, product, price and date, giving creators a ledger they can total for tax time without downloading reports.

Successful TransactionAdd New Row

View the template

Give each product its own sales tab

A Router reads the product name and writes the sale to that product's tab, so you can see at a glance how a new course compares with an older ebook.

Successful TransactionRouterAdd New Row

Keep a customer ledger with repeat purchases

Find the buyer's email first. Returning customers get their row updated with the latest purchase and date, new buyers get a new row, so your best fans are easy to spot.

Successful TransactionLookup Row DataRouterUpdate Row

Label each sale with an income category for the accountant

Lookup Table turns product names into categories such as Courses, Ebooks or Memberships before the row is written, so the sheet groups income the way your books do.

Successful TransactionLookup TableAdd New Row

Email buyers a bonus link kept in your sheet

Keep one bonus resource per product in a tab. The workflow looks up the product's link and sends it to the buyer with Email (SMTP), and you change links in the sheet.

Successful TransactionLookup Row DataEmail (SMTP)

Show prices with the right decimals and currency

Number Formatter tidies the amount before it is written, so totals and pivot tables in the sheet add up without manual cleanup.

Successful TransactionNumber FormatterAdd New Row

Set up: a row for every sale

When you are done, every successful Payhip transaction adds a row to your sales sheet.

Start the ledger
Create a sheet with headers such as Date, Buyer email, Product, Amount and Transaction ID.
Connect Google Sheets
In Connects, add a Google account that can edit the ledger.
Use Successful Transaction
Create a workflow with the Payhip Successful Transaction trigger and finish the setup shown in the trigger step.
Make a test purchase
Buy a low-priced or free product so FlowMattic captures a real transaction.
Map and turn on
Add Google Sheets Add New Row, map the sale fields, test the step and switch the workflow on.

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

From Payhip	To Google Sheets
Transaction date	Date
Buyer email	Buyer email
Product name	Product
Price	Amount
Transaction ID	Transaction ID

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

These workflows run on Successful Transaction, so refunds and failed payments do not reach the sheet. Note refunds by hand or from your payment provider's records.
Keep the transaction ID in its own column. It is the easiest way to match a row to a payout later.
Changing a row does not change anything in Payhip. The sheet is a record, not a control panel.

Payhip

Integration page

Triggers (1)

Successful TransactionTriggers when a successful transaction is made.

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

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

Buyer data on your own server

Names, emails and amounts pass through your WordPress site to the sheet, not through another company's automation account.

A launch day costs the same

Runs are unlimited, so a product launch with hundreds of sales needs no bigger plan than a quiet week.

Books your accountant can read

A plain ledger with categories saves you from sending screenshots of dashboards at tax time.

Common questions

How do I send Payhip sales to Google Sheets?

Create a workflow with the Payhip Successful Transaction trigger, make a test purchase, then add Google Sheets Add New Row and map date, buyer, product and amount to columns.

Can I see sales by product?

Yes. Use a Router on the product name to write each sale to that product's tab, or keep one tab and use a pivot table on the Product column.

Can I send buyers something extra after they pay?

Yes. Keep a bonus link for each product in the sheet, find it with Lookup Row Data and send it with the Email (SMTP) step in the same workflow.

Does it work for memberships and courses too?

Any Payhip sale that completes fires Successful Transaction, so digital downloads, courses and memberships all reach the sheet. Use the product name to tell them apart.

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

Start automating Payhip 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. Payhip integration 1.0.0, Google Sheets integration 2.2.4.