Simon Willison documents methods to fetch data from Datasette instances directly into Google Sheets using SQL functions.

🔍 Let's dive in

Simon Willison has published patterns for integrating Datasette with Google Sheets, enabling direct SQL queries from spreadsheets. The guide covers three approaches: using importdata(), creating named functions, and leveraging Google Apps Script for authenticated requests. An example sheet demonstrates all three methods in practice.

Lead coverage: Simon Willison — SQL functions in Google Sheets to fetch data from Datasette ↗

🕰 The timeline · 1 source

Simon Willison first-party · 3d ago · 2/5

SQL functions in Google Sheets to fetch data from Datasette ↗

Simon Willison has published patterns for integrating Datasette with Google Sheets, enabling direct SQL queries from spreadsheets. The guide covers three approaches: using importdata(), creating named functions, and leveraging Google Apps Script for authenticated requests. An example sheet demonstrates all three methods in practice.

I've been experimenting with ways to fetch data from Datasette and display it in Google Sheets.

— Simon Willison

🔧 Debug

Cluster ID: 1d3388fcd0
Importance (max): 2
Members: 1
Sources: Simon Willison
Earliest: 2026-04-20T02:33:58.000Z
Latest: 2026-04-20T02:33:58.000Z
Lead URL: https://simonwillison.net/2026/Apr/20/datasette-sql