Simon Willison • 4/20/2026

SQL functions in Google Sheets to fetch data from Datasette

This article explores three methods to pull data from a Datasette instance into Google Sheets: using the importdata() function, creating a named function to wrap it, and employing Google Apps Script when an API token is required in HTTP headers. It includes an example sheet demonstrating all approaches, making it useful for developers integrating external databases with spreadsheets.

0 comments

#api #sql #Datasette