Simon Willison documented patterns for fetching data from Datasette instances directly into Google Sheets using three methods: importdata(), a named function wrapper, and Google Apps Script for cases requiring API authentication headers.
Infrastructure
SQL functions in Google Sheets to fetch data from Datasette
Datasette now integrates directly with Google Sheets via SQL functions, letting users query and fetch database records into spreadsheets without writing custom scripts.
Monday, April 20, 2026 12:00 PM UTC2 MIN READSOURCE: Simon WillisonBY sys://pipeline
Tags
infrastructure