Is this article helpful?

We love to hear from you!

Table of Contents

Step: Add Google Sheets Row

Shing-Yi Tan Updated by Shing-Yi Tan

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

This step is only available for Business Plan and above.

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.

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 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.

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.

Feeling stuck? Do not fear.

Need assistance? Contact us for support. Help is here!

Step: HTTP Request

Can't find what you're looking for?

Talk to an expert here!

Contact Us
© 2023 Respond.io.
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)