⚙️ 工程

在 Google Sheets 中使用 SQL 函数从 Datasette 获取数据SQL functions in Google Sheets to fetch data from Datasette

simonwillison.net·2026-04-20 节选正文

文章总结了在 Google Sheets 中直接查询 Datasette 数据的多种方法，包括使用 `importdata()` 函数、封装命名函数，或通过 Google Apps Script 发送带 API 令牌的请求。这些模式简化了数据从 Datasette 到电子表格的自动化流程。

阅读原文

Simon Willison

20th April 2026

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

I put together some notes on patterns for fetching data from a Datasette instance directly into Google Sheets - using the importdata() function, a "named function" that wraps it or a Google Apps Script if you need to send an API token in an HTTP header (not supported by importdata().)

Here's an example sheet demonstrating all three methods.

Posted 20th April 2026 at 2:33 am

需要完整排版与评论请前往来源站点阅读。