This article explains how to write new rows, update existing rows, and delete rows in a connected Google Sheet from within a HappyFox Workflow. For looking up existing row data, see how to look up row data in a workflow.
Validation note legend
| Term | Meaning |
|---|---|
| Required | The workflow will fail to run if this field is blank or missing. |
| Optional | The field can be left blank; the action will still run. |
| Text | A plain text value. Can include dynamic workflow variables. |
| Selection (pick one) | A searchable dropdown where you choose exactly one option from a list populated from your Google account. |
| List (multiple entries) | A repeatable block where you add one or more sub-items. |
Actions
Create a Row with Provided Values
Appends a new row to the end of the specified worksheet and writes the values you specify into the named columns. Any columns in the sheet that you don't include are left blank in the new row. Returns the row number of the newly created row.
| Field | Description | Validation |
|---|---|---|
| Account | The Google account (identified by email address) to authenticate with when accessing the spreadsheet. Must already be linked in the Google Sheets integration settings. | Required · Selection (pick one) |
| Spreadsheet | The Google Sheets file to write to. Populated from the Google Drive files accessible to the selected account. | Required · Selection (pick one) |
| Worksheet | The sheet tab within the spreadsheet to write to. Defaults to Sheet1 if a worksheet by the given name is not found. |
Required · Text |
| Column Values | The list of column/value pairs to write into the new row. Each row includes Column Name (must match the header text in row 1 exactly) and Column Value (the value to place in that column). At least one pair must be added. | Required · List (multiple entries) |
Note: All listed column names must exist in the worksheet's header row. If any column is missing, the action fails without creating a row.
Update a Row with Provided Values
Overwrites specific cells in an existing row, identified by its row number, with the values you provide. Any columns you don't list are left completely unchanged. Returns the updated row number.
| Field | Description | Validation |
|---|---|---|
| Account | The Google account (identified by email address) to authenticate with when accessing the spreadsheet. Must already be linked in the Google Sheets integration settings. | Required · Selection (pick one) |
| Spreadsheet | The Google Sheets file to update. Populated from the Google Drive files accessible to the selected account. | Required · Selection (pick one) |
| Worksheet | The sheet tab within the spreadsheet to update. Defaults to Sheet1 if a worksheet by the given name is not found. |
Required · Text |
| Row Number | The row number of the row to update. Row 1 is the header row, so data rows start at 2. Typically populated from the output of a preceding lookup action. | Required · Text (numeric value) |
| Column Values | The list of column/value pairs to write into the existing row. Each row includes Column Name (must match the header text in row 1 exactly) and Column Value (the new value to write into that column). At least one pair must be added. | Required · List (multiple entries) |
Note: All listed column names must exist in the worksheet's header row. If any column is missing, the action fails without writing anything.
Delete a Row
Permanently removes the row at the specified row number from the worksheet, shifting all rows below it up by one. Returns a simple success confirmation.
| Field | Description | Validation |
|---|---|---|
| Account | The Google account (identified by email address) to authenticate with when accessing the spreadsheet. Must already be linked in the Google Sheets integration settings. | Required · Selection (pick one) |
| Spreadsheet | The Google Sheets file to delete a row from. Populated from the Google Drive files accessible to the selected account. | Required · Selection (pick one) |
| Worksheet | The sheet tab within the spreadsheet to delete from. Defaults to Sheet1 if a worksheet by the given name is not found. |
Required · Text |
| Row Number | The row number of the row to delete. Row 1 is the header row, so data rows start at 2. Typically populated from the output of a preceding lookup action. | Required · Text (numeric value) |
Warning: Deleting a row cannot be undone. Once the workflow runs this action, the row and its data are permanently removed from the spreadsheet.
Your workflow can now create, update, and delete rows in Google Sheets.