Connect Pabbly Subscriptions and Google Sheets

Founders and finance leads who sell on recurring plans often want billing history in a sheet they can filter, chart and hand to an accountant. FlowMattic writes Pabbly Subscriptions payments, upgrades, cancellations and affiliate commissions into Google Sheets rows, and it works the other way too, turning a row your team adds into a new customer and subscription.

Try FlowMattic free See example workflows

27 triggers 24 actions 7 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in Pabbly Subscriptions21 triggers

Do this in Google Sheets19 actions

1. TriggerSuccessful Payments

2. ActionAdd New Row

When Pabbly Subscriptions fires Successful Payments, 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

Pabbly Subscriptions 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.

Write each successful payment into a ledger row

Every payment Pabbly Subscriptions receives becomes one row with customer, plan, amount and date, giving your bookkeeper a running income ledger without logging in to the billing dashboard.

Successful PaymentsAdd New Row

Log upgrades by month in a plan changes tab

Date/Time Formatter turns the upgrade date into a month label before the row is added, so a pivot table can show expansion revenue month by month and which plans people move up from.

Subscription UpgradeDate/Time FormatterAdd New Row

Mark a subscriber as leaving when cancellation is scheduled

The cancellation takes effect at the end of the billing cycle, so the workflow finds the customer's row by email and sets its status to leaving, which gives your team time to reach out.

Subscription Cancel ScheduledLookup Row DataUpdate Row

Keep a payout sheet of affiliate commissions

Each commission Pabbly Subscriptions creates is added to a payouts tab with the affiliate and amount, so whoever pays affiliates at month end works from one list.

Commission CreateAdd New Row

Flag overdue accounts on your customer sheet

When an invoice goes into dunning because the fee is overdue, the workflow finds that customer's row and writes Overdue into one status cell, so account managers see who needs a nudge.

Dunning InvoiceLookup Row DataUpdate Cell Data

Create a customer and subscription from a sales sheet row

Deals closed by phone go into a sheet. Each new row creates the customer in Pabbly Subscriptions and then starts the plan named in that row, so billing begins without retyping anything.

New Spreadsheet RowCreate CustomerCreate Subscription

Cancel a plan when a status column says Cancel

Account managers type Cancel in a status column. A Filter checks the value, then Cancel Subscription ends that customer's plan, keeping cancellations in the sheet your team already reviews each week.

Update Specific Column ValueFilterCancel Subscription

Set up: each payment as a ledger row

When you finish, every payment Pabbly Subscriptions receives is written to your Google Sheet as one row.

Prepare the ledger
Create a spreadsheet with headers such as Date, Customer, Email, Plan, Amount and Transaction so each payment field has a column waiting for it.
Connect Google Sheets
Under Connects, add a Google Sheets connection with an account that has edit access to the ledger spreadsheet.
Choose Successful Payments
Start a workflow with the Pabbly Subscriptions Successful Payments trigger, follow its setup in the builder, then take a test payment so FlowMattic captures a real sample.
Map Add New Row
Add a Google Sheets step with Add New Row, pick the spreadsheet and tab, map each payment field to its column, test the step and switch the workflow on.

From Pabbly Subscriptions	To Google Sheets
Payment date	Date
Customer name	Customer
Customer email	Email
Plan name	Plan
Amount	Amount
Transaction ID	Transaction

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

The payment fields above are examples. What arrives depends on your plans and checkout, so look at the captured sample before you map columns.
Create Subscription works on an existing customer, which is why the sales sheet example runs Create Customer first.
Pabbly Subscriptions has five actions here: create, update or get a customer, and create or cancel a subscription. Refunds and invoices can be logged from its triggers but not created from a sheet.
Subscription Cancel Scheduled fires when the cancellation is booked, not when access ends. Use Subscription Expire if a row should change only on the final day.

Pabbly Subscriptions

Integration page

Triggers (21)

Customer CreateWhen a customer is created
Customer DeleteWhen a customer is deleted
Subscription CreateWhen a subscription is created
Subscription ActivateWhen a subscription is activated
Subscription UpgradeWhen a subscription is upgraded
Subscription RenewWhen a subscription is renewed
Subscription DowngradeWhen a subscription is downgraded
Subscription Cancel ScheduledWhen a subscription is cancellation is scheduled for the end of the current billing cycle
Subscription ExpireWhen a subscription is expired
Subscription DeleteWhen a subscription is deleted
Subscription Trial ExpiredWhen a subscription trial expires
Successful PaymentsWhen a payment is received
Payment FailureWhen there is an error in processing payments at the time of purchase
Payment RefundWhen a customer asks for a refund
Create InvoiceWhen an invoice is created
Pending InvoiceWhen an invoice is in pending state as the recurring subscription fee not received
Dunning InvoiceWhen an invoice is in a dunning state as the subscription fee is overdue
Create CreditWhen a credit is created
Close CreditWhen credit is closed
Commission CreateWhen a commission is created
Affiliate RequestWhen an affiliate request is made

Actions (5)

Create CustomerCreate a new customer
Update Customer DetailsUpdate existing customer details
Get Single CustomerGet a single customer details
Create SubscriptionCreate a subscription for existing customer
Cancel SubscriptionCancel a subscription for existing customer

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

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

Billing history you can share

A spreadsheet is easy to hand to an accountant or investor, and each row comes from the billing event itself, so nobody copies totals by hand.

Payments pass through your own site

FlowMattic runs on your WordPress server, so customer emails and amounts go from Pabbly Subscriptions to Google without a third service in between, and runs are unlimited.

Your team can act from the sheet

With Google Sheets triggers, adding a row or changing a status cell can create customers or cancel plans in Pabbly Subscriptions.

Common questions

What can the Pabbly Subscriptions Google Sheets integration record?

Any of the 21 Pabbly Subscriptions triggers can write a row, including new customers, subscriptions, renewals, upgrades, downgrades, payments, refunds, invoices, credits and commissions. Most teams start with a payments ledger and add a cancellations tab later.

Can a renewal update the existing row instead of adding a new one?

Yes. Start with Subscription Renew, find the customer's row with Lookup Row Data by email, then write the new renewal date with Update Row. Use Add New Row instead if you want every renewal as its own line.

Can I keep refunds apart from payments?

Yes. Build a second workflow on Payment Refund that writes to a refunds tab. With payments and refunds in separate tabs, net revenue for the month is one subtraction.

Can I add a customer from the sheet without starting a subscription?

Yes. Use New Spreadsheet Row with Create Customer only. Start the plan later, or in a separate workflow that watches a plan column with Update Specific Column Value and runs Create Subscription.

Can the sheet show each customer's current plan?

Yes. Build workflows on Subscription Upgrade and Subscription Downgrade that use Lookup Row Data and Update Row to rewrite one plan column, while the plan changes tab keeps the full history.

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

Start automating Pabbly Subscriptions 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 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Pabbly Subscriptions integration 1.0, Google Sheets integration 2.2.4.