Google Sheets add-on
Ratevert Converter
Ratevert Converter is a Google Sheets add-on that lets people convert currencies, FX rates, stocks, ETFs, funds, and crypto directly inside a spreadsheet. It is built for informational market conversions, portfolio notes, travel currency calculations, and quick cross-market lookup workflows.
What the add-on does
The add-on adds custom spreadsheet formulas and a small Sheets menu that call Ratevert's API for live conversion and search results. It supports Currency/FX, Stocks, ETFs, Funds, and Crypto using the same asset catalog as Ratevert.com.
RATEVERT_CONVERT(amount, from, to)
Converts an amount from one Ratevert asset into another.
=RATEVERT_CONVERT(100, "USD", "EUR")RATEVERT_RATE(from, to)
Returns the live one-unit rate between two supported assets.
=RATEVERT_RATE("NVDA", "BTC")RATEVERT_SEARCH(query, market)
Searches Ratevert assets by symbol, name, or market category.
=RATEVERT_SEARCH("bitcoin", "crypto")Free fair-use limits
- 100 conversion rows per day
- 30 search requests per day
- 15 input rows per batch formula
Requested Google access
Ratevert requests only the access needed to run formulas in the current spreadsheet and call Ratevert's conversion API.
Optional Ratevert account connection
The formulas work without signing in to Ratevert. Users who want their paid Ratevert plan limits in Google Sheets can choose Connect account from the Sheets add-on menu. That opens a Ratevert.com approval link, where the user signs in to Ratevert and approves the connection.
This account connection uses a Ratevert token, not a Google email/profile lookup. The add-on code does not read, transmit, or store Google user email or profile data, and does not request Gmail, Calendar, Docs, or Drive-wide access. Google Workspace Marketplace may still display standard identity permissions such as openid, userinfo.email, or userinfo.profile in its consent summary.
Why Ratevert requests these scopes
spreadsheets.currentonly lets the add-on work only in the Google Sheet where it is installed or used. Ratevert does not request Drive-wide access and does not request permission to read every file in a user's Google Drive.
script.external_request lets the add-on send formula inputs to Ratevert.com so it can return live conversion rates and asset search results.
Data handling
Formula inputs such as amount, source asset, target asset, search text, and market filter are sent to Ratevert API endpoints to calculate results. Ratevert also uses an a pseudonymous, one-way hashed per-spreadsheet identifier for fair-use limits. The raw spreadsheet identifier is not sent to Ratevert, and Ratevert applies another one-way hash before storing quota counters. If a user connects a Ratevert account, Ratevert uses that account's plan status to apply higher Sheets limits.
Formula inputs and search text are processed only to return the requested result and are not persisted by Ratevert. Google Apps Script may cache conversion results for up to 60 seconds and search results for up to 5 minutes. Burst quota records are deleted after 24 hours, daily quota records after 30 days, and expired pending connections within 24 hours. Approved connections remain until the user disconnects or deletes the Ratevert account.
Ratevert does not sell Google Workspace data, use it for advertising or credit decisions, use it to train AI/ML models, or transfer it to third-party AI training services. Ratevert's use of information received from Google Workspace APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.
The add-on is for educational and informational conversion workflows. It is not financial, investment, tax, or trading advice.