Connect BlueSnap and Google Sheets

BlueSnap reports on charges, refunds, chargebacks and payouts as they happen. FlowMattic turns those notifications into Google Sheets rows, so a finance team can reconcile payouts, chase failed renewals and track disputes from a spreadsheet they share, instead of exporting reports from the BlueSnap console each week.

Try FlowMattic free See example workflows

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

Try a pairing

When this happens in BlueSnap22 triggers

Do this in Google Sheets19 actions

1. TriggerCharge

2. ActionAdd New Row

When BlueSnap fires Charge, 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

BlueSnap 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 BlueSnap charge in a sheet

Each completed sale becomes a row with the shopper, amount, currency and transaction ID, a running sales ledger the bookkeeper can match against bank deposits.

ChargeAdd New Row

View the template

Mark the original sale as refunded

When a refund goes through, look up the transaction ID in the sales sheet and update that row's status and refund amount, so net revenue stays correct without a second list.

RefundLookup Row DataUpdate Row

Track each chargeback from opening to outcome

A new chargeback adds a row to the disputes tab. A second workflow on Chargeback Status Changed finds that row and records the new status, so you can see which disputes are still open.

Chargeback Status ChangedLookup Row DataUpdate Row

Build a recovery list from failed renewals

Subscription Charge Failure writes the shopper and subscription to a sheet that the retention team works through, calling or emailing before the subscription lapses.

Subscription Charge FailureAdd New Row

Reconcile payouts in a formatted ledger

Format the payout amount and date before writing, so each transfer to your bank account sits in a payouts tab that totals cleanly by month.

PayoutNumber FormatterDate/Time FormatterAdd New Row

List subscriptions set to cancel at renewal

Cancel On Renewal gives you a window before the customer is gone. Logging them separately from completed cancellations shows which accounts are still worth a win-back offer.

Cancel On RenewalAdd New Row

Set up: successful charges in a sheet

At the end, each successful BlueSnap charge adds a row to your sales sheet.

Add the sheet's columns
Create a sheet with a header row for Date, Transaction ID, Shopper, Email, Amount and Currency.
Trigger on Charge
Create a workflow, choose BlueSnap and the Charge trigger, and follow the trigger's instructions to send BlueSnap's notifications to FlowMattic.
Capture a test charge
Make a small test charge so FlowMattic captures the fields BlueSnap sends.
Connect Google Sheets and add a row
Connect a Google account that can edit the file, add Add New Row, map the charge fields to the columns, test and switch on.

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

From BlueSnap	To Google Sheets
Transaction ID	Transaction ID
Shopper name	Shopper
Shopper email	Email
Amount	Amount
Currency	Currency
Transaction date	Date

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 BlueSnap's transaction ID in its own column on every row. Refund and chargeback workflows use it to find the original sale.
Each BlueSnap event is its own trigger, so charges, refunds and payouts are separate workflows. Point them at separate tabs to keep totals simple.
Field names depend on the notification BlueSnap sends, so the mapping above is an example. Test each trigger once and map from the captured data.

BlueSnap

Integration page

Triggers (22)

PayoutTriggers when BlueSnap sends funds to your payout account.
Account UpdaterTriggers when the account updater service has processed a card update.
CancellationTriggers when a subscription is canceled.
Cancellation RefundTriggers when a refund is issued as part of a subscription cancellation.
Cancel On RenewalTriggers when a subscription is set to be canceled at its next renewal date.
Credit Card Charge FailedTriggers when a credit card charge fails.
Credit Card Status ChangedTriggers when the status of a shopper's credit card changes.
ChargeTriggers when a charge/sale transaction is successful.
Charge PendingTriggers when a charge is initiated but is pending
ChargebackTriggers when a chargeback event occurs.
Chargeback Status ChangedTriggers when the status of an existing chargeback changes.
Contract ChangeTriggers when a change is made to a subscription contract.
Transaction DeclineTriggers when a transaction is declined.
Failed Payout TransferTriggers when a transfer of funds to your payout account fails.
Merchant Partner OnboardedTriggers when a new merchant is successfully onboarded.
Merchant Partner StatusTriggers when the status of a partner merchant changes.
Payment Method UpdatedTriggers when a shopper's payment method details are updated.
Pending RefundTriggers when a refund is initiated and is pending.
RecurringTriggers when a recurring charge i.e. subscription renewal is processed.
RefundTriggers when a refund is successfully processed.
Subscription Charge FailureTriggers when a recurring subscription charge fails.
Subscription ReminderTriggers a reminder related to a subscription event.

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

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

Payment data on your own server

Shopper names, emails and amounts pass through your WordPress site on the way to the sheet, not through a third-party automation account.

One sheet for the whole payment cycle

Sales, refunds, disputes and payouts land in tabs of one spreadsheet, which is easier to reconcile than four console reports.

No charge per transaction

Runs are unlimited on every plan, so a busy sales day logs every charge at no extra cost.

Common questions

Which BlueSnap events can I log in Google Sheets?

Any BlueSnap trigger in the list below, including Charge, Refund, Chargeback, Payout, Recurring and Subscription Charge Failure. Each one starts its own workflow and can write to its own tab.

Can a refund update the row of the original charge?

Yes, if the charge row holds the transaction ID. Start from Refund, search that column with Lookup Row Data and change the status and amount with Update Row.

Can I check the sheet before real sales are logged?

Yes. Make one test charge so FlowMattic captures the data, then test the Add New Row step with it. The row appears in your sheet, and the workflow only runs on live sales once you switch it on.

Will renewals and first charges be mixed together?

Only if you send them to the same tab. Recurring is its own trigger, so subscription renewals can go to a renewals tab while one-off sales use Charge.

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

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