Connect PayWhirl and Google Sheets

PayWhirl bills your subscribers and reports each step: new customers, subscriptions, invoices, charges, refunds and cancellations. FlowMattic writes those events to Google Sheets, so finance has a ledger of paid invoices, support has a list of failed charges to chase, and every customer's row reflects their current plan.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in PayWhirl17 triggers

Do this in Google Sheets19 actions

1. TriggerCustomer Created

2. ActionAdd New Row

When PayWhirl fires Customer Created, 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

PayWhirl 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 new PayWhirl customer in a sheet

Each customer added through the portal, checkout widget or admin becomes a row, giving you a customer list outside PayWhirl.

Customer CreatedAdd New Row

View the template

List failed charges for follow-up

Each declined payment adds a row with the customer, invoice and amount, so someone can contact them before the next retry.

Charge FailedAdd New Row

Record paid invoices in a revenue ledger

Invoice Paid writes the amount and date to a ledger tab. Number Formatter makes the amount a clean number first, ready for monthly totals.

Invoice PaidNumber FormatterAdd New Row

Mark a subscription canceled on its row

When a subscription is deleted after failed attempts or by request, the workflow finds it by ID and sets the status and end date.

Subscription DeletedLookup Row DataUpdate Row

Keep a refunds log for finance

Every refund issued in PayWhirl adds a row with the charge, amount and date, so month-end reconciliation has the full list.

Charge RefundedAdd New Row

Update contact details when a customer edits their profile

Customer Updated finds the customer's row and rewrites email, phone or address, so the list your team uses stays correct.

Customer UpdatedLookup Row DataUpdate Row

Set up: new customers as rows

When you finish, each customer added to PayWhirl appears as a row in your sheet.

Make the customer tab
Create headers such as Customer ID, Name, Email, Phone and Created.
Connect Google Sheets
Add a Google Sheets connection in Connects with an account that can edit the spreadsheet.
Choose Customer Created
Create a workflow with the PayWhirl Customer Created trigger and complete the setup shown in the trigger step.
Add a test customer
Create a customer in PayWhirl admin so FlowMattic captures the data.
Write the row
Add Google Sheets Add New Row, map the customer fields, test the step and switch the workflow on.

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

From PayWhirl	To Google Sheets
Customer ID	Customer ID
First and last name	Name
Email	Email
Phone	Phone
Created date	Created

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 Created fires when invoices are created, before payment is attempted. Use Invoice Paid or Charge Succeeded when you only want money that has arrived.
Store PayWhirl IDs for customers, subscriptions and invoices in their own columns. The update workflows find rows by them.
Charge Refunded fires for refunds issued from PayWhirl. Refunds made directly in your payment gateway may not appear.

PayWhirl

Integration page

Triggers (17)

Customer CreatedTriggers when a customer is added to the account - via portal signup, widget checkout signup, or manually by admin.
Plan CreatedTriggers when a plan is created by the user.
Card CreatedTriggers when a new payment method is added by customer in portal or checkout pages, by admin for a customer.
Subscription CreatedTriggers when a customer is subscribed to a plan when invoices are created, before payment attempts - via widget checkout, manually by admin.
Invoice CreatedTriggers when an invoice is created - when subscription is created or renews and manually from admin.
Invoice ProcessedTriggers when the invoice is processed (payment attempted) this is usually automatic according to the payment schedule but could be manually triggered by admin.
Invoice PaidTriggers when the invoice is marked as paid.
Charge SucceededTriggers when a successful payment is made towards and invoice.
GiftCode SentTriggers when a gift code is sent to the recipient might be immediately after creation or on a scheduled date.
Customer UpdatedTriggers when the customer updates the profile from portal or admin updates customer details.
Plan UpdatedTriggers when a plan is updated by the user.
Subscription UpdatedTriggers when a customer or admin updates a subscription.
Charge RefundedTriggers manually when a refund is issued on PW side.
Charge FailedTriggers when an invoice payment is declined for any reason (but not held for review).
Subscription DeletedTriggers when a subscription is canceled - after max failed payment attempts are reached or manually by admin, user.
Invoice DeletedTriggers when admin manually deletes an invoice.
Card DeletedTriggers when a payment method is deleted by customer in portal, by admin.

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

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

Billing data on your server

Customer and payment details pass through your own WordPress site to the sheet, with no extra automation account holding them.

Renewal day costs the same

Runs are unlimited, so hundreds of invoices on the first of the month need no bigger plan.

Finance and support share one file

Each team reads its own tab of the same spreadsheet without logins to PayWhirl.

Common questions

How do I export PayWhirl customers to Google Sheets?

Create a workflow with the PayWhirl Customer Created trigger and a Google Sheets Add New Row step. Map ID, name and email, test with a customer and switch it on.

Can I track failed payments?

Yes. Charge Failed fires when an invoice payment is declined. Log each one with the customer and amount so your team can follow up.

Which trigger should I use for revenue reports?

Invoice Paid or Charge Succeeded, since both mean the payment went through. Subscription Created and Invoice Created fire before any payment is taken.

Can one row follow a subscription through its life?

Yes. Add the row on Subscription Created, then use Subscription Updated and Subscription Deleted workflows that find it by ID and run Update Row.

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

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