Convert a crypto amount when the inputs in your sheet change
Update the monitored range and run the conversion from your stated amount and currencies.
Trigger
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.
Action
Price Conversion
Tool to convert an amount from one cryptocurrency or fiat currency into another. Use when conversion rates are needed.
Why this helps
Rechecking a conversion after updating an estimate means leaving the sheet and repeating the lookup.
- Start a conversion when monitored cell values change.
- Use CoinMarketCap to convert an amount between specified currencies.
- Avoid repeating a manual conversion lookup after every relevant edit.
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 what amount and source and destination currencies to convert using CoinMarketCap.
- 4Pick Cell Range Values Changed as the trigger and choose where run reports go.
- 5Test with one real change to the monitored range.
Questions about this workflow
Can the changed cells define the amount and currencies?
Describe the inputs clearly in your instruction. CoinMarketCap's conversion action needs an amount and source and destination currencies.
Does it monitor an entire spreadsheet?
The trigger monitors a specified A1 range, and fires when values in that range change.
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.