Google Sheets

Google Sheets

Rill has the ability to read from any http(s) URL endpoint that produces a valid data file in a supported format. For example, to bring in data from Google Sheets as a CSV file directly into Rill as a source (leveraging the direct download link syntax), you can create a source_name.yaml file in the sources directory of your Rill project directory with the following content, don't forget to set the sheet to Anyone with the link:

type: source
connector: "duckdb"
sql: "select * from read_csv_auto('https://docs.google.com/spreadsheets/d/<SPREADSHEET_ID>/export?format=csv&gid=<SHEET_ID>', normalize_names=True)"

Updating the URL

Make sure to replace SPREADSHEET_ID and SHEET_ID with the ID of your spreadsheet and tab respectively (which you can obtain from looking at the URL when Google Sheets is open).

gsheets DuckDB Community Extension

In cases where setting the Google Sheet to Anyone with the link is not allowed, DuckDB has an extension that allows you to share the sheet to a Google service account. However, we have not yet implemented the DuckDB community extension in our deployment of DuckDB. Please contact us if you are interested in using this feature.