The Scenario
You research crypto markets and every morning you check news for the 10 tokens on your tracking list before writing your daily briefing. Right now "checking news" means opening 10 browser tabs, scanning three or four aggregator sites per token, deciding what's relevant, and copying headlines manually into a Google Sheet that serves as your source notes.
It's 6:45 AM. You have 45 minutes before the briefing needs to be drafted. Ten tokens. Four sites each. You will not finish in time.
The bad version:
- Open Finage's crypto news endpoint, search for token 1, copy the first five headlines and URLs, paste them into the sheet.
- Repeat for each of the 10 tokens.
- Realize headlines for two tokens returned in a different language because Finage picked up regional sources, and now you need to filter those out manually before the briefing is useful.
Your value as an analyst is in the interpretation, not the aggregation. The time you spend copying headlines is time you are not spending on the briefing that pays the bills.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the token list and calls Finage on your behalf. It fetches the latest news articles for each symbol, extracts headline, source, and URL, and writes them into adjacent columns — all 10 tokens in a single operation.
For each crypto symbol in column A of my Google Sheet, fetch the latest 5 news articles from Finage and write headline, source, and URL into the adjacent columns
What You Get
- For each token: up to 5 rows of news, each with headline in column B, source name in column C, and full article URL in column D
- Results written in a contiguous block beneath each token so the layout matches your briefing format
- Tokens that return fewer than 5 articles get however many exist; no padding with empty rows
What If the Data Is Not Quite Ready
You want 10 articles per token instead of 5
For each crypto symbol in column A, fetch the latest 10 news articles from Finage and write headline, source, and URL into columns B, C, and D
You want to filter out any article from a source you've already flagged as low-quality
For each crypto symbol in column A, fetch the latest 10 news articles from Finage, exclude any articles whose source appears in my Blocked Sources list on the Reference sheet, and write headline, source, and URL for the remaining articles into columns B through D
Your token list includes both crypto pairs like BTCUSD and standalone symbols like ETH — you need the news endpoint to handle both formats
For each symbol in column A, determine whether it is formatted as a pair (e.g., BTCUSD) or a standalone ticker (e.g., ETH) and call the appropriate Finage news endpoint for each format, then write headline, source, and URL for the 5 most recent articles into columns B through D
You want to load news for all 10 tokens, deduplicate any article that appeared under multiple tokens, and produce a ranked list by token with unique headlines only
For each token in column A, fetch the latest 5 news articles from Finage, write headline, source, and URL for each, then in a second pass identify any article URL that appeared under more than one token and mark it "SHARED" in column E so you can decide whether to include it once or under each token
One prompt handles the fetch, the deduplication logic, and the shared-article tagging together.
Try It
Open a Google Sheet with your crypto watchlist in column A. Get the 7-day free trial of SheetXAI and ask it to populate the latest Finage news headlines for every token before you write your morning briefing. You can also ask it to refresh the current price and 24-hour change for those same tokens, or return to the Finage hub for everything the integration covers.