Connect Recurly and Google Sheets

Recurly handles billing, but finance and customer success often want the numbers in a spreadsheet they can sort, chart and share. FlowMattic writes Recurly events to Google Sheets as they happen: new subscriptions, renewals, account changes, usage records and voided credits. It suits subscription businesses that report from a sheet or keep a simple customer register beside Recurly.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in Recurly17 triggers

Do this in Google Sheets19 actions

1. TriggerSubscription Created

2. ActionAdd New Row

When Recurly fires Subscription 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

Recurly 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 Recurly subscription in a sheet

Each subscription is added with the account, plan, amount and start date, giving finance a running list of new revenue to total by month.

Subscription CreatedAdd New Row

View the template

Update the subscription's row each time it renews

Find the row by subscription ID and write the new period end and renewal count, so the sheet shows which customers keep paying.

Subscription RenewedLookup Row DataUpdate Row

Keep a customer register current when accounts change

When a company name, email or address changes in Recurly, the matching row in your register is updated, which keeps mail merges and reports accurate.

Account UpdatedLookup Row DataUpdate Row

Record usage for metered plans

Every usage record is added to a usage tab, so you can check metered billing against what customers actually used before invoices go out.

Usage CreatedAdd New Row

List upcoming renewals for the success team

The bill date reminder adds the account and renewal date to a tab, in a readable date format, so account managers can check in before the charge.

Subscription Renewal Bill Date ReminderDate/Time FormatterAdd New Row

Flag scheduled plan changes on the subscription row

When a downgrade or upgrade is scheduled for the next period, the Pending change cell of that subscription's row is filled in for the revenue forecast.

Subscription Pending Change ScheduledLookup Row DataUpdate Cell Data

Keep an audit tab of voided credit payments

Voided credit payments and invoices are written to their own tab, which gives finance a list to reconcile at month end.

Credit Payment VoidedAdd New Row

Set up: new subscriptions as rows

At the end, every new Recurly subscription is added to your sheet as one row.

Add the header row
Create columns such as Subscription ID, Account code, Email, Plan, Amount, Currency and Started.
Connect Google Sheets
Under Connects, add a Google account that can edit the spreadsheet.
Trigger on Subscription Created
Create a workflow with Recurly Subscription Created, follow the trigger's setup in the builder, then create a test subscription in Recurly.
Add New Row
Add Google Sheets Add New Row, map each subscription field to its column, test the step and switch the workflow on.

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

From Recurly	To Google Sheets
Subscription ID	Subscription ID
Account code	Account code
Account email	Email
Plan code	Plan
Unit amount	Amount
Currency	Currency
Activated at	Started

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 copy Recurly events into the sheet, so the sheet is a record only. Editing a row does not change anything in Recurly.
Several trigger names are close: Subscription Renewed fires when a renewal happens, Subscription Renewal Scheduled when one is booked for later. Pick the one your report needs.
Keep the subscription ID in its own column. Every update example finds the row with Lookup Row Data on that ID.

Recurly

Integration page

Triggers (17)

Account CreatedTriggers when an account is created.
Shipping Address CreatedTriggers when the shopping address is created.
Subscription CreatedTriggers when the subscription is created.
Usage CreatedTriggers when the usage is created.
Credit Payment CreatedTriggers when the credit payment is created.
Subscription UpdatedTriggers when the subscription is created.
Account UpdatedTriggers when an account is updated.
Billing Info UpdatedTriggers when the billing info is created.
Shipping Address UpdatedTriggers when the shopping address is updated.
Subscription ReactivatedTriggers when the subscription is reactivated.
Subscription RenewedTriggers when the subscription is renewed.
Subscription Pending Change ScheduledTriggers when the subscription pending change is scheduled.
Subscription ResumedTriggers when the subscription is renewed.
Subscription Renewal Bill Date ReminderTriggers whent the subscription bills.
Subscription Renewal ScheduledTriggers when the subscription renewal is scheduled.
Credit Invoice VoidedTriggers when the credit invoice is void.
Credit Payment VoidedTriggers when the credit payment is voided.

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

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

Billing events in a shared sheet

Finance and success teams read subscriptions, renewals and usage from a sheet without needing Recurly seats.

Billing data stays on your server

Customer and payment details pass from Recurly to Google Sheets through your own WordPress site.

Every renewal, no extra cost

Runs are unlimited on every plan, so a renewal day for thousands of accounts costs the same as a quiet one.

Common questions

Can I log Recurly subscriptions in Google Sheets automatically?

Yes. Use the Recurly Subscription Created trigger with Google Sheets Add New Row. Every subscription created after you switch the workflow on is added as a row.

Can the sheet show renewals and plan changes too?

Yes. Build workflows on Subscription Renewed, Subscription Updated and Subscription Pending Change Scheduled, each finding the subscription's row with Lookup Row Data and updating it.

Will past subscriptions be added?

No. The triggers only see events from the moment the workflow is on. Export existing subscriptions from Recurly once and import them into the sheet.

Can I split rows by plan?

Yes. Add a Router on the plan code after the trigger and point each path's Add New Row at a different tab.

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

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