Refresh crypto quotes from new Google Sheets watchlist rows
Add a coin to your sheet and get its current market quote without another lookup.
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
New watchlist entries sit without current prices, so market reviews become a manual research task.
- Keeps watchlists current
- Reduces copy and paste research
- Creates a consistent quote lookup routine
Setup
Build it in a few focused steps.
- 1Connect Google Super and Coinmarketcap in Notis once.
- 2Create an automation named for your crypto watchlist.
- 3Tell Notis to fetch the latest quote for each cryptocurrency in every new row and summarize the result.
- 4Pick New Rows in Google Sheet as the trigger and choose a report channel.
- 5Test it by adding one real coin row.
Questions about this workflow
Can I add symbols or names in the sheet?
Yes. Tell Notis which identifier format your rows use so it can select the matching asset.
Does this update the sheet?
No. This workflow fetches and reports CoinMarketCap data; a sheet update action is not available here.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Coinmarketcap. A trigger fires from one place; an action lands in another.
Google Super 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.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Get Latest Cryptocurrency Quotes
Tool to get the latest market quotes for one or more cryptocurrencies. Use after selecting desired coins.
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.
Exchange Map
Tool to retrieve a mapping of all cryptocurrency exchanges. Use when you need reference IDs for exchanges.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
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.
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.
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.
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 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 Super 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.