資料中心
Destinations
Data Hub > Destinations lists 32 places to send data and how to connect each. There are four delivery methods.
| Delivery | Destinations | How |
|---|---|---|
| Live URL | Google Sheets, Excel, Looker Studio, Power BI, Tableau, Microsoft Fabric, Python, REST API | The destination reads a Data API URL. Every refresh returns current values |
| AI connector (MCP) | Claude, ChatGPT, Claude Code, Cursor, Gemini, Copilot, Perplexity, Manus, Lovable, Antigravity, Grok | AI Analysis |
| Scheduled push | Webhook, Slack, email (CSV) | Scheduled Exports |
| Coming soon | BigQuery, Snowflake, Redshift, Databricks, PostgreSQL, MySQL, Azure SQL, Supabase, Amazon S3, Azure Blob | Press Request destination. Workaround shows what to use meanwhile |
Every live URL needs a Data API key. Build URLs with the CSV URL / JSON URL / Google Sheets formula buttons in Data Explorer.
Google Sheets
- Build a query in the explorer and press Google Sheets formula.
- Paste it into an empty cell (e.g.
A1) and replaceYOUR_DATA_API_KEYwith your key.
- Google re-reads it about every hour while the sheet is open.
- The key sits in the formula, so keep the sheet shared inside your organization. Revoking the key turns the sheet into
#N/A. - Very many IMPORTDATA calls in one sheet hit Google's limits. Put the fields you need into one query.
Excel
- Data > Get Data > From Other Sources > From Web.
- Paste the CSV URL, then OK > Load.
- Refresh with Data > Refresh All. Turning on "Refresh data when opening the file" in the query properties helps.
Looker Studio
Looker Studio cannot read an external CSV URL directly, so go through Google Sheets.
- Create the sheet as described in Google Sheets above.
- In Looker Studio, Add data > Google Sheets and pick that sheet.
- The sheet refreshes hourly and Looker Studio follows.
Power BI
- In Power BI Desktop, Get Data > Web.
- Paste the CSV URL in Basic mode and load.
- Publish to the Power BI service and set a scheduled refresh.
Tableau
Point a Tableau Prep input or a web data connector at the CSV URL, or use files delivered by a scheduled export (webhook) as the source. Schedule refreshes in Tableau Cloud.
Microsoft Fabric
In Dataflow Gen2, Get data > Web API, enter the JSON URL and expand the data array.
Python
What about warehouses (BigQuery, Snowflake …)?
Direct loading is coming soon. Meanwhile:
- Scheduled export (webhook) → a Cloud Function / Lambda receives and loads it
- A scheduler (Cloud Scheduler, Airflow, cron) runs the Python code above and loads the result
- Supabase: an Edge Function cron reads the JSON URL and stores it

