Google Workspace

Download 50
Last updated Sep 9, 2023

google-workspace-sheets-write-values

Write cell values to Google Sheets.

google-workspace-sheets-write-values [profile=PROFILE] sheet-id=SHEET-ID sheet-name=SHEET-NAME key-column=KEY-COLUMN fields=FIELDS
profile=PROFILE
Profile name of Google Workspace
sheet-id=SHEET-ID
Google Sheets ID
sheet-name=SHEET-NAME
Sheet name
key-column=KEY-COLUMN
Key column. e.g. A
fields=FIELDS
Comma-separated field names to be entered on the sheet. Key fields are prefixed with +.

This command works in the following order:

  1. Get the value of the key field specified by the fields option from the input record.
  2. Find the value of the key field from the sheet column specified by the key-column option.
  • If the key field does not exist, it is added to the last line of the sheet.
  • If the key field exists, overwrites the line with the value of the field specified by the fields option.

Output Fields

This command outputs the input record as is.