Log every successful BPC payment in a Google Sheets spreadsheet

Each time BPC reports a successful payment, FlowMattic adds a row to a Google Sheets spreadsheet you choose, so your paid transactions build up in one sheet you can sort and share.

BPC

Google Sheets

Download this workflow Browse more workflows

2 steps Setup ~5 min Used on 913 sites Free to import

The Log every successful BPC payment in a Google Sheets spreadsheet workflow on the FlowMattic canvas, with 2 steps across BPC, Google Sheets — The workflow as it appears in the builder after import. Each step opens for editing.

What this workflow does

Payment dashboards are fine for a quick look, but sooner or later someone wants the numbers in a spreadsheet: for bookkeeping, for a monthly summary, or for a colleague who has no login to the payment tool. Exporting by hand each week is slow and easy to forget. This workflow writes each successful BPC payment into a sheet as it happens.

The BPC trigger, Payment Succeeded, fires when a payment goes through. FlowMattic receives the payment data BPC sends with that event and passes it to Google Sheets, where the Add New Row action appends one row to the spreadsheet and sheet you select. You decide which payment values go in which column.

A run starts only for payments that BPC marks as successful. Failed attempts and refunds are separate BPC events, so they don't appear in this sheet unless you build another workflow for them. Task History lists every run, so you can see what BPC sent and what reached the sheet.

A running revenue log for your bookkeeper

Share the sheet with your accountant so they see each successful BPC payment as a dated row, without asking you for an export at month end.

Daily payment totals for a small shop

Add a SUM formula below the payment column or a pivot table on a second tab, and the sheet shows takings per day as rows arrive.

Matching payments to bank deposits

Keep the payment ID and amount from BPC in their own columns, then tick each row off when the matching deposit lands in your bank account.

How this workflow runs

What happens at each step once the workflow is on, and what you need before you import it.

Step 1Trigger
BPC Payment Succeeded
Starts a run each time BPC reports that a payment succeeded. The payment details from that event become values you can map in the next step.
Step 2Action
Google Sheets Add New Row
Writes one new row into the BPC log spreadsheet and the tab inside it that you select. Connect your Google account, then map BPC payment values, such as the amount or reference, to the columns you want filled.

What you need

FlowMatticCore
BPC 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.

Make a test payment in BPC after import so FlowMattic captures a real sample. You can then see exactly which payment values are available before you map the sheet's columns.
Give the sheet a header row first. Named columns make the mapping step easier to read and let you sort or filter the log later.
Want a team ping as well? Add a Slack or email step after the Google Sheets step so someone hears about each payment while the row is written.

Questions about this workflow

Will past BPC payments be added to the sheet?

No. The trigger reacts to new successful payments, so the sheet starts filling from the moment you turn the workflow on. Older payments would need a manual export.

Are refunds or failed BPC payments logged too?

Not by this workflow. It listens only for the Payment Succeeded event. Other BPC events need their own trigger, either in a second workflow or a copy of this one.

Which BPC payment details can I put in the sheet?

Whatever BPC includes with the Payment Succeeded event. Run a test payment after import and look at the captured data in the trigger step to see the full list before you map columns.

Can the BPC payments go to an existing spreadsheet?

Yes. In the Google Sheets step you choose the spreadsheet and the sheet inside it, so you can point it at a log you already keep. New rows are added below the existing ones.