Google Sheets - Upload File to Sheet from Workflows

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 Blueprint is still subject to [Google's limitations](https://support.google.com/drive/answer/37603) which restrict the number of cells, number of columns, and number of characters per cell in a spreadsheet. **Note:** This Vessel cannot be used to upload a local file from your computer. **Recommended Setup:** 1. A Vessel built with this Blueprint should typically run after a Vessel 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	✅	None	-	Name or ID of the sheet to put data into.
Tab Name	SHEETS_TAB_NAME	Alphanumeric	➖	None	-	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	➖	None	-	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.
Workflows File Name	SHEETS_SOURCE_FILE_NAME	Alphanumeric	✅	None	-	Name of the target CSV file on Workflows to be uploaded to the sheet.
Workflows Folder Name	SHEETS_SOURCE_FOLDER_NAME	Alphanumeric	➖	None	-	Name of the local folder on Workflows to upload the target file from. If left blank, will look in the home directory.
Starting Cell	SHEETS_STARTING_CELL	Alphanumeric	➖	None	-	Cell to start at when uploading data. If left blank, will start at cell A1.

YAML

Below is the YAML template

YAML


source:
  template: Google Sheets - Upload File to Sheet from Workflows
  inputs:
    SHEETS_SPREADSHEET_ID:
    SHEETS_TAB_NAME:
    SHEETS_SHARED_DRIVE_NAME:
    SHEETS_SOURCE_FILE_NAME:
    SHEETS_SOURCE_FOLDER_NAME:
    SHEETS_STARTING_CELL:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 102
    - 200