Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |
transformations:importgooglesheets [2021/03/28 14:28] – craigt | transformations:importgooglesheets [2023/04/20 19:51] (current) – Add Import action | List sheets setting craigt |
---|
|Connector<sup>*</sup>| A configured connector to Google Drive. See [[connectors:googledrive|Google Drive connector]]. | | |Connector<sup>*</sup>| A configured connector to Google Drive. See [[connectors:googledrive|Google Drive connector]]. | |
|Spreadsheet<sup>*</sup>| The path to the source Google Sheet document. This is set after the //Connector// is created. | | |Spreadsheet<sup>*</sup>| The path to the source Google Sheet document. This is set after the //Connector// is created. | |
| |Import action|Options: //Import table// (retrieve data from a sheet, see details below) or //List sheets// (produce a list of sheet names within the Sheets file).| |
| |
| \\ |
| ==== Import table settings ==== |
| ^ Setting ^ Description ^ |
|Sheet or range<sup>*</sup>| Sheet or range to be imported. This list will be populated once the //Connector// is set and the //Spreadsheet// is selected. | | |Sheet or range<sup>*</sup>| Sheet or range to be imported. This list will be populated once the //Connector// is set and the //Spreadsheet// is selected. | |
|Skip first lines<sup>*</sup>|The number of rows to skip before reading in your data. If your data does not start on the first row\\ (i.e., leading rows with metadata, blank rows), use this setting to skip these rows.| | |Skip first lines<sup>*</sup>|The number of rows to skip before reading in your data. If your data does not start on the first row\\ (i.e., leading rows with metadata, blank rows), use this setting to skip these rows.| |