SQL functions in Google Sheets to fetch data from Datasette

20th April 2026

TIL

SQL 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.

Recent articles

- DeepSeek V4 - almost on the frontier, a fraction of the price - 24th April 2026

- Extract PDF text in your browser with LiteParse for the web - 23rd April 2026

- A pelican for GPT-5.5 via the semi-official Codex backdoor API - 23rd April 2026