Get a fresh price check when you add a coin to your sheet
Add a watchlist row and get current quotes without opening another tab.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Get Latest Cryptocurrency Quotes
Tool to get the latest market quotes for one or more cryptocurrencies. Use after selecting desired coins.
Why this helps
A watchlist can go stale while you switch between spreadsheets and market pages to look up prices.
- Fetch current quotes for assets named in new rows.
- Reduce manual price lookups while updating a watchlist.
- Keep the lookup tied to the moment a row is added.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and CoinMarketCap once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis to fetch the latest CoinMarketCap quotes for the cryptocurrency in each new watchlist row.
- 4Pick New Rows in Google Sheet as the trigger and choose where run reports go.
- 5Test with one real watchlist row.
Questions about this workflow
What should a new watchlist row contain?
Include a cryptocurrency name or symbol that identifies the asset you want CoinMarketCap to quote.
Does this save a price back into the sheet?
The available CoinMarketCap action fetches latest quotes. This workflow does not promise to write results into Google Sheets.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Coinmarketcap. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Coinmarketcap actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Exchange Listings Historical
Tool to retrieve historical exchange listings for a specified date. Use when you need exchange listings as of a past date (YYYY-MM-DD).
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Cryptocurrency Listings Latest
Tool to fetch the latest active cryptocurrency listings with their current market data. Use when you need up-to-date snapshots of asset metrics.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Cryptocurrency Map
Tool to retrieve a mapping of all cryptocurrencies, including their unique IDs, symbols, and names. Use when you need reference IDs for crypto assets.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Get Latest Cryptocurrency Quotes
Tool to get the latest market quotes for one or more cryptocurrencies. Use after selecting desired coins.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Exchange Map
Tool to retrieve a mapping of all cryptocurrency exchanges. Use when you need reference IDs for exchanges.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Get cryptocurrency info
Tool to fetch metadata (description, logo, URLs) for one or more cryptocurrencies. Use when you need static asset details like descriptions, logos, and related links.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Get exchange info
Tool to get detailed metadata for one or more exchanges. Use when you need exchange logos, supported fiats, launch dates, and official links.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Get API Key Info
Tool to retrieve your CoinMarketCap API key details, rate limits, and usage statistics. Use after setting your API key to inspect limits and usage.
Connect any two apps with Notis in the middle.
Google Sheets and Coinmarketcap, 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 Coinmarketcap.