Google Sheets - Download Sheet to Platform
Overviewβ
Quickly export data from a single tab on a Google Sheet to a CSV.
Only one tab of data can be downloaded at a time, since CSVs are flat files. If you leave the tab name blank, the first tab of data will be pulled.
Content of the downloaded file can be refined by providing a cell range. Otherwise, the entire contents of the tab will be downloaded.
Variablesβ
Name | Reference | Type | Required | Default | Options | Description |
---|---|---|---|---|---|---|
Google Spreadsheet Name or ID | SHEETS_SPREADSHEET_ID | Alphanumeric | β | - | - | Name or ID of the sheet to fetch data from. |
Tab Name | SHEETS_TAB_NAME | Alphanumeric | β | - | - | Name of the tab in the sheet to fetch data from. This field is case sensitive. If left blank, data will be pulled from the first tab. |
Shared Drive Name | SHEETS_SHARED_DRIVE_NAME | Alphanumeric | β | - | - | Name of the Shared Drive the sheet exists in. This field is case sensitive. Leave blank if the file does not exist in a Shared Drive. |
Shipyard File Name | SHEETS_DESTINATION_FILE_NAME | Alphanumeric | β | - | - | Name of file to be generated with the results. Should be .csv extension. |
Shipyard Folder Name | SHEETS_DESTINATION_FOLDER_NAME | Alphanumeric | β | - | - | Folder where the file should be downloaded. Leaving blank will place the file in the home directory. |
Cell Range | SHEETS_CELL_RANGE | Alphanumeric | β | - | - | Range to fetch data from in the sheet formatted as A1:B10 . If left blank the entire contents of the tab will be fetched. |
Service Account | GOOGLE_APPLICATION_CREDENTIALS | Password | β | - | - | JSON from a Google Cloud Service account key. |
YAMLβ
Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.
source:
blueprint: Google Sheets - Download Sheet to Shipyard
inputs:
SHEETS_SPREADSHEET_ID: null ## REQUIRED
SHEETS_TAB_NAME: null
SHEETS_SHARED_DRIVE_NAME: null
SHEETS_DESTINATION_FILE_NAME: null ## REQUIRED
SHEETS_DESTINATION_FOLDER_NAME: null
SHEETS_CELL_RANGE: null
GOOGLE_APPLICATION_CREDENTIALS: null ## REQUIRED
type: BLUEPRINT
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- '101'
- '102'
- '200'