Tools
New TIL on fetching data from a Datasette instance into Google Sheets using importdata(), named custom functions or Google Apps Script https…
Simon Willison shared a tutorial on integrating Datasette instances with Google Sheets, demonstrating multiple methods including the importdata() function, custom named functions, and Google Apps Scri
Simon Willison shared a tutorial on integrating Datasette instances with Google Sheets, demonstrating multiple methods including the importdata() function, custom named functions, and Google Apps Script for automated data fetching. This approach enables users to pull data directly from Datasette databases into spreadsheets for analysis and reporting purposes.
Related
- SQL functions in Google Sheets to fetch data from Datasette
- datasette-export-database 0.3a1
- datasette-ports 0.3
Source: Simon Willison (X) | 2026-04-20