| title | description | sidebar_label | sidebar_position |
|---|---|---|---|
Google Sheets |
Connect to data in Google Sheets |
Google Sheets |
13 |
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:
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)":::note 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).
:::
