Connect Peggy Pay and Google Sheets

Peggy Pay handles one-off orders, installment plans, subscriptions and 1-click upsells. FlowMattic writes the events that matter to Google Sheets: each payment, each failed direct debit, each cancellation and each upsell. You get a payments record your bookkeeper can use and a churn list your team can act on.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Peggy Pay13 triggers

Do this in Google Sheets19 actions

1. TriggerSubscription Payment

2. ActionAdd New Row

When Peggy Pay fires Subscription Payment, 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

Peggy Pay 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 Peggy Pay subscription payment

Each direct debit for a subscription adds a row with customer, product and amount, giving you a monthly income record in one tab.

Subscription PaymentAdd New Row

View the template

Chase failed installment debits from a sheet

A failed installment adds a row to a follow-up tab, and Email (SMTP) asks the customer to update their bank details.

Installment Payment FailedAdd New RowEmail (SMTP)

Track which upsells customers take

Each 1-click upsell becomes a row with the product and order, so you can compare upsell offers in the sheet.

New UpsellAdd New Row

Mark a subscriber as cancelled when they leave

When a customer stops through the unsubscribe page, the workflow finds them and sets the status to Cancelled, so the active list stays correct.

Subscription Cancelled By CustomerLookup Row DataUpdate Row

Bring a subscriber back to active on reactivation

Subscription Reactivated finds the same row and resets the status, with a reactivated date, so win-backs are visible.

Subscription ReactivatedLookup Row DataUpdate Row

List new installment plans with their schedule

New Installment adds a row for each plan started. Date/Time Formatter writes the start date in a format the sheet can calculate with.

New InstallmentDate/Time FormatterAdd New Row

Set up: subscription payments as rows

At the end, every Peggy Pay subscription payment is logged as a row in your sheet.

Prepare the payments tab
Add headers such as Date, Customer, Email, Product, Amount and Order ID.
Connect Google Sheets
Under Connects, add the Google account that can edit the file.
Pick Subscription Payment
Create a workflow with the Peggy Pay Subscription Payment trigger and follow the setup in the trigger step.
Wait for a debit
Use a test subscription or wait for the next direct debit so FlowMattic captures the data.
Map and switch on
Add Google Sheets Add New Row, map the payment fields, test the step and turn the workflow on.

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

From Peggy Pay	To Google Sheets
Payment date	Date
Customer name	Customer
Email	Email
Product	Product
Amount	Amount

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

Subscription Cancelled By Owner fires when you pause a subscription yourself, while Subscription Cancelled By Customer fires when the customer stops it. Log them in separate columns.
Failed debits come from two triggers: Installment Payment Failed and Subscription Payment Failed. Build both if you sell both kinds of plan.
Use the order ID or email as the key for any workflow that updates a row.

Peggy Pay

Integration page

Triggers (13)

New InstallmentTriggers when a new payment is started.
Installment PaymentTriggers when a new direct debit for an order with payment in installments.
Installment Payment FailedTriggers if a direct debit for payment in installments has failed.
New SubmissionTriggers for a new submission.
New SubscriptionTriggers when a new subscription is started.
New UpsellTriggers when someone purchased a new 1-click upsell.
Order Status ChangedTriggers when an order status has been adjusted.
Subscription Cancelled By CustomerTriggers when a subscription is stopped by the customer via the unsubscribe page.
Subscription Cancelled By OwnerTriggers when a subscription is paused.
Subscription ChangedTriggers when a subscription has been adjusted.
Subscription PaymentTriggers when a new direct debit for a subscription.
Subscription Payment FailedTriggers when a failed direct debit for a subscription.
Subscription ReactivatedTriggers when a subscription has been restarted.

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

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

Payment records on your server

Customer and payment data pass through your own WordPress site to the sheet, not through another automation provider.

Every debit, same price

Runs are unlimited, so a growing subscriber base does not mean a growing automation bill.

Bookkeeping from a sheet

Your bookkeeper totals income from a tab instead of asking for exports each month.

Common questions

How do I log Peggy Pay payments in Google Sheets?

Create a workflow with the Peggy Pay Subscription Payment trigger, then add Google Sheets Add New Row and map date, customer, product and amount. Use Installment Payment for installment plans.

Can I see failed direct debits?

Yes. Installment Payment Failed and Subscription Payment Failed each start a workflow. Add the customer to a follow-up tab and, if you like, email them with Email (SMTP).

Can I keep one row per subscriber?

Yes. Add the row on New Subscription, then update it from Subscription Changed, Subscription Cancelled By Customer and Subscription Reactivated workflows that find it by email or order ID.

Are form submissions included?

New Submission fires for new Peggy Pay submissions. Write them to their own tab if you collect details before payment.

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

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