Definition and Usage
This command writes data to a specified column in a Google Sheets document. It allows you to add or update values in a selected Google Sheet by specifying the target column and the values to write.
Parameter Values
Input parameters
Parameter | Description | Required | Options / Notes |
Google Sheet | Select the Google sheet to read | Yes | Must be a previously connected Google Sheet |
Column | Specify the column using either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) | Yes | Can use column letters (A, B, C) or numbers (1, 2, 3) |
Value to write | The data to be written to the specified column | Yes | Can specify both row numbers and content to write |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
This command supports the use of variables in its parameters. You can insert variables by clicking the {x} icon next to input fields. This allows you to dynamically specify:
Which Google Sheet to use
Which column to write to
What values to write
Variables can be particularly useful when you need to write dynamic data collected from previous steps in your workflow.
Notes
Before using this command, ensure that you have already established a connection to a Google Sheet.
The column can be specified using either alphabetical notation (A, B, C) or numerical indexes (1, 2, 3).
You can add multiple values to write by clicking the "+ Click to add" button.
For the "Value to write" parameter, you need to specify both the row number and the content to write.
Make sure you have appropriate write permissions for the Google Sheet you are attempting to modify.