corpus.blog
43,317 blogs · 5,519,570 posts Claim your blog
Record · corpus.blog/posts/01a08219-d150-7202-9c2c-78f81b453be6

SQL functions in Google Sheets to fetch data from Datasette

Simon Willison TIL · published 20 April 2026

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at til.simonwillison.net Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
External links
10
Words captured
1,522

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://support.google.com/docs/answer/3093335?hl=en
support.google.com
https://docs.datasette.io/en/latest/csv_export.html
docs.datasette.io
https://latest.datasette.io/fixtures/roadside_attractions.csv
latest.datasette.io
https://latest.datasette.io/fixtures/roadside_attractions
latest.datasette.io
https://latest.datasette.io/fixtures/-/query.csv?sql=select+pk%2C+name%2C+address%2C+url%2C+latitude%2C+longitude+from+roadside_attractions
latest.datasette.io
https://raw.githubusercontent.com/simonw/til/main/google-sheets/named-function.jpg
raw.githubusercontent.com
https://github.com/simonw/datasette-auth-tokens/blob/main/README.md
github.com
https://developers.google.com/apps-script
developers.google.com
https://raw.githubusercontent.com/simonw/til/main/google-sheets/apps-script-editor.jpg
raw.githubusercontent.com
https://docs.google.com/spreadsheets/d/14lRV2-AeBmjI3lJbl2apwfC_ncXqL0uSV68lmtzUI7I/edit?gid=0
docs.google.com