tr Skip to content
Black Friday Lifetime FlowMattic from $399 One payment, unlimited workflows. Ends in --Days --Hrs --Min --Sec See the deal

Connect Funraise and Google Sheets

Funraise collects donations and keeps the donor record for nonprofits. Many development teams and treasurers still report from a Google Sheet. FlowMattic logs each new Funraise transaction as a row and corrects it when the transaction is edited, all from your own WordPress site, so the board report and the fundraising platform show the same amounts.

8 triggers 19 actions 5 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in Funraise2 triggers

Do this in Google Sheets19 actions

1. TriggerTransaction Created
2. ActionAdd New Row

When Funraise fires Transaction 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

Funraise 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.

Funraise app icon Google Sheets app icon Ready-made template

Log each new Funraise gift in a donation tracker

Every transaction adds a row with the donor, amount, campaign and date, so the treasurer has a current list for reconciliation and reporting.

Transaction CreatedAdd New Row

View the template
Funraise app icon Google Sheets app icon

Correct the row when a transaction is edited

Gifts get corrected after the fact: a changed amount, a new designation, a fixed donor name. The row is found by transaction ID and overwritten with the edited values.

Transaction EditedLookup Row DataUpdate Row

Funraise app icon Google Sheets app icon

Flag major gifts for a personal thank-you

A Filter passes gifts above your threshold. They go onto a Major gifts tab and Email (SMTP) tells the development director, who calls the donor that week.

Transaction CreatedFilterAdd New RowEmail (SMTP)

Funraise app icon Google Sheets app icon

Give each campaign its own tab

A Router reads the campaign or form name and writes the gift to that campaign's tab, so the gala, the year-end appeal and the monthly giving program each have their own totals.

Transaction CreatedRouterAdd New Row

Funraise app icon Google Sheets app icon

Format amounts and dates for the board report

Number Formatter and Date/Time Formatter write the amount with two decimals and the date as day, month and year, so the sheet can go into a board pack as it is.

Transaction CreatedNumber FormatterDate/Time FormatterAdd New Row

Set up: a donation tracker

At the end, each new Funraise transaction appears as a row in your donation tracker.

  1. Lay out the tracker

    Create headers such as Transaction ID, Date, Donor, Email, Amount, Campaign and Recurring.

  2. Connect Funraise and Google

    Under Connects, add your Funraise account and a Google account that can edit the tracker.

  3. Start with Transaction Created

    Create a workflow on the Funraise Transaction Created trigger and record a test gift so FlowMattic captures its fields.

  4. Write the row

    Add Google Sheets Add New Row, map the transaction fields, test it, then switch the workflow on.

  5. Add the edit workflow

    Build a second workflow on Transaction Edited with Lookup Row Data on the Transaction ID column and Update Row.

Import the ready-made template Beginner, about 5 min to set up
Log each new Funraise gift in a donation tracker Template
  1. Funraise app icon 1. Trigger in Funraise Transaction Created
  2. Google Sheets app icon 2. Action in Google Sheets Add New Row

    Fields mapped from the earlier steps (a typical setup)

    From FunraiseTo Google Sheets
    Transaction IDTransaction ID
    Transaction dateDate
    Donor nameDonor
    Donor emailEmail
    AmountAmount
    Campaign or formCampaign
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

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

  • Store the Funraise transaction ID in its own column. The edit workflow needs it to find the right row.
  • The fields above are an example. Check a captured transaction for the exact names, including whether recurring gifts are marked.
  • Donor details are personal data. Share the tracker only with people who would see them in Funraise anyway.

Triggers (2)

  • Transaction CreatedTriggers when a new transaction is created.
  • Transaction EditedTriggers when a transaction is edited.
Google Sheets app icon

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

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

Edits reach the sheet too

Because edited transactions update their row, the tracker does not drift from Funraise as gifts are corrected.

Year-end giving costs the same

Runs are unlimited, so the December rush of gifts needs no bigger FlowMattic plan than a quiet month.

Donor data stays with you

Each gift passes through your own WordPress site on the way to the sheet, not through another company's automation account.

Common questions

Can I sync Funraise donations to Google Sheets?

Yes. One workflow on Transaction Created adds each gift as a row. A second on Transaction Edited looks up that row by transaction ID and updates it, so the sheet follows changes as well as new gifts.

How do I split gifts by campaign?

Add a Router after Transaction Created with one path per campaign, each writing to its own tab. Or keep one tab and use a Campaign column with a pivot table.

Can the team hear about large gifts?

Yes. Add a Filter for amounts above your threshold and an Email (SMTP) step that tells the development director, alongside the row.

What if an edited transaction is not in the sheet yet?

Lookup Row Data finds nothing. Add a Router after the lookup so that case runs Add New Row instead of Update Row.

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

Start automating Funraise and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

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. Funraise integration 1.0.0, Google Sheets integration 2.2.4.