Connect MoonClerk and Google Sheets

MoonClerk collects one-time and recurring payments through simple checkout forms, which suits churches, schools, clubs and small businesses. FlowMattic writes MoonClerk payments and plan changes into Google Sheets from your WordPress site, so the treasurer or bookkeeper has a payment record, a list of active plans and a short list of failed charges.

Try FlowMattic free See example workflows

11 triggers 19 actions 6 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in MoonClerk5 triggers

Do this in Google Sheets19 actions

1. TriggerPayment Successful

2. ActionAdd New Row

When MoonClerk fires Payment Successful, 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

MoonClerk 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 successful MoonClerk payment

Each payment that goes through becomes a row with payer, form, amount and date, a ledger the bookkeeper can reconcile against the bank.

Payment SuccessfulAdd New Row

View the template

Keep a register of active recurring plans

Each new plan is added to a Plans tab with the payer, amount and interval, so you can see recurring income at a glance.

Plan CreatedAdd New Row

Mark a plan as ended in the register

When a plan is canceled or runs out of payments, look it up and set an Ended date, so the active plans list stays accurate without manual edits.

Plan EndedLookup Row DataUpdate Row

List failed plan payments and email the payer

Each failed recurring charge is logged on a Failed tab, then an email from your own mail server asks the payer to update their card.

Plan Payment FailedAdd New RowEmail (SMTP)

Send each checkout form's payments to its own tab

A Router reads the form name, so donations, membership dues and event fees each land on their own tab and total separately.

Payment SuccessfulRouterAdd New Row

Format amounts before they reach the ledger

Number Formatter sets decimals and separators on each amount, so totals in the sheet add up without fixing cells by hand.

Payment SuccessfulNumber FormatterAdd New Row

Set up: successful payments as rows

At the end, every successful MoonClerk payment is added to your Google Sheet as one row.

Prepare the sheet
Add a header row such as Date, Payer, Email, Form, Amount, Currency and Payment ID.
Connect Google Sheets
In Connects, add a Google Sheets connection with an account that can edit the payments spreadsheet.
Start with Payment Successful
Create a workflow with the MoonClerk Payment Successful trigger, follow its setup instructions and make a small test payment so FlowMattic captures the fields.
Add New Row
Add Google Sheets Add New Row, map the payment fields to the columns, test the step and switch the workflow on.

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

From MoonClerk	To Google Sheets
Payment date	Date
Payer name	Payer
Payer email	Email
Form name	Form
Amount	Amount
Currency	Currency
Payment ID	Payment ID

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

Payment Created fires for payments in any state, and Payment Successful fires when one succeeds. Use one of them for the ledger, or a successful payment is written twice.
Keep the plan ID in the Plans tab so Plan Ended and Plan Payment Failed can find the right row with Lookup Row Data.
The mapping above is an example. Check the data captured from your test payment and map what MoonClerk sends.

MoonClerk

Integration page

Triggers (5)

Payment CreatedTriggers when a payment is created in any state (failed, succeeded, etc).
Payment SuccessfulTriggers when a payment succeeds.
Plan CreatedTriggers when a plan is created.
Plan EndedTriggers when a plan is canceled or when the set number periods have been exhausted.
Plan Payment FailedTirggers when a payment related to a plan has failed.

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

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

Payer details stay on your server

Names, emails and amounts pass from MoonClerk through your own WordPress site into the sheet, not through an outside automation account.

Monthly plans add no cost

Every recurring charge is a run, and runs are unlimited, so a growing list of monthly donors or members needs no bigger plan.

A record the treasurer can use

Payments, plans and failures sit in one spreadsheet that a volunteer treasurer or bookkeeper already knows how to work with.

Common questions

Should I use Payment Created or Payment Successful?

Payment Successful for a ledger of money received. Payment Created fires for any state, including failed payments, which suits a full activity log with a status column.

Can I see which recurring plans are still active?

Yes. Add plans with Plan Created, then use Plan Ended to find the row and write an end date. Filter the Plans tab to rows without an end date.

Can I chase failed MoonClerk payments?

Yes. Plan Payment Failed starts a workflow that logs the failure with Add New Row and can send the payer a reminder with Email (SMTP).

Can donations and membership fees go to different tabs?

Yes. Add a Router after the payment trigger with one path per checkout form, each writing to its own tab or spreadsheet.

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

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