google-spreadsheet

Imports data from a Google Spreadsheet and converts it to a datatable.

Imports data from a Google Sheets spreadsheet. Private spreadsheets should be shared with [e-mail]

Arguments

Inputs:

url: The URL of the Google Sheets spreadsheet. Private sheets should be shared with [e-mail]

sheet name: The title of the sheet (tab) from which data will be imported. If unspecified, the first sheet in the spreadsheet will be imported.

range: A valid range of cells (e.g. A1:L512) that contain data. If unspecified, the whole sheet will be included.

skip: A list of row numbers to be ignored. If unspecified, then all rows in the range will be imported.

cache: Specifies for how long (in hours) to cache the results. Defaults to null (does not cache). TIP: Ignore cache and leave it null.

Output:

data: A datatable containing the imported data.

Example

Data-flo - Run: Adaptor Demo: Google spreadsheet - Data-flo

An example data-flo that can be copied

Possible use cases

• Maintaining a shared spreadsheet containing any standardized or frequently-updated mapping or list, to be imported and used as input to another adaptor's arguments.

• Hard-coding a shared spreadsheet as the datasource for a shared data-flo during data-flo development, rather than using a filesystem spreadsheet that requires user input.