Log every successful BlueSnap charge in a Google Sheets spreadsheet

Each successful charge or sale in BlueSnap becomes a new row in a Google Sheets spreadsheet, giving you a running payment log you can sort, total and share without exporting reports from BlueSnap.

BlueSnap

Google Sheets

Download this workflow Browse more workflows

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

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

What this workflow does

BlueSnap keeps a full record of your transactions, but not everyone who needs the numbers has a login, and pulling exports for each weekly or monthly check gets old fast. A spreadsheet that fills itself as payments clear is easier to share with a bookkeeper or a partner. This workflow builds that spreadsheet for you.

The BlueSnap trigger fires when a charge or sale transaction is successful. FlowMattic hands the transaction data to Google Sheets, which adds a row to the spreadsheet and sheet you choose. You decide which transaction values land in which column when you map the step.

Only successful charges start a run, so declined attempts never reach the sheet. Refunds and chargebacks are separate BlueSnap events and are not logged by this template. Each run appears in Task History with the data that was sent, which helps if a row looks wrong.

Monthly figures for your bookkeeper

Share the sheet with your accountant, who totals each month's BlueSnap charges straight from the rows instead of waiting for you to send an export.

Sales tracking for a small online store

Sort and filter the log by amount or date to see which days bring in the most sales, using columns you mapped from each charge.

Matching payments to bank deposits

Keep one row per successful charge and tick each one off against your BlueSnap payouts when they arrive 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
BlueSnap Charge
Fires when a charge or sale transaction in BlueSnap is successful. The transaction details are passed to the Google Sheets step for mapping.
Step 2Action
Google Sheets Add New Row
Adds one row to the spreadsheet and sheet you pick for each successful charge. Connect your Google account, then map transaction values to the columns you set up in row one.

What you need

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

Set up the column headers in your sheet before mapping, and run one test charge so FlowMattic captures the BlueSnap fields you can choose from.
Want refunds and chargebacks in the same spreadsheet? Build a second workflow with the matching BlueSnap trigger and point it at another tab, so credits stay apart from sales.
Only interested in large payments? Add a Filter after the trigger that continues when the amount is greater than your threshold. The Filter drops the cents before comparing, which means a 500.75 charge is treated as 500.

Questions about this workflow

Are failed or declined BlueSnap charges logged?

No. The trigger fires only when a charge or sale transaction is successful, so declined attempts never start a run.

Will past BlueSnap transactions be added to the sheet?

No. Only charges that succeed after you turn the workflow on are logged. Export older transactions from BlueSnap and paste them into the sheet if you need a full history.

Does the workflow change anything in BlueSnap?

No. It only reads the charge event and writes a row to Google Sheets. Your BlueSnap account, payouts and settings are untouched.

Can BlueSnap refunds go into this Google Sheets log?

Not with this template, which listens for successful charges only. Add a second workflow using BlueSnap's refund trigger to log those.