rill icon indicating copy to clipboard operation
rill copied to clipboard

Google Sheets connector

Open AndrewRTsao opened this issue 1 year ago • 0 comments

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_sheets in 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 /edit with /export, and we allow an optional GID / 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.

AndrewRTsao avatar Jan 17 '24 22:01 AndrewRTsao