When a new member is created in Patreon, add the member details to a Google Spreadsheet
When someone becomes a member of your Patreon campaign, this workflow adds their details as a new row in Google Sheets, giving you a growing list of supporters you can sort, share and work from.
Patreon
Google Sheets2 steps Setup ~5 min Used on 954 sites Free to import
What this workflow does
Patreon shows your members inside its own dashboard. If you want a list you can sort, share with a collaborator or use for thank-you mail, you end up exporting it again and again. This workflow keeps a spreadsheet growing as new members join.
The Patreon trigger fires when a member is created on your campaign. The member data it receives is passed to the next step. The Google Sheets step then adds a new row to the spreadsheet you choose, with each column mapped to a member field.
The sheet only receives rows; the workflow never edits or removes them. If a member leaves or changes tier, their row stays as it was when they joined. Task History records each run, so you can check what Patreon sent for a given member.
Thank-you list for a podcast
A podcaster reads new patrons' names on air. The sheet gives a running list of members who joined since the last episode.
Sharing supporter info with a team
An illustrator's assistant handles reward fulfilment. The shared sheet lets them see new members without access to the Patreon account.
A record outside Patreon
A creator keeps their own copy of who joined and when, in a spreadsheet they control.
How this workflow runs
What happens at each step once the workflow is on, and what you need before you import it.
Patreon Create MemberRuns when a new member is created on your Patreon campaign. The member's details are passed on for mapping in Google Sheets. Connect your Patreon account on import.
- Google Sheets Add New Row
Adds a row to the Google Sheets spreadsheet you pick with the Patreon member's details. Map each column to a member field and connect your Google account.
What you need
- FlowMatticCore
- Patreon AccountAccount
- Google Sheets AccountAccount
After importing, map your own data. To keep the template universal, not every step is pre-filled. Open each step in the builder and connect your accounts and fields (channels, lists, sheets, recipients) before you switch the workflow on.
Make it yours
Changes worth making after you import it.
- Freeze the header row in your sheet and sort by a date column the Patreon data provides, if it sends one, to see the newest members first.
- Add a Filter after the trigger if you only want members from certain tiers in the sheet. Check a test run to see what tier data Patreon sends.
- Add a second action after the sheet, such as a Slack or email message, if you also want to hear about each new member.
Questions about this workflow
Are my existing Patreon members added to the sheet?
No. Only members created after the workflow is turned on start a run.
Does the Google Sheets row update when a Patreon member changes tier?
No. The workflow only adds a row when a member is created. Changes after that are not written to the sheet.
Which Patreon member fields can I put in the sheet?
Any field the Patreon trigger sends. Once you import, wait for or create a new membership, then look at the captured data to choose your columns.
Does the spreadsheet need column headers first?
Set up the header row before you map the step, so each Patreon field can be matched to a named column.
More Spreadsheets & Data workflows
Other ready-to-import templates from the same category.
Import this workflow into your WordPress site
Download the JSON, import it from the Workflows screen and connect your accounts. Every run stays on your server, with no per-task fees.
30-day money-back guarantee Unlimited workflows and runs Self-hosted