Write cell values to Google Sheets.

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.