# Workflow Action - Create & Update Multiple Rows in Google Sheets > This guide shows how to create and update multiple rows in Google Sheets using workflow actions in GHL Customer Care, with easy setup steps, mapping tips, and FAQs. - Source: https://docs.ghlcustomercare.com/docs/workflows/workflow-builder/workflow-action-create-update-multiple-rows-in-google-sheets - Section: Workflows / Workflow Builder - Reading time: 8 min - Images: 18, each explained below --- Workflow Action - Create & Update Multiple Rows in Google Sheets helps you create new spreadsheet entries or update existing ones in bulk within a single GHL Customer Care workflow. This article covers what the feature does, when to use each action type, and how to set it up correctly in Google Sheets. --- **TABLE OF CONTENTS** - [What is Workflow Action - Create & Update Multiple Rows in Google Sheets?](#what-is-workflow-action-create-and-update-multiple-rows-in-google-sheets) [](#key-benefits-of-create-and-update-multiple-rows-in-google-sheets-action) - [Key Benefits of Create & Update Multiple Rows in Google Sheets Action](#key-benefits-of-create-and-update-multiple-rows-in-google-sheets-action)[](#prerequisites) - [Prerequisites](#prerequisites)[](#how-to-use-the-action-to-create-multiple-row-s-in-google-sheets) - [How to Use the Action to Create Multiple Row(s) in Google Sheets](#how-to-use-the-action-to-create-multiple-row-s-in-google-sheets)[](#how-create-multiple-spreadsheet-row-s-works) - [How Create Multiple Spreadsheet Row(s) Works](#how-create-multiple-spreadsheet-row-s-works)[](#how-to-pass-multiple-rows-into-the-action) - [How to Pass Multiple Rows into the Action](#how-to-pass-multiple-rows-into-the-action)[](#best-use-cases) - [Best use cases](#best-use-cases)[](#how-to-use-the-action-to-update-multiple-row-s-in-google-sheets) - [How to Use the Action to Update Multiple Row(s) in Google Sheets](#how-to-use-the-action-to-update-multiple-row-s-in-google-sheets)[](#when-to-use-this-option) - [When to use this option](#when-to-use-this-option)[](#frequently-asked-questions) - [Frequently Asked Questions](#frequently-asked-questions)[](#related-articles) - [Related Articles](#related-articles) --- # **What is Workflow Action - Create & Update Multiple Rows in Google Sheets?**  **Note:** This is a **premium** **action**. Using this action will **incur** **additional** **charges** **per** **execution**. Workflow Action - Create & Update Multiple Rows in Google Sheets allows GHL Customer Care workflows to create or update more than one spreadsheet row during a single automation flow. This makes it easier to work with repeated or grouped data, especially when you need to log multiple entries, sync structured records, or update several spreadsheet values at once. This functionality is part of the Google Sheets Premium Workflow Action and expands what you can do beyond a single-row action. Instead of sending data one row at a time, you can configure your workflow to write or modify multiple rows more efficiently while keeping your spreadsheet organized. --- ## **Key Benefits of Create & Update Multiple Rows in Google Sheets** **Action** - **Faster data logging**: Create multiple spreadsheet rows in one workflow action instead of repeating the same setup several times. - **Better organization**: Keep related records together in Google Sheets when workflows generate grouped or repeated data. - **Less manual work**: Reduce the need to add or edit rows by hand after a workflow runs. - **Improved accuracy**: Map spreadsheet columns directly to workflow data to lower the risk of copy-and-paste errors. - **More flexible updates**: Update several row values in a defined spreadsheet range when records need to be changed. --- ## **Prerequisites** A successful setup depends on having the spreadsheet and workflow prepared before mapping any fields. Taking a moment to confirm permissions, headers, and sheet structure can prevent broken mappings, incorrect updates, or missing data later. - Make sure your Google account is connected in GHL Customer Care. - Confirm that the spreadsheet is stored in the correct Google Drive. - Add clear column headers in the first row of the worksheet. - Review the worksheet tab name before selecting it in the action. - Make sure Google Sheets premium workflow actions are enabled for the account if required. - Refresh headers in the action whenever columns are added, renamed, or reordered. --- ## **How to Use the Action to Create Multiple Row(s) in Google Sheets** Create Multiple Spreadsheet Row(s) is best when your workflow needs to add new entries to Google Sheets rather than change rows that already exist. This is useful for writing repeated records, storing grouped data, or sending multiple values into a spreadsheet during one workflow execution. 1. Go to **Automations** > **Workflows**. ![Step 1 of 14: Go to Automations > Workflows](https://jumpshare.com/share/0JWEsWQU9NawnWRXArkh+/Screen+Shot+2026-04-06+at+21.20.01.png) **Step 1 of 14: Go to Automations > Workflows** This screenshot accompanies step 1 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you go to Automations > Workflows. For context, this section explains: Create Multiple Spreadsheet Row(s) is best when your workflow needs to add new entries to Google Sheets rather than change rows that already exist. This is useful for writing repeated records, storing grouped data, or sending multiple values into a spreadsheet during one workflow execution. The navigation path used here is Automations > Workflows. The next step is to create a new workflow or edit an existing one. - Path: Automations > Workflows - Where to go: Go to Automations > Workflows. - Controls: Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets, click - Next: Create a new workflow or edit an existing one. Full procedure: 1. Go to Automations > Workflows. <- this image 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 2. Create a **new** **workflow** or **edit** an **existing** one. ![Step 2 of 14: Create a new workflow or edit an existing one](https://jumpshare.com/share/BXEsCvFYK7i5WsZpbUNj+/Screen+Shot+2026-04-06+at+21.21.45.png) **Step 2 of 14: Create a new workflow or edit an existing one** This screenshot accompanies step 2 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you create a new workflow or edit an existing one. The navigation path used here is Automations > Workflows. The next step is to add a relevant trigger like Contact Created, Form Submitted, etc. - Path: Automations > Workflows - What this covers: Create a new workflow or edit an existing one. - Controls: new, workflow, edit, existing, Automations, Workflows, Add, trigger, +, Google, Sheets, click - Next: Add a relevant trigger like Contact Created, Form Submitted, etc. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. <- this image 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 3. **Add** a relevant **trigger** like Contact Created, Form Submitted, etc. ![Step 3 of 14: Add a relevant trigger like Contact Created, Form Submitted, etc](https://jumpshare.com/share/u1UFwknt8WsBsvkvjHaE+/GIF+Recording+2026-04-08+at+20.15.07.gif) **Step 3 of 14: Add a relevant trigger like Contact Created, Form Submitted, etc** This animation accompanies step 3 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you add a relevant trigger like Contact Created, Form Submitted, etc. The navigation path used here is Automations > Workflows. The next step is to click on the + button to add an Action. - Path: Automations > Workflows - What this covers: Add a relevant trigger like Contact Created, Form Submitted, etc. - Controls: Add, trigger, Automations, Workflows, new, workflow, edit, existing, +, Google, Sheets, click - Next: Click on the + button to add an Action. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. <- this image 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 4. Click on the **+** button to add an Action. 5. Search for **Google** **Sheets** action and **click** **on it to select the action**. 6. **Connect** your **location's** Google Account. ![Step 6 of 14: Connect your location's Google Account](https://jumpshare.com/share/FZLxmIbexGB6cmaB4lRS+/GIF+Recording+2026-04-08+at+20.16.38.gif) **Step 6 of 14: Connect your location's Google Account** This animation accompanies step 6 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you connect your location's Google Account. For context, this section explains: Create Multiple Spreadsheet Row(s) is best when your workflow needs to add new entries to Google Sheets rather than change rows that already exist. This is useful for writing repeated records, storing grouped data, or sending multiple values into a spreadsheet during one workflow execution. The navigation path used here is Automations > Workflows. The next step is to after connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. - Path: Automations > Workflows - What this covers: Connect your location's Google Account. - Controls: Connect, location's, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google - Next: After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. <- this image 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 7. After connecting your Google Account, select **Create Multiple Spreadsheet Row(s)** from the **Action dropdown**. ![Step 7 of 14: After connecting your Google Account, select Create Multiple…](https://jumpshare.com/share/VKJM23utsNxLgvLCF5lt+/Screen+Shot+2026-04-08+at+20.24.33.png) **Step 7 of 14: After connecting your Google Account, select Create Multiple…** This screenshot accompanies step 7 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you after connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. The navigation path used here is Automations > Workflows. The next step is to all your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. - Path: Automations > Workflows - What to choose: After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. - Controls: Create Multiple Spreadsheet Row(s), Action dropdown, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google - Next: All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. <- this image 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 8. All your **integrated** **Google** **accounts** in your **sub** **account** will be displayed in the dropdown menu for you to choose from. **Select any 1**. 9. Now select the **Drive** in which your spreadsheet resides. ![Step 9 of 14: Now select the Drive in which your spreadsheet resides](https://jumpshare.com/share/2vicPz07nBCO9DeVN0Gt+/Screen+Shot+2026-04-08+at+20.32.09.png) **Step 9 of 14: Now select the Drive in which your spreadsheet resides** This screenshot accompanies step 9 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you now select the Drive in which your spreadsheet resides. The navigation path used here is Automations > Workflows. The next step is to after selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. - Path: Automations > Workflows - What to choose: Now select the Drive in which your spreadsheet resides. - Controls: Drive, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets - Next: After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. <- this image 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 10. After selecting the drive, in the next dropdown you will get a list of all the **spreadsheets** present in the drive. Select the one in which you want to make the changes and also **select** the **worksheet**. ![Step 10 of 14: After selecting the drive, in the next dropdown you will get a list of…](https://jumpshare.com/share/JENuPFXLxh7AFgXgbu6T+/Screen+Shot+2026-04-08+at+20.33.53.png) **Step 10 of 14: After selecting the drive, in the next dropdown you will get a list of…** This screenshot accompanies step 10 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you after selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. The navigation path used here is Automations > Workflows. The next step is to if you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. - Path: Automations > Workflows - What to choose: After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. - Controls: spreadsheets, select, worksheet, Automations, Workflows, new, workflow, edit, existing, Add, trigger, + - Next: If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. <- this image 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 11. If you need to update the headers in the sheet, you can click the "**Refresh** **Headers**" button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. ![Step 11 of 14: If you need to update the headers in the sheet, you can click the "…](https://jumpshare.com/share/BMPXz4FX5YgDdSrxq9po+/Screen+Shot+2026-04-08+at+20.38.37.png) **Step 11 of 14: If you need to update the headers in the sheet, you can click the "…** This screenshot accompanies step 11 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you if you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. The navigation path used here is Automations > Workflows. The next step is to selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. - Path: Automations > Workflows - What to click: If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. - Controls: Refresh, Headers, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google - Next: Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. <- this image 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the **sheet's first row is automatically considered the header row**, and **each Column is labeled based on the header values in that row**. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on **Save Action**. ![Step 14 of 14: Click on Save Action](https://jumpshare.com/share/Ws0DiAH8zry7zNA6izw6+/GIF+Recording+2026-04-08+at+20.49.42.gif) **Step 14 of 14: Click on Save Action** This animation accompanies step 14 of 14 in the "How to Use the Action to Create Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you click on Save Action. For context, this section explains: Create Multiple Spreadsheet Row(s) is best when your workflow needs to add new entries to Google Sheets rather than change rows that already exist. This is useful for writing repeated records, storing grouped data, or sending multiple values into a spreadsheet during one workflow execution. The navigation path used here is Automations > Workflows. - Path: Automations > Workflows - How to confirm: Click on Save Action. - Controls: Save Action, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Create Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 12. Selecting Start column and End Column in the worksheet - When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 14. Click on Save Action. <- this image ### **How Create Multiple Spreadsheet Row(s) Works** Create Multiple Spreadsheet Row(s) only creates multiple rows when the **workflow run receives your data as an** **array (list) of row objects**. - **Each** **object** in the **array** becomes **one** **spreadsheet** **row**. - If the workflow run only has data for a single record (for example, one contact enrolled into the workflow), the action will write **one row**, which may feel the same as a single-row create action. - The action d**oes not automatically “wait” and batch contacts** that enter the workflow at different times. It **writes whatever array is available in that single workflow execution**. **Example array (creates 3 rows)** \[   {     "Name": "Sam",     "Email": "sam@test.com",     "Status": "New"   },   {     "Name": "Arjun",     "Email": "arjun@example.com",     "Status": "In Progress"   },   {     "Name": "Meera",     "Email": "meera@example.com",     "Status": "Completed"   } \] **Example 2:** \[ { FirstName: "John", LastName: "Doe", Email: "john@email.com" }, { FirstName: "Jane", LastName: "Smith", Email: "jane@email.com" } \] ### **How to Pass Multiple Rows into the Action** To create multiple rows in one workflow execution, the workflow must start with (or build) an array of row objects. Common ways to do this include: - **Inbound Web-hook Trigger** that sends a JSON payload containing an array of rows. - **A web-hook based integration** where a previous step returns an array that you map into this action. **Note:** If you need to write thousands of existing contacts (for example, 5,000 contacts already in the CRM), enrolling contacts one-by-one will trigger separate workflow runs and will not batch them automatically. ### **Best use cases** - Logging repeated workflow outputs into a spreadsheet. - Recording grouped entries from a single automation. - Saving multiple related data points for tracking or reporting. --- ## **How to Use the Action to Update Multiple Row(s) in Google Sheets** Update Multiple Spreadsheet Row(s) is useful when spreadsheet rows already exist and the workflow needs to modify values within a selected row range. This helps maintain accurate records without creating duplicate entries and is helpful when existing spreadsheet data needs to stay current over time. 1. Go to **Automations** > **Workflows**. ![Step 1 of 15: Go to Automations > Workflows](https://jumpshare.com/share/0JWEsWQU9NawnWRXArkh+/Screen+Shot+2026-04-06+at+21.20.01.png) **Step 1 of 15: Go to Automations > Workflows** This screenshot accompanies step 1 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you go to Automations > Workflows. For context, this section explains: Update Multiple Spreadsheet Row(s) is useful when spreadsheet rows already exist and the workflow needs to modify values within a selected row range. This helps maintain accurate records without creating duplicate entries and is helpful when existing spreadsheet data needs to stay current over time. The navigation path used here is Automations > Workflows. The next step is to create a new workflow or edit an existing one. - Path: Automations > Workflows - Where to go: Go to Automations > Workflows. - Controls: Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets, click - Next: Create a new workflow or edit an existing one. Full procedure: 1. Go to Automations > Workflows. <- this image 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 2. Create a **new** **workflow** or **edit** an **existing** one. ![Step 2 of 15: Create a new workflow or edit an existing one](https://jumpshare.com/share/BXEsCvFYK7i5WsZpbUNj+/Screen+Shot+2026-04-06+at+21.21.45.png) **Step 2 of 15: Create a new workflow or edit an existing one** This screenshot accompanies step 2 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you create a new workflow or edit an existing one. The navigation path used here is Automations > Workflows. The next step is to add a relevant trigger like Contact Created, Form Submitted, etc. - Path: Automations > Workflows - What this covers: Create a new workflow or edit an existing one. - Controls: new, workflow, edit, existing, Automations, Workflows, Add, trigger, +, Google, Sheets, click - Next: Add a relevant trigger like Contact Created, Form Submitted, etc. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. <- this image 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 3. **Add** a relevant **trigger** like Contact Created, Form Submitted, etc. ![Step 3 of 15: Add a relevant trigger like Contact Created, Form Submitted, etc](https://jumpshare.com/share/u1UFwknt8WsBsvkvjHaE+/GIF+Recording+2026-04-08+at+20.15.07.gif) **Step 3 of 15: Add a relevant trigger like Contact Created, Form Submitted, etc** This animation accompanies step 3 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you add a relevant trigger like Contact Created, Form Submitted, etc. The navigation path used here is Automations > Workflows. The next step is to click on the + button to add an Action. - Path: Automations > Workflows - What this covers: Add a relevant trigger like Contact Created, Form Submitted, etc. - Controls: Add, trigger, Automations, Workflows, new, workflow, edit, existing, +, Google, Sheets, click - Next: Click on the + button to add an Action. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. <- this image 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 4. Click on the **+** button to add an Action. 5. Search for **Google** **Sheets** action and **click** **on it to select the action**. 6. **Connect** your **location's** Google Account. ![Step 6 of 15: Connect your location's Google Account](https://jumpshare.com/share/FZLxmIbexGB6cmaB4lRS+/GIF+Recording+2026-04-08+at+20.16.38.gif) **Step 6 of 15: Connect your location's Google Account** This animation accompanies step 6 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you connect your location's Google Account. For context, this section explains: Update Multiple Spreadsheet Row(s) is useful when spreadsheet rows already exist and the workflow needs to modify values within a selected row range. This helps maintain accurate records without creating duplicate entries and is helpful when existing spreadsheet data needs to stay current over time. The navigation path used here is Automations > Workflows. The next step is to after connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. - Path: Automations > Workflows - What this covers: Connect your location's Google Account. - Controls: Connect, location's, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google - Next: After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. <- this image 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 7. After connecting your Google Account, select **Update Multiple Spreadsheet Row(s)** from the **Action dropdown**. ![Step 7 of 15: After connecting your Google Account, select Update Multiple…](https://jumpshare.com/share/AiPRH2CBOeXcZIS7MMZQ+/Screen+Shot+2026-04-08+at+20.59.28.png) **Step 7 of 15: After connecting your Google Account, select Update Multiple…** This screenshot accompanies step 7 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you after connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. The navigation path used here is Automations > Workflows. The next step is to all your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. - Path: Automations > Workflows - What to choose: After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. - Controls: Update Multiple Spreadsheet Row(s), Action dropdown, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google - Next: All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. <- this image 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 8. All your **integrated** **Google** **accounts** in your **sub** **account** will be displayed in the dropdown menu for you to choose from. **Select any 1**. 9. Now select the **Drive** in which your spreadsheet resides. ![Step 9 of 15: Now select the Drive in which your spreadsheet resides](https://jumpshare.com/share/y3riMM76YT9ad9YH5t0J+/Screen+Shot+2026-04-08+at+21.08.50.png) **Step 9 of 15: Now select the Drive in which your spreadsheet resides** This screenshot accompanies step 9 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you now select the Drive in which your spreadsheet resides. The navigation path used here is Automations > Workflows. The next step is to after selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. - Path: Automations > Workflows - What to choose: Now select the Drive in which your spreadsheet resides. - Controls: Drive, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets - Next: After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. <- this image 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 10. After selecting the drive, in the next dropdown you will get a list of all the **spreadsheets** present in the drive. Select the one in which you want to make the changes and also **select** the **worksheet**. ![Step 10 of 15: After selecting the drive, in the next dropdown you will get a list of…](https://jumpshare.com/share/xI9dyp1lqWRJ8Kc1nvHm+/Screen+Shot+2026-04-08+at+21.13.37.png) **Step 10 of 15: After selecting the drive, in the next dropdown you will get a list of…** This screenshot accompanies step 10 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you after selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. The navigation path used here is Automations > Workflows. The next step is to enter the row number from which you would like to update the sheet. - Path: Automations > Workflows - What to choose: After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. - Controls: spreadsheets, select, worksheet, Automations, Workflows, new, workflow, edit, existing, Add, trigger, + - Next: Enter the row number from which you would like to update the sheet. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. <- this image 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. 11. Enter the **row** **number** from which you would like to update the sheet. 12. Selecting **Start column** and **End Column** in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the "**Refresh** **Headers**" button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. ![Step 14 of 15: By providing this functionality, our system makes it easy to automate…](https://jumpshare.com/share/C8GCswkgzYdlhgLw20lI+/Screen+Shot+2026-04-08+at+21.19.54.png) **Step 14 of 15: By providing this functionality, our system makes it easy to automate…** This screenshot accompanies step 14 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you by providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. The navigation path used here is Automations > Workflows. The next step is to click on Save Action. - Path: Automations > Workflows - What this covers: By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. - Controls: Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets, click - Next: Click on Save Action. Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. <- this image 15. Click on **Save Action**. ![Step 15 of 15: Click on Save Action](https://jumpshare.com/share/0m3kf2wvKYTK7AAbJSDw+/Screen+Shot+2026-04-08+at+21.22.20.png) **Step 15 of 15: Click on Save Action** This screenshot accompanies step 15 of 15 in the "How to Use the Action to Update Multiple Row(s) in Google Sheets" section of "Workflow Action - Create & Update Multiple Rows in Google Sheets". At this point in the walkthrough you click on Save Action. For context, this section explains: Update Multiple Spreadsheet Row(s) is useful when spreadsheet rows already exist and the workflow needs to modify values within a selected row range. This helps maintain accurate records without creating duplicate entries and is helpful when existing spreadsheet data needs to stay current over time. The navigation path used here is Automations > Workflows. - Path: Automations > Workflows - How to confirm: Click on Save Action. - Controls: Save Action, Automations, Workflows, new, workflow, edit, existing, Add, trigger, +, Google, Sheets Full procedure: 1. Go to Automations > Workflows. 2. Create a new workflow or edit an existing one. 3. Add a relevant trigger like Contact Created, Form Submitted, etc. 4. Click on the + button to add an Action. 5. Search for Google Sheets action and click on it to select the action. 6. Connect your location's Google Account. 7. After connecting your Google Account, select Update Multiple Spreadsheet Row(s) from the Action dropdown. 8. All your integrated Google accounts in your sub account will be displayed in the dropdown menu for you to choose from. Select any 1. 9. Now select the Drive in which your spreadsheet resides. 10. After selecting the drive, in the next dropdown you will get a list of all the spreadsheets present in the drive. Select the one in which you want to make the changes and also select the worksheet. 11. Enter the row number from which you would like to update the sheet. 12. Selecting Start column and End Column in the worksheet: When sending data to a Google Sheets document using our workflow system, the sheet's first row is automatically considered the header row, and each Column is labeled based on the header values in that row. 13. If you need to update the headers in the sheet, you can click the " Refresh Headers " button to fetch the latest header values from the sheet. This ensures that your data is correctly mapped to the correct columns in the sheet and that your workflow is up-to-date with the latest sheet configurations. 14. By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. ### **When to use this option** - The spreadsheet row already exists. - You need to replace or refresh values in current records. - You want to avoid adding duplicate rows for the same data set. --- ## **Frequently Asked Questions** **Q: What is the difference between Create Multiple Spreadsheet Row(s) and Update Multiple Spreadsheet Row(s)?** Create Multiple Spreadsheet Row(s) adds new spreadsheet entries. Update Multiple Spreadsheet Row(s) changes values in rows that already exist. **Q: How is Create Multiple Spreadsheet Row(s) different from creating a single row?** Create Multiple Spreadsheet Row(s) can write many rows in one workflow execution, but only when you pass an **array of row objects**. If your workflow execution only has one record’s data, it will create one row. **Q: Does this action automatically batch contacts enrolled into the workflow?** No. Workflows do not automatically collect multiple contacts and send them as a single batch. To write multiple rows in one request, your workflow run must already contain a batch array (commonly sent via an Inbound Webhook). **Q: Do I need headers in my Google Sheet?** Yes. Clear headers help GHL Customer Care recognize the available columns for mapping and reduce setup errors. **Q: Why should I refresh headers?** Refreshing headers updates the available column names inside the workflow action after changes are made to the spreadsheet. **Q: What happens if I choose the wrong worksheet tab?** The workflow may write data to the wrong location or fail to map the expected columns correctly. **Q: Can I limit which columns are used?** Yes. The Starting Column and Ending Column fields define the column range available for mapping. **Q: When should I use multiple-row actions instead of a standard row action?** Use multiple-row actions when your workflow needs to create or update several spreadsheet rows as part of the same process. **Q: Can I update existing rows without creating duplicates?** Yes. Use Update Multiple Spreadsheet Row(s) when the target rows already exist and only the values need to be changed. **Q: Why is my new column not showing in the workflow action?** The action may still be using an older sheet structure. Click Refresh Headers after adding or renaming spreadsheet columns. --- ### **Related Articles** - [Workflow Action - Google Sheets](https://docs.ghlcustomercare.com/docs/workflows/integrations-workflow-actions/workflow-action-google-sheets) - [Guide to Google Sheets Premium Workflow Action](https://docs.ghlcustomercare.com/docs/workflows/workflow-builder/guide-to-google-sheets-premium-workflow-action) - [Workflow Builder Walkthrough](https://docs.ghlcustomercare.com/docs/workflows/workflow-builder/workflow-builder-walkthrough) --- Documentation for GHL Customer Care. Support: support@ghlcustomercare.com