> 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/add-row.md).

# Add Row

Use the Google Sheets Add Row action in MESA to append a row, retrieve your spreadsheet columns, and map variables into each one.

The Add Row action creates a new row in an existing spreadsheet. To get started, [Authenticate](https://docs.getmesa.com/connect/google-sheets/) and select an existing Spreadsheet and Sheet. Then click the Retrieve Fields button to retrieve the columns from your spreadsheet.

<figure><img src="https://docs.getmesa.com/assets/image%20%28498%29.png" alt="Screenshot of the MESA Google Sheets Add Row action with an existing Spreadsheet and Sheet selected. Spotlight the Retrieve Fields button."><figcaption></figcaption></figure>

## Updating columns from spreadsheet

Once you click the Retrieve Fields button, MESA will automatically add a field for each column in your spreadsheet. We use the first row of your spreadsheet as the name for each field.

<figure><img src="https://docs.getmesa.com/assets/image%20%28375%29.png" alt="Screenshot of the MESA Google Sheets Add Row action after clicking Retrieve Fields, showing a field automatically added for each spreadsheet column named from the first row. Spotlight the retrieved column fields."><figcaption></figcaption></figure>

Be sure to click the Retrieve Fields button in MESA after you add, rename, or move columns in your Google Sheet.

## Configuring the columns added to Google Sheets

Once your columns appear in MESA, you can use [Variables](https://docs.getmesa.com/workflow-builder/fields/variables/) or text as the values for each column in the row that will be added. Variables let you pass data like Order, Product, or Customer information to the Google Sheet.

<figure><img src="https://docs.getmesa.com/assets/image%20%28499%29.png" alt="Screenshot of the MESA Google Sheets Add Row action with Variables or text entered as the values for each column of the new row. Spotlight the column value fields."><figcaption></figcaption></figure>
