Skip to main content
Skip table of contents

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

NameReferenceTypeRequiredDefaultOptionsDescription
Google Spreadsheet Name or IDSHEETS_SPREADSHEET_IDAlphanumericNone-Name or ID of the sheet to put data into.
Tab NameSHEETS_TAB_NAMEAlphanumericNone-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 NameSHEETS_SHARED_DRIVE_NAMEAlphanumericNone-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 NameSHEETS_SOURCE_FILE_NAMEAlphanumericNone-Name of the target CSV file on Workflows to be uploaded to the sheet.
Workflows Folder NameSHEETS_SOURCE_FOLDER_NAMEAlphanumericNone-Name of the local folder on Workflows to upload the target file from. If left blank, will look in the home directory.
Starting CellSHEETS_STARTING_CELLAlphanumericNone-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

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.