Google Sheets + Mercury
Create rows in Google Sheets for new transactions in Mercury
Effortlessly track your Mercury transactions in a centralized Google Sheet with this seamless automation. Whenever a new transaction occurs in the Mercury app, a new row will be added to your selected Google Sheets document. Simplify your financial monitoring and stay organized with this efficient workflow.
Effortlessly track your Mercury transactions in a centralized Google Sheet with this seamless automation. Whenever a new transaction occurs in the Mercury app, a new row will be added to your selected Google Sheets document. Simplify your financial monitoring and stay organized with this efficient workflow.
- When this happens...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.
- automatically do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
- Free forever for core features
- 14 day trial for premium features & apps
Account Balance
Triggers when an account's balance changes.
Try ItFailed Transaction
Triggers when a transaction fails.
Try ItSettled Transaction
Triggers when a transaction settles.
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try It
Cancelled Transaction
Triggers when a transaction is cancelled.
Try ItInclude Credit Accounts?
Try ItTransaction 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 ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try It
