transformations:importgooglesheets
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
transformations:importgooglesheets [2021/03/12 22:13] – [Action settings] craigt | transformations:importgooglesheets [2021/03/28 14:28] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{ transformations: | {{ transformations: | ||
====== IMPORT | ====== IMPORT | ||
- | Category: Import / App/Cloud | + | Category: Import / App/Cloud\\ |
+ | \\ | ||
=====Description===== | =====Description===== | ||
Import data from a Google Sheets file.\\ | Import data from a Google Sheets file.\\ | ||
Line 10: | Line 11: | ||
^ Setting | ^ Setting | ||
- | |Connector | + | |Connector< |
- | |Spreadsheet | + | |Spreadsheet< |
- | |Sheet or range | Sheet or range to be imported. | + | |Sheet or range< |
- | |Skip first lines|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< |
|Columns don't have headers|Check this if your dataset does not include a row with header information| | |Columns don't have headers|Check this if your dataset does not include a row with header information| | ||
|Load all columns|This option imports all columns in the sheet.| | |Load all columns|This option imports all columns in the sheet.| | ||
|Load only selected columns|This option allows you to select which columns to import. | |Load only selected columns|This option allows you to select which columns to import. | ||
+ | < | ||
\\ | \\ | ||
- | =====Advanced | + | =====Advanced |
^Setting^Description^ | ^Setting^Description^ | ||
|Do not automatically offset imported range|By default, EasyMorph will align the first column and first row of imported data with column 1 and row 1\\ in the dataset. | |Do not automatically offset imported range|By default, EasyMorph will align the first column and first row of imported data with column 1 and row 1\\ in the dataset. | ||
|When a floating-point number can' | |When a floating-point number can' | ||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action: | ||
+ | * Press the "Add data" menu button. Pick "Fetch from cloud/ | ||
\\ | \\ |
transformations/importgooglesheets.txt · Last modified: 2023/04/20 19:51 by craigt