The Scenario
You run a crypto advisory service for clients in the US, the EU, and the UK. Every Friday you send each client group a one-page price briefing for BTC, ETH, and SOL — same three coins, same three currencies, nine numbers total. You've been pulling USD from Coinranking, then running EUR and GBP through a currency converter, then assembling a 3×3 table in a Google Sheet, then copying it into the email. Somewhere in that chain, last week, the GBP column had EUR rates because you copy-pasted the wrong cell.
The bad version:
- Fetch BTC, ETH, and SOL prices from Coinranking in USD — three separate lookups because the trending page doesn't show all three simultaneously.
- Run each price through a currency converter website or Google Finance formula and manually type the EUR and GBP equivalents into the table.
- Check that the nine cells match nine separate source lookups, which is six more confirmation steps than any sane person wants to do on a Friday afternoon.
One wrong cell in a client-facing price table isn't just embarrassing — it's the kind of mistake that makes clients wonder what else you're eyeballing rather than verifying.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside Google Sheets and talks to Coinranking's multi-currency price endpoint directly. You describe the table you want and it pulls all nine values in a single call, building the grid as specified.
For Bitcoin, Ethereum, and Solana, fetch their current price in USD, EUR, and GBP from Coinranking and build a table in this sheet with coins as rows (starting in row 2) and currencies as columns (B for USD, C for EUR, D for GBP), with coin names in column A and currency headers in row 1
What You Get
- A 3×3 price grid: BTC, ETH, SOL in rows; USD, EUR, GBP in columns
- All nine values pulled in one request from Coinranking's native multi-currency endpoint — no currency converter step, no formula chain
- Numbers formatted consistently so you can copy the table directly into the client email without reformatting
What If the Data Is Not Quite Ready
You need more currencies — JPY and AUD as well
For Bitcoin, Ethereum, and Solana, fetch current prices in USD, EUR, GBP, JPY, and AUD from Coinranking and write them into a table with coin names in column A and currency columns B through F starting at row 2
The coins are listed in column A and you want SheetXAI to read them rather than you naming them
For the 5 coin names listed in column A of this sheet, fetch their current price in USD, EUR, and GBP from Coinranking and fill in columns B, C, and D respectively
You want a timestamp added to the table for the briefing email
Fetch BTC, ETH, and SOL prices in USD, EUR, and GBP from Coinranking, build a 3×3 price grid starting at row 2, and write the retrieval timestamp in cell A1 formatted as "Prices as of [date] [time] UTC"
Full client briefing table with formatting in one shot
Clear columns A through D from row 1 downward, write "Coin", "USD", "EUR", "GBP" in row 1 as headers, fetch current prices for Bitcoin, Ethereum, and Solana in USD, EUR, and GBP from Coinranking and fill in rows 2 through 4, format all price cells as numbers with 2 decimal places, and write the retrieval timestamp in cell A6
Nine numbers, clean formatting, timestamped — ready to copy into the briefing email.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet you use for your weekly price briefing, then ask it to pull the multi-currency table from Coinranking. When you want the broader picture, see Pull the Top 100 Coins by Market Cap Into a Google Sheet and the Coinranking Google Sheets overview.