Create Google Sheets columns for each new Mercury transaction
Keep track of new transactions effortlessly with this workflow. Once a new transaction is recorded in the Mercury application, a corresponding column is immediately created in your Google Sheets. This set up ensures you have a real-time, organized record of all transactions, saving you time and enhancing record-keeping efficiency.
- When this happens...New TransactionTriggers when a new transaction is created on any bank account (eg. Checking or Savings). Optionally, can also include any Credit account (eg. Physical/Virtual Credit or Debit). This trigger fires before the transaction settles.
- automatically do this!Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Mercury and Google Sheets
Discover other triggers and actions you can use with Mercury and Google Sheets
- Checking/Savings Account Balance Update
Triggers when an account's balance changes.
Try ItTriggerInstant - Failed Transaction
Triggers when a transaction fails.
Try ItTriggerInstant - Settled Transaction
Triggers when a transaction settles.
Try ItTriggerInstant - Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerPolling
- Cancelled Transaction
Triggers when a transaction is cancelled.
Try ItTriggerInstant - New Transaction
Triggers when a new transaction is created on any bank account (eg. Checking or Savings). Optionally, can also include any Credit account (eg. Physical/Virtual Credit or Debit). This trigger fires before the transaction settles.
Try ItTriggerInstant - Transaction Update
Triggers when a transaction changes status. This will trigger on any update to a transaction, including revisions to the amount following settlement, such as in the case of tips for service staff.
Try ItTriggerInstant - Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerInstant
Related Zap Templates
- Create rows in Google Sheets for new transactions in Mercury
- Create Google Sheets rows for new settled transactions in Mercury
- Update Google Sheets rows with new account balances from Mercury
- Create spreadsheet rows in Google Sheets for updated account balances in Mercury
- Monitor Mercury account balances and create spreadsheet columns in Google Sheets
- Create multiple spreadsheet rows in Google Sheets when new balances are updated in Mercury
- Update Google Sheets row(s) when new account balances are reported in Mercury
- Track new Mercury account balances by creating spreadsheets in Google Sheets
- Create spreadsheet rows at the top in Google Sheets for new Mercury transactions
- Create multiple rows in Google Sheets for new settled transactions in Mercury






