Simon Willison • 4/20/2026

SQL functions in Google Sheets to fetch data from Datasette

This article explores three methods for fetching data from a Datasette instance directly into Google Sheets: using the importdata() function, wrapping it in a named function for reusability, and employing Google Apps Script when an API token is needed in an HTTP header. It includes an example sheet demonstrating all three patterns, making it a practical guide for integrating Datasette with Google Sheets for data analysis and reporting.

0 comments

#API Integration #Datasette #Google Apps Script