articleSimon Willison
SQL functions in Google Sheets to fetch data from Datasette
The post experiments with pulling data from a Datasette instance into Google Sheets. It outlines three approaches: using importdata(), a named function wrapping it, and a Google Apps Script for API tokens. An example sheet demonstrates all three.
published APR 20, 2026★★★★★
Read the sourcesimonwillison.net/2026/Apr/20/datasette-sql/#atom-everything
[*] Opens in a new tab · no tracking on Lantern's side
- Source
- Simon Willison
- Ingested
- APR 20, 2026 · 19:10
- Editorial score
- 3.0 / 5