Skip to main content

Google Sheets: Update Specific Spreadsheet Row (Premium Action)

The Update Specific Spreadsheet Row premium action updates values in a single Google Sheets row by targeting an exact row number and column range.

Updated over 2 months ago

Who This Is For / When to Use

Use this action when a workflow needs to modify existing data in Google Sheets and you already know the exact row number to update (static or dynamic).

What This Action Does

This action connects Kyrios workflows to Google Sheets and updates one specific row by:

  • Selecting a worksheet

  • Providing a row number

  • Defining which columns should be updated

  • Writing new values into those columns

This is a premium action. Each execution may incur additional charges.

Required Setup Steps

1. Select the Google Sheets Action

Choose Update Specific Spreadsheet Row from the Google Sheets premium actions list.

2. Choose the Worksheet

Select the worksheet (tab) inside your spreadsheet where the row exists.

  • The worksheet name is used as a permanent reference.

  • Once selected, it cannot be changed for this action.

3. Enter the Row Number

Specify the exact row number you want to update.

  • You can enter a static number (e.g., 12)

  • Or use a dynamic value from the Custom Variable Picker

Example dynamic value:

4. Refresh Headers

Click Refresh Headers to load column headers from the selected worksheet.

This step is required before mapping column values.

5. Select Starting and Ending Columns

Define the column range that should be updated.

  • To update one column, select the same column for both Starting Column and Ending Column

  • To update multiple adjacent columns, select the first and last columns in the range

  • Leave columns blank if you do not want them updated

6. Map Column Values

Enter the values you want written into the selected columns.

  • Values can be static text

  • Or dynamic values from contacts, workflows, or custom values

7. Save the Action

Click Save Action to store the configuration.

The workflow will now update the specified row whenever this step runs.

Common Issues and Fixes

The row does not update

  • Confirm the row number exists in the worksheet

  • Ensure headers were refreshed after selecting the worksheet

Data is written to the wrong column

  • Recheck the Starting Column and Ending Column selections

  • Make sure column headers match the actual sheet structure

Nothing happens when the workflow runs

  • If the row number is dynamic, confirm the variable resolves to a valid number

  • If the row number is empty or invalid, the step is skipped

Frequently Asked Questions

How do I choose which worksheet to update?
Select the worksheet from the Worksheet dropdown during action setup.

Can I use dynamic values for the row number?
Yes. Use the Custom Variable Picker to insert a dynamic value from a previous workflow step or contact field.

Can I update only one column in a row?
Yes. Select the same column for both Starting Column and Ending Column.

What happens if the row number does not exist?
The workflow skips this action and continues to the next step.

Does the Google Sheet need to be open?
No. Kyrios connects to Google Sheets via the cloud. The file does not need to be open.

Did this answer your question?