FeedThis weekArticle
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