# Guide to Google Sheets Premium Workflow Action > LC Premium Actions for Google Sheets is a tool to streamline data management processes by automating row creation, updating, and deletion. Seamlessly integrate your Google Sheets documents within our workflow system, enabling efficient data management. - Source: https://docs.ghlcustomercare.com/docs/workflows/workflow-builder/guide-to-google-sheets-premium-workflow-action - Section: Workflows / Workflow Builder - Reading time: 18 min - Images: 30, each explained below - Modified on Fri, 27 Jun, 2025 at 7:45 AM --- This guide explains how to effectively use the Google Sheets Premium Workflow Action in GHL Customer Care. Learn how to set up the action, utilize its individual functions, and troubleshoot common issues. This guide is ideal for users who want a deep dive into automating workflows with structured data integration in Google Sheets. --- **TABLE OF CONTENTS** - [What is the Google Sheets Premium Workflow Action?](#what-is-the-google-sheets-premium-workflow-action) - [Key Benefits of Google Sheets Integration](#key-benefits-of-google-sheets-integration) - [Before You Start](#before-you-start) - [How to Set Up the Google Sheets Integration](#how-to-set-up-the-google-sheets-integration) - [Google Sheets Action Basic Settings](#google-sheets-action-basic-settings) - [Google Sheets Action Functions](#google-sheets-action-functions) --- # **What is the Google Sheets Premium Workflow Action?** The Google Sheets Premium Workflow Action allows you to integrate Google Sheets directly into GHL Customer Care workflows, automating data transfers between the two systems with no third-party integration. This action supports various functions which include creating, looking up, updating, and deleting rows in a connected Google Sheet. In the Workflow Builder this is called an Action and in the Action settings the functions are also called Actions. We will refer to sub-Actions like Create Spreadsheet Row as functions. --- ## **Key Benefits of Google Sheets Integration** - **Structured Data Management**: Ensures data is organized the same way every time. - **Automation**: Reduces manual effort by syncing data instantly. - **Error Reduction**: Prevents duplication or errors from manual data entry. - **Scalability**: Supports growing datasets and increased operations tempo without any changes. --- ## **Before You Start** Before setting up the Google Sheets action, ensure the following: 1. **A Google account is integrated** with the GHL Customer Care subaccount. 2. **A Google Sheet is prepared.** Ensure the sheet is named and has clearly defined headers. 3. **Premium Triggers & Actions enabled** in your GHL Customer Care Agency account and the Subaccount. Some Triggers & Actions are premium, meaning GHL Customer Care charges the Agency for every execution in every Subaccount ($0.01 per execution, far less than other platforms charge). Agencies on the Pro plan can Rebill the Subaccounts, automatically covering costs or profiting. The Workflow Pro plan is a separate subscription the Agency can Resell to Subaccounts which pre-purchases premium triggers & actions at a bulk rate. --- ## **How to Set Up the Google Sheets Integration** The Google Sheets action has several details that must be defined but they are straight forward. ![How to Set Up the Google Sheets Integration (image 1 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/155038590478/original/0g9AOmI2Cpjj4GSH50ntgVFjtcagowosUQ.png) **How to Set Up the Google Sheets Integration (image 1 of 30)** This screenshot appears in the "How to Set Up the Google Sheets Integration" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The Google Sheets action has several details that must be defined but they are straight forward. Immediately after, the guide continues: Add the Google Sheets Action to Your Workflow: Link Your Google Account: If not already linked, authenticate your Google account in GHL Customer Care. Select Your Spreadsheet and Worksheet: Choose the appropriate Google Sheet and its…. - What this covers: The Google Sheets action has several details that must be defined but they are straight forward. - Controls: Add the Google Sheets Action, Automations > Workflows, + Add Action, Google Sheets Premium Workflow Action, Link Your Google Account, Select Your Spreadsheet and Worksheet - Next: Add the Google Sheets Action to Your Workflow: Link Your Google Account: If not already linked, authenticate your Google account in GHL Customer Care. Select Your Spreadsheet and Worksheet: Choose the appropriate Google Sheet and its specific worksheet where data will be updated. Full procedure: 1. Add the Google Sheets Action to Your Workflow: 2. Link Your Google Account: If not already linked, authenticate your Google account in GHL Customer Care. 3. Select Your Spreadsheet and Worksheet: Choose the appropriate Google Sheet and its specific worksheet where data will be updated. 1. **Add the Google Sheets Action** to Your Workflow: 1. Go to **Automations > Workflows** in GHL Customer Care. 2. Select **\+ Add Action** and choose **Google Sheets Premium Workflow Action**. 2. **Link Your Google Account**: If not already linked, authenticate your Google account in GHL Customer Care. 3. **Select Your Spreadsheet and Worksheet**: Choose the appropriate Google Sheet and its specific worksheet where data will be updated. --- ## **Google Sheets Action Basic Settings** ![Google Sheets Action Basic Settings (image 2 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/155038590342/original/cYv8BnVpsYzqgabMnOEQn3Hfog5CUlKIuw.png) **Google Sheets Action Basic Settings (image 2 of 30)** This screenshot appears in the "Google Sheets Action Basic Settings" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Add the Google Sheets Action to Your Workflow: Link Your Google Account: If not already linked, authenticate your Google account in GHL Customer Care. Select Your Spreadsheet and Worksheet: Choose the appropriate Google Sheet and its specific worksheet where data will be updated. This part of the guide covers 1 field, listed below. Immediately after, the guide continues: Choose An Account Choose a Drive Choose a Spreadsheet Choose a Worksheet Refresh Headers (the first row of the Worksheet) Select Columns (you can include all columns or a range). - What to choose: Add the Google Sheets Action to Your Workflow: Link Your Google Account: If not already linked, authenticate your Google account in GHL Customer Care. Select Your Spreadsheet and Worksheet: Choose the appropriate Google Sheet and its specific worksheet where data will be updated. - Fields: Refresh Headers (the first row of the Worksheet) - Controls: Account, Drive, Spreadsheet, Worksheet, Headers, Columns - Next: Choose An Account Choose a Drive Choose a Spreadsheet Choose a Worksheet Refresh Headers (the first row of the Worksheet) Select Columns (you can include all columns or a range) Full procedure: 1. Choose An Account 2. Choose a Drive 3. Choose a Spreadsheet 4. Choose a Worksheet 5. Refresh Headers (the first row of the Worksheet) 6. Select Columns (you can include all columns or a range) 1. Choose An **Account** 2. Choose a **Drive** 3. Choose a **Spreadsheet** 4. Choose a **Worksheet** 5. Refresh **Headers** (the first row of the Worksheet) 6. Select **Columns** (you can include all columns or a range) It help if you know the exact name of the Drive, Spreadsheet, and Worksheet so you can search for them. Otherwise it might be a lot of scrolling. --- ## **Google Sheets Action Functions**
FunctionDescription
Create Spreadsheet RowAdds a new row at the end of the spreadsheet
Create Multiple Spreadsheet Row(s)Adds one or more new rows at the end of the sheet
Lookup Spreadsheet RowFinds the first row that matches a search
Lookup Multiple Spreadsheet Row(s)Finds a match and returns a number of additional rows
Update Specific Spreadsheet RowAlters the data in a numbered row
Update Multiple Spreadsheet Row(s)Alters the data in multiple rows
Update Spreadsheet Row Using LookupAlters the data in a row that matches a search
Delete Specific Spreadsheet RowErases all the data in a numbered row leaving it blank
Delete Spreadsheet Row Using LookupErases all the data in the row that matches a search
### **Create Row** - Adds a new row to the end of the spreadsheet. - **Important Note**: New rows are always added after the highest-numbered row. **Lookup Row** - Searches for a row based on specified criteria. - **Common Use Case**: Retrieve customer records by email address. **Lookup + Create Row** - Combines Lookup and Create functionalities. - **Behavior**: If the Lookup action does not find a matching row, a new row is created. **Update Row** - Updates data in a specified row. - **Important Note**: This action requires the row number, which is often obtained using the Lookup action-item. **Delete Row** - Deletes a row based on its row number. - **Tip**: Use Lookup first to identify the row number before deleting. 6\. **Advanced Features** - **Multiple Rows Lookup**: Retrieve multiple rows based on filter criteria, useful for batch processing. - **Custom Variable Mapping**: After a Lookup action, headers are mapped to custom variables, simplifying further actions. - **Troubleshooting**: If headers are changed in the Google Sheet, refresh the mapping in GHL Customer Care. 7\. **Use Cases for Google Sheets Integration** - **Sales Tracking**: Automatically add or update leads in Google Sheets when they reach milestones. - **Marketing Campaigns**: Sync campaign performance metrics for real-time analysis. - **Customer Support**: Record and update support ticket logs directly in Sheets. 8\. **Troubleshooting and Common Issues** - **Index Mapping Issues**: - Refresh headers in GHL Customer Care if changes are made in the Google Sheet. - **Authentication Errors**: - Reauthorize your Google account in GHL Customer Care. - **Spreadsheet Not Appearing**: - Ensure the correct account and permissions are in use. 9\. **FAQs** **Q: What happens if Google Sheet headers are renamed?** You will need to refresh the headers in GHL Customer Care and reconfigure any affected workflows. **Q: Can multiple Google Sheets be integrated into one workflow?** Yes, each action-item can specify a different Google Sheet. 10\. **Next Steps** - Explore related articles: - Workflow Action - Google Sheets - How to Enable LC Premium Actions --- LC Premium Actions for Google Sheets is a powerful tool to streamline data management processes by automating row creation, updating, and deletion. Seamlessly integrate your Google Sheets documents within our workflow system, enabling efficient data management and reducing the risk of errors. Leverage lookup functionalities to locate specific rows, ensuring accuracy and providing a comprehensive solution for all your Google Sheets data needs. **Agencies on** **Any Plan** ($97, $970, $297, $2970, $497, $4970) can access LC Premium Triggers & Actions. \- Once Premium Actions & Triggers are enabled via the Agency settings, EXISTING and New Sub-Accounts will have **100 free executions**. \- For agencies to avoid accruing execution costs for EXISTING Sub-Accounts, rebilling will need to be enabled **manually** for each Sub-Account within the Agency view (more info).  \- If premium actions are **enabled** on the SaaS Configurator, new Sub-Accounts generated will automatically be enrolled in LC Premium Actions & Triggers, **no further** action is required by the agency. #### **Covered in this Article** #### [**What is the Google Sheets Premium Workflow Action?**](#what-is-the-google-sheets-premium-workflow-action) #### [Who is this feature useful for?](#who-is-this-feature-useful-for) #### [What are the benefits of this feature?](#what-are-the-benefits-of-this-feature) #### [**How to use the Google Sheets Premium Workflow Action?**](#how-to-use-the-google-sheets-premium-workflow-action) #### [Create Spreadsheet Row](#create-spreadsheet-row) #### [Choose a Google account:](#choose-a-google-account) #### [Select a Drive:](#select-a-drive) #### [Select a Spreadsheet:](#select-a-spreadsheet) #### [Select a Worksheet:](#select-a-worksheet) #### [Selecting Starting Column and End Column in the Worksheet](#selecting-starting-column-and-end-column-in-the-worksheet) #### [Insert values to create a new row in the Worksheet:](#insert-values-to-create-a-new-row-in-the-worksheet) #### [Update Specific Spreadsheet Row](#update-specific-spreadsheet-row) #### [Choose a worksheet:](#choose-a-worksheet) #### [Insert Row Number:](#insert-row-number) #### [Select Starting Column and ending column:](#select-starting-column-and-ending-column) #### [Delete Specific Spreadsheet Row](#delete-specific-spreadsheet-row) #### [Choose a worksheet:](#choose-a-worksheet) #### [Insert Row Number:](#insert-row-number-2) #### [Lookup Spreadsheet Row](#lookup-spreadsheet-row) #### [Choose a worksheet:](#choose-a-worksheet-3) #### [Select Search Order:](#select-search-order) #### [Select a Column and Lookup Value to find the matching row](#select-a-column-and-lookup-value-to-find-the-matching-row) #### [Select an extra Column and Lookup Value.](#select-an-extra-column-and-lookup-value) #### [Using as Custom Variables:](#using-as-custom-variables) #### [Important points to remember:](#important-points-to-remember) #### [Update Spreadsheet Row using Lookup.](#update-spreadsheet-row-using-lookup) #### [Select Lookup Action](#select-lookup-action) #### [Selecting a Starting Column and End Column](#selecting-a-starting-column-and-end-column) #### [Points to Remember:](#points-to-remember) #### [Delete Spreadsheet Row using Lookup.](#delete-spreadsheet-row-using-lookup) #### [Points to Remember:](#points-to-remember) --- ## **What is the Google Sheets Premium Workflow Action?** Google Sheets Premium Workflow Action is a robust feature designed to enhance your data management experience within Google Sheets using the LC Premium Actions system. This powerful tool enables you to automate various tasks, such as creating, updating, and deleting rows, significantly improving your workflow efficiency and data accuracy. By leveraging the LC Premium Actions system, you can easily integrate Google Sheets into your data management processes without complex third-party integrations. The system also provides an intuitive user interface, streamlining your data management tasks and enabling you to focus on more critical aspects of your work. One of the standout features of the Google Sheets Premium Workflow Action is the powerful lookup functionality. This allows you to search for specific rows within your sheets based on specific criteria, making it easy to locate and work with relevant data. This feature helps automate complex data management tasks, such as cross-referencing data from multiple sheets or databases. Furthermore, the Google Sheets Premium Workflow Action supports a range of actions, including creating new rows, updating specific rows, deleting rows, and more advanced features like updating or deleting rows using the lookup function. This comprehensive suite of actions ensures you have all the tools you need to manage your data in Google Sheets effectively. In addition to its core features, the Google Sheets Premium Workflow Action allows you to use custom variables to store and manipulate data within your workflows. This flexibility enables you to create dynamic, data-driven workflows tailored to your needs and requirements. ### **Who is this feature useful for?** The Google Sheets Premium Workflow Action feature is helpful for a wide range of individuals and organizations that rely on data management and collaboration using Google Sheets. This includes, but is not limited to: - Small and medium-sized businesses: These organizations can use this feature to automate data management processes, track inventory, manage budgets, and create reports, enabling more efficient collaboration and decision-making. - Project managers: They can utilize this feature to streamline project tracking, task management, and resource allocation within Google Sheets, leading to improved project outcomes and team productivity. - Sales and marketing professionals: This feature can help automate data entry, lead tracking, and sales performance analysis, enabling better insights and decision-making in sales and marketing campaigns. - Human Resources (HR) professionals: The Google Sheets Premium Workflow Action can manage employee data, automate onboarding processes, and track various HR-related metrics, saving time and reducing errors. - Educators and academic institutions: Teachers and administrators can use this feature to manage student data, track assignments, and analyze performance metrics, leading to more effective educational strategies. - Non-profit organizations: Non-profits can benefit from this feature by automating donor management, event planning, and budget tracking within Google Sheets, leading to more efficient operations and better allocation of resources. - Researchers and data analysts: These professionals can use the feature to streamline data collection, analysis, and reporting processes within Google Sheets, resulting in more accurate and timely insights. ### **What are the benefits of this feature?** The Google Sheets Premium Workflow Action offers numerous benefits to users, making it a valuable addition to their data management processes. Some of the key benefits include: - Improved efficiency: By automating various data management tasks, such as creating, updating, and deleting rows, users can save time and improve productivity, allowing them to focus on more critical aspects of their work. - Enhanced accuracy: Automation reduces the risk of human error in data management processes, ensuring that the data within Google Sheets remains accurate and reliable. - Streamlined collaboration: This feature simplifies data sharing and cooperation among team members, making it easier to work together on projects and achieve shared goals. - Flexible customization: Using custom variables and lookups enable users to create dynamic, data-driven workflows tailored to their needs and requirements. - Powerful lookup functionality: This feature allows users to search for specific rows within their sheets based on specific criteria, making it easy to locate and work with relevant data. This is particularly useful for automating complex data management tasks, such as cross-referencing data from multiple sheets or databases. - Easy integration: The Google Sheets Premium Workflow Action eliminates the need for complex third-party integrations, offering a seamless and user-friendly solution for managing data within Google Sheets. - Scalability: This feature can be utilized by organizations of all sizes, making it a scalable solution for managing data as the organization grows and evolves. - Better decision-making: By streamlining data management processes and improving data accuracy, users can make more informed decisions based on the insights derived from their Google Sheets data. --- ## **How to use the Google Sheets Premium Workflow Action?** The following Workflow actions are supported in Google Sheets. ![How to use the Google Sheets Premium Workflow Action? (image 3 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294013403/original/lCUixqYdA6zlNXPNjAJXNYf7kjn5vEngMg.png) **How to use the Google Sheets Premium Workflow Action? (image 3 of 30)** This screenshot appears in the "How to use the Google Sheets Premium Workflow Action?" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The following Workflow actions are supported in Google Sheets. Immediately after, the guide continues: LC Premium Actions lets you send data directly to a Google Sheets document without requiring third-party integrations. All you need to do is integrate your Google account with our system and select the desired sheet from your Google…. - What this covers: The following Workflow actions are supported in Google Sheets. - Next: LC Premium Actions lets you send data directly to a Google Sheets document without requiring third-party integrations. All you need to do is integrate your Google account with our system and select the desired sheet from your Google Drive. From there, you can easily send data to the sheet using our intuitive user interface. --- ### **Create Spreadsheet Row**  LC Premium Actions lets you send data directly to a Google Sheets document without requiring third-party integrations. All you need to do is integrate your Google account with our system and select the desired sheet from your Google Drive. From there, you can easily send data to the sheet using our intuitive user interface. With our #### **Choose a Google account:** All your integrated Google accounts in your subaccount will be displayed in the dropdown menu for you to choose from. ![Choose a Google account: (image 4 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014486/original/aowv6YTk63mq1daX0eqDn2h0db48akFmFA.png) **Choose a Google account: (image 4 of 30)** This screenshot appears in the "Choose a Google account:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: All your integrated Google accounts in your subaccount will be displayed in the dropdown menu for you to choose from. Immediately after, the guide continues: Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the…. - What to choose: All your integrated Google accounts in your subaccount will be displayed in the dropdown menu for you to choose from. - Next: Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the target Google Sheets document you want to send data. #### **Select a Drive:** Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the target Google Sheets document you want to send data. ![Select a Drive: (image 5 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014527/original/fWMFC1aLZvu2iuX_Pd87-QxdbtZnSAQfmQ.png) **Select a Drive: (image 5 of 30)** This screenshot appears in the "Select a Drive:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the target Google Sheets document you want to send data. Immediately after, the guide continues: Once you have selected a Google Drive from the dropdown menu, all Spreadsheets associated with the integrated Google Drive will be displayed for you to choose from. - What to choose: Once you have selected a Google account from the dropdown menu in our subaccount system, all associated Google Drives will be displayed for you to choose from. This allows you to select the specific Google Drive account containing the target Google Sheets document you want to send data. - Next: Once you have selected a Google Drive from the dropdown menu, all Spreadsheets associated with the integrated Google Drive will be displayed for you to choose from. #### **Select a Spreadsheet:** Once you have selected a Google Drive from the dropdown menu, all Spreadsheets associated with the integrated Google Drive will be displayed for you to choose from. This allows you to select the specific Google Spreadsheet document to which you want to send data. ![Select a Spreadsheet: (image 6 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014588/original/47mlhoT1pJN-daaiQVu2ubV1F9EyzNrk2w.png) **Select a Spreadsheet: (image 6 of 30)** This screenshot appears in the "Select a Spreadsheet:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: This allows you to select the specific Google Spreadsheet document to which you want to send data. Immediately after, the guide continues: Once you have selected a Google Spreadsheet from the dropdown menu, all Worksheets inside that Spreadsheet will be displayed for you to choose from. - What to choose: This allows you to select the specific Google Spreadsheet document to which you want to send data. - Next: Once you have selected a Google Spreadsheet from the dropdown menu, all Worksheets inside that Spreadsheet will be displayed for you to choose from. #### **Select a Worksheet:** Once you have selected a Google Spreadsheet from the dropdown menu, all Worksheets inside that Spreadsheet will be displayed for you to choose from. This allows you to select the specific Worksheet to which you want to send data. ![Select a Worksheet: (image 7 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014598/original/N4mlSoOjjgifygREP0oGmDbHgU9neUHygA.png) **Select a Worksheet: (image 7 of 30)** This screenshot appears in the "Select a Worksheet:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: This allows you to select the specific Worksheet to which you want to send data. Immediately after, the guide continues: 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. - What to choose: This allows you to select the specific Worksheet to which you want to send data. - Next: 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. #### **Selecting Starting 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. 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.  By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. ![Selecting Starting Column and End Column in the Worksheet (image 8 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014623/original/8K0LEE6bz3imuip9_p68DFBtChyKkXHgnw.png) **Selecting Starting Column and End Column in the Worksheet (image 8 of 30)** This screenshot appears in the "Selecting Starting Column and End Column in the Worksheet" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: By providing this functionality, our system makes it easy to automate data management processes and ensure the accuracy of your data workflows. Immediately after, the guide continues: You can insert value and create a new row in your Google Sheets document. - 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. - Next: You can insert value and create a new row in your Google Sheets document. #### **Insert values to create a new row in the Worksheet:** You can insert value and create a new row in your Google Sheets document. ![Insert values to create a new row in the Worksheet: (image 9 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014637/original/c4sVZ1664jaJwbVbRWDUZZLRiR9Nyr2SyA.png) **Insert values to create a new row in the Worksheet: (image 9 of 30)** This screenshot appears in the "Insert values to create a new row in the Worksheet:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: You can insert value and create a new row in your Google Sheets document. Immediately after, the guide continues: The "Update Specific Spreadsheet Row" action enables us to modify the contents of a specific row by specifying its row number. This action updates the values in the corresponding columns of that row. - What this covers: You can insert value and create a new row in your Google Sheets document. - Next: The "Update Specific Spreadsheet Row" action enables us to modify the contents of a specific row by specifying its row number. This action updates the values in the corresponding columns of that row. --- ### **Update Specific Spreadsheet Row ** The "Update Specific Spreadsheet Row" action enables us to modify the contents of a specific row by specifying its row number. This action updates the values in the corresponding columns of that row. #### **Choose a worksheet:** Select a worksheet within your Spreadsheet that you wish to edit a row. ![Choose a worksheet: (image 10 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014668/original/NkYnzrKnKEQCb0sV4-dnD0HOgdBgoFmsQg.png) **Choose a worksheet: (image 10 of 30)** This screenshot appears in the "Choose a worksheet:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Select a worksheet within your Spreadsheet that you wish to edit a row. Immediately after, the guide continues: Specify the row number that you wish to modify in the Spreadsheet. - What to choose: Select a worksheet within your Spreadsheet that you wish to edit a row. - Next: Specify the row number that you wish to modify in the Spreadsheet. #### **Insert Row Number:** Specify the row number that you wish to modify in the Spreadsheet. ![Insert Row Number: (image 11 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014694/original/NnHgJ15jBPQCrCEHcsYCcZOk_WKZTtgJig.png) **Insert Row Number: (image 11 of 30)** This screenshot appears in the "Insert Row Number:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Specify the row number that you wish to modify in the Spreadsheet. Immediately after, the guide continues: You may also provide the Row Number using the Custom Variable Picker to use dynamic values. - What this covers: Specify the row number that you wish to modify in the Spreadsheet. - Next: You may also provide the Row Number using the Custom Variable Picker to use dynamic values. You may also provide the Row Number using the Custom Variable Picker to use dynamic values. ![Insert Row Number: (image 12 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014701/original/vD0gBD8SxluQnVmvOA0yjOc1bfa9TYg3cA.png) **Insert Row Number: (image 12 of 30)** This screenshot appears in the "Insert Row Number:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: You may also provide the Row Number using the Custom Variable Picker to use dynamic values. Immediately after, the guide continues: To update the desired columns, select the starting and ending columns. - What to fill in: You may also provide the Row Number using the Custom Variable Picker to use dynamic values. - Next: To update the desired columns, select the starting and ending columns. #### **Select Starting Column and ending column:** To update the desired columns, select the starting and ending columns. You can leave it blank if you do not wish to update a particular column. ![Select Starting Column and ending column: (image 13 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014723/original/uqOuN_jLGz2mEYd9vzaguQonUE8qfcoGCg.png) **Select Starting Column and ending column: (image 13 of 30)** This screenshot appears in the "Select Starting Column and ending column:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: You can leave it blank if you do not wish to update a particular column. Immediately after, the guide continues: The "Delete Specific Spreadsheet Row" action enables us to delete the contents of a specific row by specifying its row number. This action will clear the values in all of the columns of that row. - What this covers: You can leave it blank if you do not wish to update a particular column. - Next: The "Delete Specific Spreadsheet Row" action enables us to delete the contents of a specific row by specifying its row number. This action will clear the values in all of the columns of that row. --- ### **Delete Specific Spreadsheet Row** The "Delete Specific Spreadsheet Row" action enables us to delete the contents of a specific row by specifying its row number. This action will clear the values in all of the columns of that row. **Please Note:** When you use the "Delete Specific Spreadsheet" action, it clears the contents of the row, but it does not permanently remove the row itself. #### **Choose a worksheet:** Select a worksheet within your Spreadsheet that you wish to delete a row of. ![Choose a worksheet: (image 14 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294014785/original/ZmbzRansrOH-JlzMGJNwKciPFP0wRhn-Lg.png) **Choose a worksheet: (image 14 of 30)** This screenshot appears in the "Choose a worksheet:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Select a worksheet within your Spreadsheet that you wish to delete a row of. Immediately after, the guide continues: Specify the row number that you wish to delete in the Spreadsheet. - What to choose: Select a worksheet within your Spreadsheet that you wish to delete a row of. - Next: Specify the row number that you wish to delete in the Spreadsheet. #### **Insert Row Number:** Specify the row number that you wish to delete in the Spreadsheet. **Please Note:**  You may also provide the Row Number using the Custom Variable Picker to use dynamic values. --- ###  **Lookup Spreadsheet Row** The Google Sheet Lookup action allows you to look up data within your Google Sheets documents, providing you with a powerful tool for managing your data workflows. - Using our system, you can easily Lookup any row in your sheet and use the custom values associated with that row within your workflow. - This functionality allows you to automate complex data management processes, such as cross-referencing data from multiple sheets or databases.  - By leveraging the power of our workflow system, you can reduce errors, increase efficiency, and save time, all while ensuring the accuracy and completeness of your data. - With our lookup functionality, you can easily integrate your Google Sheets documents into your workflow processes, creating powerful data management workflows that help you to drive better outcomes. #### **Choose a worksheet:** Select a worksheet within your Spreadsheet that you wish to use for Looking up and retrieving data. ![Choose a worksheet: (image 15 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015040/original/KBpwiNLroiROx6x6bTHlgmSpNNkmDZ-foQ.png) **Choose a worksheet: (image 15 of 30)** This screenshot appears in the "Choose a worksheet:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Select a worksheet within your Spreadsheet that you wish to use for Looking up and retrieving data. Immediately after, the guide continues: Select in which order the Google Sheet rows should be searched to find the matching row. - What to choose: Select a worksheet within your Spreadsheet that you wish to use for Looking up and retrieving data. - Next: Select in which order the Google Sheet rows should be searched to find the matching row. #### **Select Search Order:** Select in which order the Google Sheet rows should be searched to find the matching row. From the top of the Sheet - returns the first matching row From the bottom of the Sheet - returns the most recent matching row ![Select Search Order: (image 16 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294343971/original/Ap0dw_qAyW7_Yzyi7O8GC4a3YAkeuBDugw.png) **Select Search Order: (image 16 of 30)** This screenshot appears in the "Select Search Order:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: From the bottom of the Sheet - returns the most recent matching row. Immediately after, the guide continues: The first row is considered Headers, shown as labels for each Column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".columncolumn. - What this covers: From the bottom of the Sheet - returns the most recent matching row - Next: The first row is considered Headers, shown as labels for each Column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".columncolumn #### **Select a Column and Lookup Value to find the matching row** The first row is considered Headers, shown as labels for each Column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".columncolumn ![Select a Column and Lookup Value to find the matching row (image 17 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015052/original/GfcBeKvgMuNwS1AjYO6ipi2XiVADNqlQKg.png) **Select a Column and Lookup Value to find the matching row (image 17 of 30)** This screenshot appears in the "Select a Column and Lookup Value to find the matching row" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The first row is considered Headers, shown as labels for each Column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".columncolumn. Immediately after, the guide continues: If an extra column is added, then both the Column's values should match to determine the matching row. - What this covers: The first row is considered Headers, shown as labels for each Column. You can fetch the latest headers from the sheet by clicking "Refresh Headers".columncolumn - Next: If an extra column is added, then both the Column's values should match to determine the matching row. #### **Select an extra Column and Lookup Value.** If an extra column is added, then both the Column's values should match to determine the matching row. ![Select an extra Column and Lookup Value. (image 18 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015069/original/a308RmqZwNOM2ixkIBbxOY9ifkllRm17mw.png) **Select an extra Column and Lookup Value. (image 18 of 30)** This screenshot appears in the "Select an extra Column and Lookup Value." section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: If an extra column is added, then both the Column's values should match to determine the matching row. Immediately after, the guide continues: Lookup Multiple Spreadsheet Row(s) is an extension to the Lookup Spreadsheet Row. Using this we can extract multiple rows. The configuration will be the same as Look Spreadsheet Row just with an addition of selecting the number of rows…. - What this covers: If an extra column is added, then both the Column's values should match to determine the matching row. - Next: Lookup Multiple Spreadsheet Row(s) is an extension to the Lookup Spreadsheet Row. Using this we can extract multiple rows. The configuration will be the same as Look Spreadsheet Row just with an addition of selecting the number of rows you want to extract. #### **Create Spreadsheet row if it doesn't exist yet:** #### If enabled, it will execute Create Spreadsheet Row action when the lookup could not find any matching row at the time of execution. This action will be logged and charged separately. ![If enabled, it will execute Create Spreadsheet Row action when the lookup could not find any matching row at the time of execution. This action will be logged…](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294757968/original/gFVg7udmk8YIEO8JVUB319ME31a2YFXBHw.png) **If enabled, it will execute Create Spreadsheet Row action when the lookup could not find any matching row at the time of execution. This action will be logged and charged separately. (image 19 of 30)** This screenshot appears in the "If enabled, it will execute Create Spreadsheet Row action when the lookup could not find any matching row at the time of execution. This action will be logged and charged separately." section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: If an extra column is added, then both the Column's values should match to determine the matching row. Immediately after, the guide continues: Lookup Multiple Spreadsheet Row(s) is an extension to the Lookup Spreadsheet Row. Using this we can extract multiple rows. The configuration will be the same as Look Spreadsheet Row just with an addition of selecting the number of rows…. - What this covers: If an extra column is added, then both the Column's values should match to determine the matching row. - Next: Lookup Multiple Spreadsheet Row(s) is an extension to the Lookup Spreadsheet Row. Using this we can extract multiple rows. The configuration will be the same as Look Spreadsheet Row just with an addition of selecting the number of rows you want to extract. ### **Lookup Multiple Spreadsheet Row(s)** Lookup Multiple Spreadsheet Row(s) is an extension to the Lookup Spreadsheet Row. Using this we can extract multiple rows. The configuration will be the same as Look Spreadsheet Row just with an addition of selecting the number of rows you want to extract. The only difference is selecting the number of rows and that can be achieved by typing in the number of Rows in the "Row Count" field. ![Lookup Multiple Spreadsheet Row(s) (image 20 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/155025719351/original/UBHwpCpCW0i-lmy6t4QBIWy-Wh3aDZXI_A.png) **Lookup Multiple Spreadsheet Row(s) (image 20 of 30)** This screenshot appears in the "Lookup Multiple Spreadsheet Row(s)" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The only difference is selecting the number of rows and that can be achieved by typing in the number of Rows in the "Row Count" field. Immediately after, the guide continues: One of the advantages of using Lookup is that when you search for a particular row, all of its data can be saved as a custom value that can be utilized throughout your workflow. - What this covers: The only difference is selecting the number of rows and that can be achieved by typing in the number of Rows in the "Row Count" field. - Next: One of the advantages of using Lookup is that when you search for a particular row, all of its data can be saved as a custom value that can be utilized throughout your workflow. #### **Using as Custom Variables:** One of the advantages of using Lookup is that when you search for a particular row, all of its data can be saved as a custom value that can be utilized throughout your workflow. Consider the following Worksheet as an example. If you need to search for a specific row, you can enter the contact phone number or email address in the lookup section. Once the lookup function finds the matching row, it will store all the values under the corresponding header name as custom variables. ####  ** ![Using as Custom Variables: (image 21 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015115/original/LGaxBgQwvGYJoILbTF4nkBZzWgXDoySsyA.png) **Using as Custom Variables: (image 21 of 30)** This screenshot appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Consider the following Worksheet as an example. If you need to search for a specific row, you can enter the contact phone number or email address in the lookup section. Once the lookup function finds the matching row, it will store all the values under the corresponding header name as custom…. Immediately after, the guide continues: When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. Removing or editing the index once…. - What to fill in: Consider the following Worksheet as an example. If you need to search for a specific row, you can enter the contact phone number or email address in the lookup section. Once the lookup function finds the matching row, it will store all the values under the corresponding header name as custom variables. - Next: When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. Removing or editing the index once it is added is impossible. ** When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. Removing or editing the index once it is added is impossible. ![Using as Custom Variables: (image 22 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015133/original/XkZFM8oEj5xmLie9900hm1X7SmVVdhmidg.png) **Using as Custom Variables: (image 22 of 30)** This screenshot appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. Removing or editing the index once it is added is impossible. Immediately after, the guide continues: The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. - What this covers: When you add a Lookup action, an index is automatically generated. This index is essential for mapping the row data to the custom variables and allows for easy identification of multiple lookup values. Removing or editing the index once it is added is impossible. - Next: The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. ![Using as Custom Variables: (image 23 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015142/original/GJblMYbDnexU3c5q-lBeQMQ812EGRVdK4A.png) **Using as Custom Variables: (image 23 of 30)** This screenshot appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. Immediately after, the guide continues: As previously mentioned, the index generated by the lookup function serves as a reference and is used for internal mapping of the custom variables in lookup actions. - What this covers: The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. - Next: As previously mentioned, the index generated by the lookup function serves as a reference and is used for internal mapping of the custom variables in lookup actions. ![Using as Custom Variables: (image 24 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015154/original/O4T0vx4kMtrqadNUUSZ1E3xXPUtgLbzlFw.png) **Using as Custom Variables: (image 24 of 30)** This screenshot appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. Immediately after, the guide continues: As previously mentioned, the index generated by the lookup function serves as a reference and is used for internal mapping of the custom variables in lookup actions. - What this covers: The values obtained from the lookup action for a particular row can be used in all other activities within your workflows, just like any other contact fields or custom variables. - Next: As previously mentioned, the index generated by the lookup function serves as a reference and is used for internal mapping of the custom variables in lookup actions. **Please Note:** As previously mentioned, the index generated by the lookup function serves as a reference and is used for internal mapping of the custom variables in lookup actions. You can use {{sheet.x.rowNumber}} to get the row number of the lookup value. Here x is the index of the lookup action. ![Using as Custom Variables: (image 25 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015187/original/viPTWFRwhmb1scMyguQYVXDynZa8OxKdww.png) **Using as Custom Variables: (image 25 of 30)** This screenshot appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Here x is the index of the lookup action. Immediately after, the guide continues: The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below. - What this covers: Here x is the index of the lookup action. - Next: The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below.   **Example:** The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below. ![Using as Custom Variables: (image 26 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015228/original/e-kSxKyAnih4z5l92rupHPtUFgddgBdK1g.gif) **Using as Custom Variables: (image 26 of 30)** This animation appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below. Immediately after, the guide continues: Referencing the Google Sheets Lookup Action cannot find a matching row; all subsequent Google Sheets Actions that reference this Lookup Action will be skipped due to lack of a result. Therefore, consider this when building workflows that…. - What this covers: The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below. - Next: Referencing the Google Sheets Lookup Action cannot find a matching row; all subsequent Google Sheets Actions that reference this Lookup Action will be skipped due to lack of a result. Therefore, consider this when building workflows that include this Lookup Action and the Google Sheets: Update Spreadsheet Row using Lookup or Google Sheets: Delete Spreadsheet Row using Lookup. Provide since the Lookup Action results are available for If/Else Conditions, you can use those to decide whether to use Google Sheets: Create Spreadsheet Row or Google Sheets: Update Spreadsheet Row using Lookup, based on the condition of having a Lookup Result or not. use **In If/Else:** ![Using as Custom Variables: (image 27 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015249/original/nNpO9JtVAJ9DWXrirZwplnuD9MpFPGai4Q.gif) **Using as Custom Variables: (image 27 of 30)** This animation appears in the "Using as Custom Variables:" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below. Immediately after, the guide continues: Referencing the Google Sheets Lookup Action cannot find a matching row; all subsequent Google Sheets Actions that reference this Lookup Action will be skipped due to lack of a result. Therefore, consider this when building workflows that…. - What this covers: The custom values of LookedUp Row can be utilized in all of the actions within your workflow. Some examples of how to do this are provided below. - Next: Referencing the Google Sheets Lookup Action cannot find a matching row; all subsequent Google Sheets Actions that reference this Lookup Action will be skipped due to lack of a result. Therefore, consider this when building workflows that include this Lookup Action and the Google Sheets: Update Spreadsheet Row using Lookup or Google Sheets: Delete Spreadsheet Row using Lookup. Provide since the Lookup Action results are available for If/Else Conditions, you can use those to decide whether to use Google Sheets: Create Spreadsheet Row or Google Sheets: Update Spreadsheet Row using Lookup, based on the condition of having a Lookup Result or not. use #### **Important points to remember:** - Referencing the Google Sheets Lookup Action cannot find a matching row; all subsequent Google Sheets Actions that reference this Lookup Action will be skipped due to lack of a result. Therefore, consider this when building workflows that include this Lookup Action and the Google Sheets: Update Spreadsheet Row using Lookup or Google Sheets: Delete Spreadsheet Row using Lookup. - Provide - since the Lookup Action results are available for If/Else Conditions, you can use those to decide whether to use Google Sheets: Create Spreadsheet Row or Google Sheets: Update Spreadsheet Row using Lookup, based on the condition of having a Lookup Result or not. use --- ### **Update Spreadsheet Row using Lookup. ** Updating a spreadsheet row using Lookup involves searching for a specific row in your Spreadsheet based on a particular value using Lookup and then updating the values in that row with new data. To update a specific row in a spreadsheet, you Should use Lookup Action to search for a column value in the data, which will return the corresponding row. Once you have located the desired row, you can use the "Update sheet using Lookup" Action to modify the data within that row. **Please Note:** If you want to use the "Update using lookup" action, it is necessary to first use the "Lookup" action to search for a specific row in your spreadsheet based on a particular value. Once you have found the desired row using lookup, you can then use the "Update using lookup" action to modify the data within that row. Therefore, using the lookup action prior to updating using lookup is a necessary step in this process. #### **Select Lookup Action** This action will only display the Lookup actions added above it for selection. ![Select Lookup Action (image 28 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015478/original/oTwiXd_AlB6rUAcygGvIj9jkKugfbANlEg.gif) **Select Lookup Action (image 28 of 30)** This animation appears in the "Select Lookup Action" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: This action will only display the Lookup actions added above it for selection. Immediately after, the guide continues: To update the desired columns, select the starting and ending columns. - What this covers: This action will only display the Lookup actions added above it for selection. - Next: To update the desired columns, select the starting and ending columns. #### **Selecting a Starting Column and End Column** To update the desired columns, select the starting and ending columns. You can leave it blank if you do not wish to update a particular column. ![Selecting a Starting Column and End Column (image 29 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015513/original/7fT3UvPXjD4J4uoawpGjymxipluQJ7FFXQ.png) **Selecting a Starting Column and End Column (image 29 of 30)** This screenshot appears in the "Selecting a Starting Column and End Column" section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: You can leave it blank if you do not wish to update a particular column. Immediately after, the guide continues: In the "Update Specific Sheet Row" action, you can select only one Lookup Action at a time. You can leave it blank if you do not wish to update a particular column. If the Lookup Action does not return any rows, the workflow will skip…. - What this covers: You can leave it blank if you do not wish to update a particular column. - Next: In the "Update Specific Sheet Row" action, you can select only one Lookup Action at a time. You can leave it blank if you do not wish to update a particular column. If the Lookup Action does not return any rows, the workflow will skip this step and proceed to the next one. #### **Points to Remember:** - In the "Update Specific Sheet Row" action, you can select only one Lookup Action at a time. - You can leave it blank if you do not wish to update a particular column. - If the Lookup Action does not return any rows, the workflow will skip this step and proceed to the next one. --- ### **Delete Spreadsheet Row using Lookup.** Deleting a spreadsheet row using Lookup involves searching for a specific row in your Spreadsheet based on a particular value using Lookup and then deleting all the values in that row. To delete a specific row in a spreadsheet, you Should use Lookup Action to search for a column value in the data, which will return the corresponding row. Once you have located the desired row, you can use the "Delete Spreadsheet Row using Lookup" Action to clear the data in the row. **Please Note:** If you want to use the "Delete using lookup" action, it is necessary to first use the "Lookup" action to search for a specific row in your spreadsheet based on a particular value. Once you have found the desired row using lookup, you can then use the "Delete using lookup" action to clear the row data. Therefore, using the lookup action prior to delete using lookup is a necessary step in this process. **Select Lookup Action** Only the Lookup Actions added above this action will be listed for selection. ![Delete Spreadsheet Row using Lookup. (image 30 of 30)](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/48294015593/original/DYActajsfztIVW8KP0Wj3xvdvzXFIPSCPA.gif) **Delete Spreadsheet Row using Lookup. (image 30 of 30)** This animation appears in the "Delete Spreadsheet Row using Lookup." section of "Guide to Google Sheets Premium Workflow Action". The text alongside this image reads: Only the Lookup Actions added above this action will be listed for selection. Immediately after, the guide continues: If a row is returned during a lookup, all the values associated with that row will be cleared. - What this covers: Only the Lookup Actions added above this action will be listed for selection. - Controls: Select Lookup Action - Next: If a row is returned during a lookup, all the values associated with that row will be cleared. If a row is returned during a lookup, all the values associated with that row will be cleared. #### **Points to Remember:**  - When you use the "Delete Spreadsheet Row" action, it clears the contents of the row, but it does not permanently remove the row itself. - If the Lookup Action does not return any rows, the workflow will skip this step and proceed to the next one. --- ## **Frequently Asked Questions** **Q: Can I update or delete all rows returned by a Lookup Multiple Spreadsheet Row(s) action?** The Lookup Multiple Spreadsheet Row(s) action is designed to retrieve and reference multiple rows at once. However, Google Sheets actions like **Update** and **Delete** are intended to work with **one row at a time**. These follow-up actions do not automatically loop through multiple results from a Lookup Multiple action. If your workflow requires updating or deleting multiple rows, you can implement custom logic using code actions or external automation tools that handle batch processing. This approach gives you greater control over how each row is processed while maintaining the flexibility of your workflow. --- Documentation for GHL Customer Care. Support: support@ghlcustomercare.com