SQL functions in Google Sheets to fetch data from Datasette
Simon Willison documented methods for fetching data from Datasette into Google Sheets using importdata(), named functions, or Google Apps Scripts for API token handling. An example spreadsheet demonstrates all three approaches.