Google Sheets - Upload File to Sheet from Platform
Overview
Easily import data from a single CSV into a single Google Sheet tab. The Google Sheet must already exist for the data to be uploaded.
Only one CSV file can be uploaded at a time, since the upload process requires a static starting cell to determine where to place the data. If you leave the starting cell blank, data will be inserted starting at cell A1 and expanding in width and depth as needed.
If you leave the tab name blank, the data will be uploaded into the first tab. If you specify a Tab Name that doesn't exist, it will be created.
This Template is still subject to Google's limitations which restrict the number of cells, number of columns, and number of characters per cell in a spreadsheet.
Note: This Task cannot be used to upload a local file from your computer.
Recommended Setup:
A task built with this template should typically run after a template that either downloads a file to Workflows or generates a file with code.
Variables
Name | Reference | Type | Required | Default | Options | Description |
|---|---|---|---|---|---|---|
Google Spreadsheet Name or ID | SHEETS_SPREADSHEET_ID | Alphanumeric | ✅ | - | - | Name or ID of the sheet to put data into. |
Tab Name | SHEETS_TAB_NAME | Alphanumeric | ➖ | - | - | Name of the tab in the sheet to upload data to. This field is case sensitive. If left blank, data will be put into 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. |
Workflow File Name | SHEETS_SOURCE_FILE_NAME | Alphanumeric | ✅ | - | - | Name of the target CSV file on Platform to be uploaded to the sheet. |
Workflow Folder Name | SHEETS_SOURCE_FOLDER_NAME | Alphanumeric | ➖ | - | - | Name of the local folder on Platform to upload the target file from. If left blank, will look in the home directory. |
Starting Cell | SHEETS_STARTING_CELL | Alphanumeric | ➖ | - | - | Cell to start at when uploading data. If left blank, will start at cell A1. |
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 - Upload File to Sheet from Shipyard
inputs:
SHEETS_SPREADSHEET_ID: null ## REQUIRED
SHEETS_TAB_NAME: null
SHEETS_SHARED_DRIVE_NAME: null
SHEETS_SOURCE_FILE_NAME: null ## REQUIRED
SHEETS_SOURCE_FOLDER_NAME: null
SHEETS_STARTING_CELL: 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'