import-from-google-sheet

Description

import-from-google-sheet adaptor imports data from a Google Sheets spreadsheet.

Private spreadsheets should be shared with [e-mail], and given Editor permission.

Inputs

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

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

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

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

Outputs

data Type: datatable A datatable containing the imported data.

Examples

Example 1: Default behaviour.

Inputs:

url: https://docs.google.com/spreadsheets/d/12345/edit?usp=sharing

sheet name: null (empty)

range: null (empty)

skip: null (empty)

Outputs:

data:

id	latitude	longitude
Sample A	4.642276772	-8.17536836
Sample B	5.063345736	-9.051186684
Sample C	5.063345736	-9.051186684
Sample D	4.638091468	-8.17536836

-> Imported the entire Google Sheet into Data-flo.

Example 2: Import data from Google Sheet within a specified range.

Inputs:

url: https://docs.google.com/spreadsheets/d/12345/edit?usp=sharing

sheet name: null (empty)

range: A1:C4

skip: null (empty)

Outputs:

data:

id	latitude	longitude
Sample A	4.642276772	-8.17536836
Sample B	5.063345736	-9.051186684
Sample C	5.063345736	-9.051186684

-> Imported the Google Sheet within the range A1:C4.

Example 3: Import data from Google Sheet, skipping specific rows.

Inputs:

file: https://docs.google.com/spreadsheets/d/12345/edit?usp=sharing

sheet name: null (empty)

range: null (empty)

skip:

1. 2

2. 4

Outputs:

data:

id	latitude	longitude
Sample A	4.642276772	-8.17536836
Sample C	5.063345736	-9.051186684

-> Imported the Google Sheet and skipped rows 2 and 4.