See your Coinbase balance totals by asset
Turn a growing balance log into a quick view of totals for the assets you track.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Aggregate Column Data
Find rows matching a column value and calculate results from another column.
Why this helps
A list of individual balance snapshots can be hard to scan when you want a specific asset total.
- Makes asset totals easier to inspect.
- Uses existing spreadsheet rows for the calculation.
- Reduces manual summing during portfolio reviews.
Setup
Build it in a few focused steps.
- 1Connect Coinbase and Google Sheets in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the balance summary.
- 3Tell Notis to retrieve Coinbase balances, update your balance log, and aggregate the rows for the asset and value you specify.
- 4Pick a recurring schedule and choose where run reports should go.
- 5Test with one real example and confirm the aggregation matches the log.
Questions about this workflow
Does this calculate the market value of each asset?
Only if the sheet contains the values needed for that calculation. Coinbase balance data and your sheet columns determine what can be aggregated.
Can it summarize more than one asset?
Ask Notis to run the aggregation for the asset rows and value column you want to review.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Coinbase to Google Sheets. A trigger fires from one place; an action lands in another.
Coinbase triggers
Google Sheets actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Sheet to Existing Spreadsheet
Adds a grid sheet with rows and columns to an existing spreadsheet.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Aggregate Column Data
Find rows matching a column value and calculate results from another column.
Append Dimension
Adds empty rows or columns to the end of a sheet.
Batch get spreadsheet
Retrieves data from selected spreadsheet ranges.
Auto-Resize Rows or Columns
Automatically adjusts row heights or column widths to fit their contents.
Batch Update Values by Data Filter
Updates spreadsheet values in ranges that match data filters.
Clear Basic Filter
Removes the basic filter from a sheet.
Batch update spreadsheet (Deprecated)
Connect any two apps with Notis in the middle.
Coinbase and Google Sheets, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Google Sheets.