---
description: Learn about the configuration, best practices and use cases for implementing the Add Google Sheets Row Step.
title: Step: Add Google Sheets Row
image: https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F3f43c48b21b24f4e8b02b100c0c8fab0
---

[New🌍 WhatsApp API Calling is now available globally! Start making calls with respond.io today. Learn more![arrow-icon](https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2Fe43213a7a9314673bd8d2060c25f9b87)](/whatsapp-business-calling-api)

Help me with... ⌘ 

1. [All Collections >](/help)
2. [ Product >](/help/product)
3. [ Workflows >](/help/workflows)
4. Step: Add Google Sheets Row

# Step: Add Google Sheets Row

![Avatar](https://assets2-proxy.respond.io/ph8r57dk1q9w/2Y6LIr15mC1nj8MgftMVT5/6ffeea71593277f0fc29dafd1c1de9b9/Serene_Avatar.svg)

Shing-Yi Tan

· 24 Sept 2025

2 min read

This Step adds new rows to a Google Sheets worksheet using the specified column mapping values. 

> This step is only available for Growth Plan and above.

![](https://assets2-proxy.respond.io/ph8r57dk1q9w/6by6rwRSQTVXDzVScjGoWH/8a3c62c15586f280325d0f8c2124f37e/image.png?fm=jpg&q=80&w=640) 

## Configuration

There are three key configurations for adding a new row to Google Sheets:

* **Google Sheets**
* **Worksheet (Tab)**
* **Column Mapping**

Select the Google Sheets file you want to populate.

> Make sure you have editing access to the worksheet you are trying to connect to.

Once you've chosen the desired Google Sheets file, select the worksheet or tab you want to populate.

> Ensure that the sheet name doesn't contain punctuation and the first row of the worksheet is a header row with filled-in column names. If Column A's first row has a missing value, data will be inserted at the top of the sheet, not at the bottom.

After determining the worksheet or tab, open the Column Mapping configuration drawer. You can configure up to 26 columns (Column A to Column Z).

Fill in the column fields with the desired data. To include Variables, use the "$" prefix to support the interpolation of static text and Variables. You can also use system variables as the Column Mapping value to timestamp when new Google Sheet Rows are added, helping you track events.

For Google Sheets calculations, add the formula in the relevant field to automatically calculate and display the value when a new row is added to the worksheet.

If you want to leave a column blank in the sheet, leave its field in the configuration drawer empty.

> To update the worksheet and column mapping fields, click on the refresh button in the configuration drawer.

## How It Works

When the Workflow is triggered, the values specified in the column mapping field will be added to the Google Sheets worksheet, creating a new row at the bottom of the table to display the data.

![](https://assets2-proxy.respond.io/ph8r57dk1q9w/EgqmsJXrVGgqnSGiMTU3m/35dab62f10bcb085a1cf48d22cb0a924/image.png?fm=jpg&q=80&w=640) 

When editing a worksheet, first stop the Workflow. Then, update the column fields in the Step configuration drawer before republishing the Workflow to reflect the changes. Failing to do so may result in a data mismatch between the Workflow input and the new rows in the worksheet.

Editing a worksheet involves the following actions:

* Deleting existing rows or columns
* Adding rows anywhere other than at the bottom of the worksheet
* Changing the column sorting of the sheet
* Renaming, adding, or rearranging columns
* Renaming the workbook or the worksheet

## Potential Failure

The Add Google Sheets Row Step can encounter two potential failures:

* Lack of editing permission for the chosen Google Sheets file.
* The selected worksheet has reached its cell limit or is already full.
* In some cases, data may fail to pass to Google Sheets due to exceeding Google’s API quota. This is more likely when handling large volumes of data in bulk. If the quota is exceeded, new rows will not be added.

In such cases, the contact will bypass this Step and continue with the rest of the Workflow's journey.

## Best Practices

Here’s a best practice for this step you can follow to optimize your workflow:

* **Avoid updating the sheet tab name or the main worksheet name** after setting up the step. Doing so will stop data population in the sheet and necessitate reconfiguring the step.
* **Define the required headers** in the Google Sheets first before setting up the Workflow step.
* **Avoid using checkboxes, dropdowns, or other pre-filled formatting in empty rows**, as these are treated as values. This may cause data to populate in unexpected rows. Use a clean sheet or dedicate a section without such formatting for more predictable behavior.
* When sending large volumes of data, consider batching or spreading out requests to avoid exceeding Google’s API quota limits.

## Suggested Use Cases

Here are some ways you can use the Add Google Sheets Row Step:

* **Save time with automated data entry**: Reduce manual efforts by adding data automatically to Google Sheets. Connect a Google Sheet to create a new row with variables added to specific columns.

Share this article

[![Telegram](https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F44daca77a4844f0c8fd29040ddeba057?width=22)](https://api.whatsapp.com/send?text=https://respond.io/help/workflows/step-add-google-sheets-row)[![Facebook](https://assets1-proxy.respond.io/api/v1/image/assets/11f7a662b80a4675973850b067c01fa5/fff57eeb01160bc604392f519b4f3461ca16f0fa1b6a587b20b142cdf1ad0ba7?placeholderIfAbsent=true&width=22)](https://www.facebook.com/sharer/sharer.php?u=https://respond.io/help/workflows/step-add-google-sheets-row)[![Linkedin](https://assets1-proxy.respond.io/api/v1/image/assets/11f7a662b80a4675973850b067c01fa5/7aaf8d87b5410844d83e06a4ed663e4f551b8c5ef51dbb20a8ff064a1eed9a0f?placeholderIfAbsent=true&width=22)](https://www.linkedin.com/sharing/share-offsite/?url=https://respond.io/help/workflows/step-add-google-sheets-row)[![Twitter](https://assets1-proxy.respond.io/api/v1/image/assets%2F11f7a662b80a4675973850b067c01fa5%2F4e03e02422a94e8eab9b8b41457c2371?width=22)](http://twitter.com/share?url=https://respond.io/help/workflows/step-add-google-sheets-row)

## 

Related articles 👩‍💻

* [Step: Update LifecycleLearn about best practices, use cases and how it works when implementing the Update Lifecycle Step. ](/help/workflows/step-update-lifecycle)
* [Step: Send Conversions API EventLearn about the configuration, how it works, best practices and more when implementing the Send Conversions API Event step. ](/help/workflows/step-send-conversions-api-event)
* [How to Avoid Workflow LoopsLearn how to prevent workflow loops that cause unnecessary repetitions, system overload, and delays. ](/help/workflows/how-to-avoid-workflow-loops)
* [Step: Send TikTok Lower Funnel EventLearn about the best practices, use cases and how it works when implementing the Send TikTok Lower Funnel Event Step. ](/help/workflows/step-send-tiktok-lower-funnel-event)
* [Step: HTTP RequestLearn about the configuration, best practices and use cases for implementing the HTTP Request Step. ](/help/workflows/step-http-request)

Can't find what you're looking for? 🔎

[Contact Support](/contact-us)

2025-12-05T03:58:32.818Z

help

```json
[{"@context":"https://schema.org","@type":"TechArticle","articleBody":"Learn about the configuration, best practices and use cases for implementing the Add Google Sheets Row Step.","author":{"@type":"Person","image":"https://assets2-proxy.respond.io/ph8r57dk1q9w/2Y6LIr15mC1nj8MgftMVT5/6ffeea71593277f0fc29dafd1c1de9b9/Serene_Avatar.svg","name":"Shing-Yi Tan","url":"https://respond.io/author"},"dateCreated":"2024-08-15T09:46:43.000Z","dateModified":"2025-09-24T09:20:53.757Z","datePublished":"2024-08-15T09:46:43.000Z","headline":"Step: Add Google Sheets Row","image":"https://assets2-proxy.respond.io/ph8r57dk1q9w/6by6rwRSQTVXDzVScjGoWH/8a3c62c15586f280325d0f8c2124f37e/image.png","mainEntityOfPage":"https://respond.io/help/workflows","publisher":{"@type":"Organization","logo":"https://respond.io/favicon/favicon.svg","name":"respondio"},"thumbnailUrl":"https://assets2-proxy.respond.io/ph8r57dk1q9w/6by6rwRSQTVXDzVScjGoWH/8a3c62c15586f280325d0f8c2124f37e/image.png","url":"https://respond.io/help/workflows/step-add-google-sheets-row"},{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Help","item":"https://respond.io/help","position":1},{"@type":"ListItem","name":"Product","item":"https://respond.io/help/product","position":2},{"@type":"ListItem","name":"Workflows","item":"https://respond.io/help/workflows","position":3},{"@type":"ListItem","name":"Step: Add Google Sheets Row","item":"https://respond.io/help/workflows/step-add-google-sheets-row","position":4}]}]
```
