Add Google Sheets Row

Add Google Sheets Row

Automate data entry and streamline your workflow by adding new rows to a Google Sheets worksheet with the specified column mapping values.

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:

  1. Google Sheets
  2. Worksheet (Tab)
  3. 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 that 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:


  1. Deleting existing rows or columns

  2. Adding rows anywhere other than at the bottom of the worksheet

  3. Changing the column sorting of the sheet

  4. Renaming, adding, or rearranging columns

  5. Renaming the workbook or the worksheet

Potential Failure

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

  1. Lack of editing permission for the chosen Google Sheets file.
  2. 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:

  1. Avoid updating the sheet tab name or the main worksheet name after setting up the step. Doing so will stop the 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:

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

    • Related Articles

    • Google Translate_ Integration

      "Enable Google Translate integration in Bevatel to instantly translate incoming messages, enabling seamless communication in various languages." How to translate messages with Google Translate? If you frequently receive queries in languages you/your ...

    • Add Teams

      "Efficiently organize your agents into teams based on roles and responsibilities, assigning conversations collaboratively." Add Teams Teams let you organize your agents into groups based on their responsibilities. A user can be part of multiple ...

    • Add Comment

      "This step allows you to add comments about the Conversation for internal reference or action, improving workflow tracking and documentation." This Step adds a note about the Conversation for internal reference or action. Configuration Write your ...

    • Add Labels

      "Simplify conversation management by creating and customizing labels with distinct colors to categorize and prioritize messages." Add Labels Labels help you categorize conversations and prioritize them. You can assign a label to a conversation from ...

    • Add Agents

      "Easily add and manage agents in your Customer Support team. Invite team members via 'Invite Team Member' or use Settings → Agents to add, edit, or remove agents." Add Agents An Agent is a member of your Customer Support team. Agents will be able to ...