Datasette in Sheets

Here's a summary of how to import data from Datasette directly into Google Sheets. The basic method is the importdata() function, and you can also create a named function that wraps it.

If you need to put an API token in the HTTP header, you have to use Google Apps Script instead, since importdata() doesn't support passing headers.

The example spreadsheet shows all three approaches.

• Using importdata() directly
• Using a named function that wraps importdata()
• The Google Apps Script approach for when you need to send an API token as a header