Home/HighLevel/Features/Workflows/HighLevel workflow action to create and update multiple rows

Workflows and Automation

HighLevel workflow action to create and update multiple rows

In short

The Create & Update Multiple Rows action lets a HighLevel workflow add several new spreadsheet entries or modify existing ones in one step. It works with Google Sheets Premium, maps columns directly, and requires an array of row objects to run.

AreaWorkflows · Workflow Builder
Used forEcommerce store, Real estate agency, Event organizer
Setup steps25 steps in 2 tasks
Last updatedNovember 16, 2026

01Who this is for

  • Founders who need to log batch data from a single form submission, keeping records organized in one sheet.
  • Marketing teams that want to sync grouped campaign metrics to Google Sheets without manual copying.

02Create & update multiple rows in Google Sheets, explained

The action is part of the Google Sheets Premium workflow library. It can write many rows at once or edit a range of existing rows during a single automation run. When the workflow receives an array of objects, each object becomes a separate spreadsheet row. If only one record is present, only one row is added.

You locate the action inside any workflow under the Add Action menu. After selecting the Google Sheets option, you choose either Create Multiple Spreadsheet Row(s) or Update Multiple Spreadsheet Row(s). The action then asks for the Google account, drive, spreadsheet, worksheet, column range and, for updates, a starting row number.

All column headers must be in the first row of the sheet. The system treats that row as the header row and uses the names to map workflow data. You can refresh the header list at any time to capture changes made in the sheet.

03How businesses use create & update multiple rows in Google Sheets

  • Ecommerce store. When an order includes several items, the store’s workflow builds an array of product objects and passes it to the Create Multiple Spreadsheet Row(s) action. Each product appears as its own row in the sales log sheet.
  • Real estate agency. The agency’s workflow updates the status column for multiple property listings at once by selecting the Update Multiple Spreadsheet Row(s) action, entering the first row number, and defining the column range that contains status values.
  • Event organizer. After an event registration webhook delivers a JSON array of attendees, the organizer’s workflow maps that array to the Create Multiple Spreadsheet Row(s) action, automatically adding each attendee to a master attendance sheet.

04The numbers and rules that matter

  • This is a premium action and incurs additional charges per execution.

05Before you start

  • Connect your Google account in HighLevel.
  • Make sure the spreadsheet is stored in the correct Google Drive.
  • Add clear column headers in the first row of the worksheet.
  • Confirm the worksheet tab name before selecting it.
  • Enable Google Sheets premium workflow actions for the account if required.

06How to set up and use create & update multiple rows in Google Sheets in HighLevel

Create multiple rows in Google Sheets via workflow

  1. Open Automations and choose Workflows.
  2. Start a new workflow or edit an existing one.
  3. Add a trigger such as Contact Created or Form Submitted.
  4. Click the plus icon to insert a new action.
  5. Search for Google Sheets and select the Google Sheets action.
  6. Connect the location’s Google account.
  7. Pick Create Multiple Spreadsheet Row(s) from the action dropdown.
  8. Choose one of the displayed Google accounts for the subaccount.
  9. Select the Drive that holds the target spreadsheet.
  10. Choose the spreadsheet file and then the worksheet tab.
  11. If column headers have changed, click Refresh Headers to reload them.
  12. Set the Start column and End column for the data range and save the action.

Update multiple rows in Google Sheets via workflow

  1. Open Automations and choose Workflows.
  2. Start a new workflow or edit an existing one.
  3. Add a trigger such as Contact Created or Form Submitted.
  4. Click the plus icon to insert a new action.
  5. Search for Google Sheets and select the Google Sheets action.
  6. Connect the location’s Google account.
  7. Pick Update Multiple Spreadsheet Row(s) from the action dropdown.
  8. Choose one of the displayed Google accounts for the subaccount.
  9. Select the Drive that holds the target spreadsheet.
  10. Choose the spreadsheet file and then the worksheet tab.
  11. Enter the row number where the update should begin.
  12. Set the Start column and End column, and refresh headers if needed.
  13. Save the action.

07What it looks like in HighLevel

08Settings that matter

  • Start column. Defines the first column that will be included in the data mapping.
  • End column. Defines the last column that will be included in the data mapping.
  • Refresh Headers. Updates the list of column names inside the action after sheet changes.
  • Row number. Specifies the initial row index for the Update Multiple Spreadsheet Row(s) action.

09Things to know before you rely on it

  • The action is premium and adds extra charges per execution.
  • Rows are created only when the workflow run already contains an array of row objects.
  • Workflows do not automatically batch contacts that enter at different times.
  • Headers must exist in the first sheet row; missing headers cause mapping errors.
  • Choosing the wrong worksheet tab can cause data to be written to an unintended location.

10If something goes wrong

  • New column does not appear in the action mapping list. Click Refresh Headers after adding or renaming the column in the sheet.

11How it connects to the rest of HighLevel

Michael's take

Michael Reimer
Michael ReimerFounder of CRM Pros, HighLevel Commander and Certified Admin

People often think they can drop a list of contacts into the action and HighLevel will gather them over time. It doesn’t. The workflow must already contain an array of row objects before the action runs.

If I were setting this up, I would build the array in a preceding webhook step, refresh the sheet headers, and then map the fields. That way the bulk write happens in one clean pass.

Get More InformationOpens on HighLevelPublished November 2, 2026 · Updated November 16, 2026

Common questions

Common questions about create & update multiple rows in Google Sheets.

What is the difference between Create Multiple Spreadsheet Row(s) and Update Multiple Spreadsheet Row(s)?

Create Multiple adds new rows to the sheet, while Update Multiple changes values in rows that already exist.

Can the action write many rows when only one contact runs the workflow?

It writes one row if the workflow run provides data for a single record; multiple rows require an array of objects.

Does the action automatically batch contacts that enter the workflow at different times?

No. Each workflow execution must already contain the full array of rows to write.

Do I need column headers in my Google Sheet?

Yes. Headers let HighLevel match workflow fields to spreadsheet columns.

Why should I refresh headers?

Refreshing pulls the latest column names after you add, rename, or reorder headers in the sheet.

Can I limit which columns are used in the action?

Yes. The Starting Column and Ending Column fields set the column range that will be available for mapping.

Next step

Pick the features that matter. Then get the plan that unlocks them.

Explore the features you want, start with the five at the top, and upgrade through my link when you are ready. The bonuses and the team come with it.

The features directory explains every HighLevel feature in plain English. Browse it to see what the platform can do.

Back to the FeaturesSee the full details
⌃

Site preview

Explore the next page

This destination is reserved in the page inventory and is not built yet.