Tools
SQL functions in Google Sheets to fetch data from Datasette
TIL: SQL functions in Google Sheets to fetch data from Datasette I put together some notes on patterns for fetching data from a Datasette instance directly into Google Sheets - using the importdata()
TIL: SQL functions in Google Sheets to fetch data from Datasette 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. Tags: spreadsheets, datasette, google
Related
- New TIL on fetching data from a Datasette instance into Google Sheets using importdata(), named custom functions or Google Apps Script https…
- datasette-export-database 0.3a1
- datasette-ports 0.3
- SQLite Query Result Formatter Demo
Source: Simon Willison | 2026-04-20