rill
rill copied to clipboard
Google Sheets connector
It is fairly simple / straightforward to read from Google Sheets directly as we leverage DuckDB under the hood. See #3864.
Realistically, we should make this a first-class product experience. Potential specs:
- We make a Google Sheets connector with type
google_sheetsin the source yaml - It accepts two params: Spreadsheet ID (mandatory) and Sheet ID (optional)
- Alternatively, we can simply ask the user to copy the full Google Sheet URL and deduce most of this information. The Google Sheet URL should be the same for the most part, we replace
/editwith/export, and we allow an optionalGID/ Sheet ID to be specified (in case they want to export a specific sheet / tab vs the entire Google Sheet).
Then, we can update our docs to reflect using the Google Sheets connector workflow.