SQL functions in Google Sheets to fetch data from Datasette
- Google Sheets 的 importdata 函数可直接拉取 Datasette 公开数据
- 需认证时可用 Google Apps Script 发送带 Token 的请求
- 命名函数可封装 importdata 提升复用性和可读性
TIL: SQL functions in Google Sheets to fetch data from Datasette
[Simon Willison’s Weblog](http://simonwillison.net/)
**Sponsored by:** Honeycomb — AI agents behave unpredictably. Get the context you need to debug what actually happened. Read the blog
20th April 2026
TILSQL functions in Google Sheets to fetch data from Datasette— I've been experimenting with ways to fetch data from Datasette and display it in Google Sheets.
I put together some notes on patterns for fetching data from a Datasette instance directly into Google Sheets - using the `importdata()` function, a "named function" that wraps it or a Google Apps Script if you need to send an API token in an HTTP header (not supported by `importdata()`.)
Here's an example sheet demonstrating all three methods.
Posted 20th April 2026 at 2:33 am
Recent articles
- Changes in the system prompt between Claude Opus 4.6 and 4.7 - 18th April 2026
- Join us at PyCon US 2026 in Long Beach - we have new AI and security tracks this year - 17th April 2026
- Qwen3.6-35B-A3B on my laptop drew me a better pelican than Claude Opus 4.7 - 16th April 2026
This is a **beat** by Simon Willison, posted on 20th April 2026.
google 405spreadsheets 7datasette 1478
Monthly briefing
Sponsor me for **$10/month** and get a curated email digest of the month's most important LLM developments.
Pay me to send you less!