SQL functions in Google Sheets to fetch data from Datasette

# TIL: SQL functions in Google Sheets to fetch data from Datasette Source: https://simonwillison.net/2026/Apr/20/datasette-sql/ 20th April 2026 TILSQL functions in Google Sheets to fetch data from Datasette (https://til.simonwillison.net/google-sheets/datasette-sql)— 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 (https://docs.google.com/spreadsheets/d/14lRV2-AeBmjI3lJbl2apwfC_ncXqL0uSV68lmtzUI7I/edit?gid=0#gid=0) demonstrating all three methods. None (https://til.simonwillison.net/google-sheets/datasette-sql) Posted 20th April 2026 (https://simonwillison.net/2026/Apr/20/) at 2:33 am