Simon Willison publishes technical guide for integrating Datasette with Google Sheets
On April 20, 2026, Simon Willison shared detailed documentation about three distinct methods for pulling data from Datasette into Google Sheets. The techniques include using the importdata() function, creating a named function wrapper, and implementing Google Apps Script for scenarios requiring API token authentication in HTTP headers. An example spreadsheet demonstrates all approaches. Willison offers a $10 monthly sponsorship for a curated email digest highlighting significant LLM developments.
Key facts
- Simon Willison published technical notes on April 20, 2026
- The guide covers three methods for fetching data from Datasette into Google Sheets
- Methods include importdata() function, named function wrapper, and Google Apps Script
- Google Apps Script is required for sending API tokens in HTTP headers
- An example spreadsheet demonstrates all three techniques
- Willison offers a $10/month sponsorship for a curated LLM developments email digest
- The content is hosted on simonwillison.net
- The guide addresses data integration between Datasette and Google Sheets
Entities
Artists
- Simon Willison