Google Sheets and CSV
Pull live Onym data into a spreadsheet with one formula, or download CSVs from the dashboard.
YOUR_API_KEY with a key from Settings → API and MCP. Keys are shown once when you create them.Live data in Google Sheets
Every dataset is also available as CSV. Spreadsheets can't send headers, so these URLs also accept the key as ?key=.
=IMPORTDATA("https://getonym.com/api/v1/domains/acme.example/datasets/visibility.csv?range=90d&key=YOUR_API_KEY")Swap visibility for prompts, sources or answers, and add any filter: &surface=chatgpt_app:chat, &branded=all, &topic=Open%20source. Google refreshes the formula about once an hour.
Anyone who can see the sheet can see the key. Create a dedicated read key named after the sheet, so you can revoke it without breaking anything else.
Weekly report in Google Sheets builds a complete report from these.
Excel and other tools
Anything that can fetch a URL can use the CSV endpoints. In Excel, use Data → From Web with the same URL.
Dashboard exports
Every table in the dashboard has a CSV download that respects the filter bar. Any member can export, viewers included. Files are named host-table-range.csv.
| Export | Columns |
|---|---|
| Answers | run date, prompt, topic, branded, surface, method, named you, your position, competitors named, other brands, cited URLs, answer text |
| Prompts | prompt, topic, branded, answers, named you, visibility, 95% range, average position, top competitor and its rate, change and whether it's significant |
| Sources | domain, owner, type, answers citing, share of answers, prompts, named you, gap answers, trend, top URLs |
| Competitors | brand, is you, answers, named, visibility, 95% range, share of voice, average position, change and whether it's significant |
Values that start with =, +, - or @ are prefixed with ' so spreadsheets don't run them as formulas.