> For the complete documentation index, see [llms.txt](https://docs.getmesa.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.getmesa.com/connect/google-sheets/update-row.md).

# Update Row

This action updates and existing Google Sheets row in your Spreadsheet. To get started, [Authenticate](/connect/google-sheets.md) and select an existing Spreadsheet and Sheet. Then click the Retrieve Fields button to retrieve the columns from your spreadsheet and you can configure the updated values for columns using Variables or text like the [Add Row step](/connect/google-sheets/add-row.md).

In addition to column values, you need to enter the row number that should be updated. In this example:

<figure><img src="/files/DfPxM6gm1GFSLeOvsWbM" alt="Screenshot of the MESA Google Sheets Update Row action configured with a spreadsheet, sheet, retrieved column values, and the row number to update. Spotlight the Row number field."><figcaption></figcaption></figure>

Entering Row 3 would replace the value of the first column in Row 3 of the spreadsheet:

<figure><img src="/files/jtNvhuRWBffekD13uRGR" alt="Screenshot of the Google Sheets spreadsheet showing the first column value in Row 3 that the Update Row action with Row 3 entered would replace. Spotlight the first column of Row 3."><figcaption></figcaption></figure>

## Getting the row number

If you have a Row Created or Query Rows step in your workflow that filters results MESA will not be able to return the row number associated with that record. In these instances, we recommend adding a column to the end of your spreadsheet with a header "Row" and the =ROW() formula for reach row in your spreadsheet.

<figure><img src="/files/r4usZnIfvW8dUcWV38Eo" alt="Screenshot of the Google Sheets spreadsheet with a column added at the end headed Row containing the =ROW() formula for each row. Spotlight the Row column with the =ROW() formula."><figcaption></figcaption></figure>

Then you can select the Variable for that column in the Update Row step.

<figure><img src="/files/aIjF8wObn9W4pZrZStOM" alt="Screenshot of the MESA Google Sheets Update Row step selecting the Variable for the Row column to supply the row number. Spotlight the Row Variable selection."><figcaption></figcaption></figure>

## Empty columns

MESA will not overwrite values for empty columns at the end of your spreadsheet. If you would only like a single value to be updated, we recommend moving that column to the beginning of your spreadsheet.