Skip to main content

Google Sheet line writer

Generate a google sheet file on which you can append rows at the given sheet.

Rows are objects keyed by column letter (A, B, C…). Gaps between the lettered columns are padded with empty cells: a row with only B and D set is written as "" | B-value | "" | D-value.

Example
# Configuration:
Sheet: SHEET_1
Headers: A -> Name | B -> Weight

# Data input:
Gsheet row 1: A -> Apple | B -> 30gr
Gsheet row 2: A -> Ham   | B -> 12kg

# Output:

  | A      | B      |
  |-----------------|
1 | Name   | Weight |
2 | Apple  | 30gr   |
3 | Ham    | 12kg   |
  |-----------------|
  | SHEET_1 |

Parameters​

Sheetnamerequired
The name of the Google sheet to write.
Headers

The headers to write in the Google sheet. The headers are written in the first row. (For example: A -> Name | B -> Weight)

Input​

Gsheet rowrequired

All the rows to add to the document. The connector accepts Excel Row values and Excel-cell-at-column values only (unlike the CSV and Excel writers, it does not accept Excel Cells values). Each incoming value must be a row object keyed by column letter; anything else fails the run.