Google Sheets + Mercury
Create multiple rows in Google Sheets for new settled transactions in Mercury
Keep track of your Mercury app settled transactions easily with this automation. Whenever a settled transaction happens on Mercury, corresponding rows are instantly created in your Google Sheets spreadsheet. This workflow helps streamline your financial recording process, keeping everything orderly and up-to-date without you having to manually enter data on both platforms.
Keep track of your Mercury app settled transactions easily with this automation. Whenever a settled transaction happens on Mercury, corresponding rows are instantly created in your Google Sheets spreadsheet. This workflow helps streamline your financial recording process, keeping everything orderly and up-to-date without you having to manually enter data on both platforms.
- When this happens...Settled Transaction
Triggers when a transaction settles.
- automatically do this!Create Multiple Spreadsheet Rows
Create one or more new rows in a specific spreadsheet (with line item support).
- 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 ItNew 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 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
