Connect Patreon and Google Sheets

Patreon tells you who supports you, but a spreadsheet is where creators plan shout-outs, reward shipping and monthly budgets. FlowMattic writes each new member, pledge change and departure into Google Sheets from your WordPress site, so your patron list is always ready to sort, filter and share with a helper.

Try FlowMattic free See example workflows

15 triggers 19 actions 6 example workflows 1 ready-made template Unlimited runs

Try a pairing

When this happens in Patreon9 triggers

Do this in Google Sheets19 actions

1. TriggerCreate Member

2. ActionAdd New Row

When Patreon fires Create Member, 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

Patreon 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

Add each new Patreon member to the patron sheet

Every new supporter becomes a row with name, email, tier and join date, ready for thank-you notes and the credits list in your next video.

Create MemberAdd New Row

View the template

Keep each patron's tier and status up to date

When a member changes, the workflow finds their row by email and rewrites the tier and status columns, so the sheet never shows last month's level.

Update MemberLookup Row DataUpdate Row

Mark patrons who leave instead of deleting them

A departure sets the status column to left with the date. You keep the history for win-back messages and can see how long each person stayed.

Delete MemberLookup Row DataUpdate Row

Build a shipping list for physical reward tiers

A Filter passes only pledges on tiers that include merch or prints, and those patrons go to a shipping tab your helper works from each month.

Create Member PledgeFilterAdd New Row

Log every pledge change as a history row

Upgrades and downgrades are appended rather than overwritten, so you can look back at which posts or launches made people raise their pledge.

Update Member PledgeAdd New Row

File new pledges in a tab for the month

Date/Time Formatter turns the pledge date into a month name used as the sheet name, giving a clean tab per month for income planning.

Create PledgeDate/Time FormatterAdd New Row

Set up: each new member as a row

At the end, every new Patreon member is added to your Google Sheet as one row.

Prepare the sheet
Create a spreadsheet with a header row such as Name, Email, Tier, Status and Joined so each column is there to map.
Connect both accounts
Under Connects, add your Patreon creator account and a Google account that can edit the spreadsheet.
Start with Create Member
Create a workflow with the Patreon Create Member trigger and wait for, or create, a test member so FlowMattic captures the fields.
Add New Row
Add Google Sheets Add New Row, choose the spreadsheet and sheet, map the member fields, test the step and switch the workflow on.

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

From Patreon	To Google Sheets
Full name	Name
Email	Email
Tier title	Tier
Patron status	Status
Pledge start	Joined

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 log Patreon events in the sheet; they do not change a pledge or message a patron. Information flows from Patreon to the sheet only.
Member and pledge events are separate triggers. Use the member triggers for who supports you and the pledge triggers for how much and on which tier.
Shipping details only appear if your tier collects them. Check the captured data of a test member before mapping address columns.
Patron emails and addresses are personal data. Share the sheet only with the people who send rewards, not with the whole team.

Patreon

Integration page

Triggers (9)

Create MemberTriggers when a member is created.
Update MemberTriggers when a member is updated.
Delete MemberTriggers when a member is deleted.
Create PledgeTriggers when a pledge is created.
Update PledgeTriggers when a pledge is updated.
Delete PledgeTriggers when a pledge is deleted.
Create Member PledgeTriggers when a member pledge is created.
Update Member PledgeTriggers when a member pledge is updated.
Delete Member PledgeTriggers when a member pledge is deleted.

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

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

A list you can actually work with

Sort by tier, filter by join month and hand a shipping tab to a helper without exporting a file from Patreon each time.

Patron data passes through your site

FlowMattic runs on your own WordPress site, so member details go from Patreon to your sheet without another company's account in between.

Growth does not raise the cost

Runs are unlimited, so a launch that brings hundreds of new members in a week needs no bigger plan.

Common questions

How do I export Patreon members to Google Sheets automatically?

Connect Patreon and Google Sheets under Connects, start a workflow with Create Member and add an Add New Row step mapped to your header row. Each new member is then written to the sheet without manual exports.

Can the sheet show who cancelled?

Yes. Use Delete Member with Lookup Row Data and Update Row to mark the existing row as left, or Delete Pledge if you track pledges. Keeping the row lets you count how long people stayed.

Can I send patrons on one tier to a separate tab?

Yes. Add a Filter or Router on the tier title after the trigger and point each path's Add New Row step at its own sheet name.

Will existing patrons be added?

No. The triggers fire on new events from the moment the workflow is on. Export your current members from Patreon once and paste them into the sheet to start.

Can I count patrons per tier?

Yes. With a Status and Tier column filled by the workflow, a COUNTIFS formula or a pivot table in Google Sheets gives the totals and stays current as rows change.

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

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