Premium Triggers and Actions - Google Sheets - Lookup Multiple Rows

Google Sheets is a versatile tool for managing data, and with each update, it becomes more powerful. One of the recent additions to its capabilities is the ability to perform a lookup across multiple rows, enhancing your workflow efficiency. This new feature allows users to retrieve multiple rows of data from Google Sheets based on specified criteria, opening up a range of possibilities for data analysis and manipulation.

How to Use the Feature

Using the "Lookup Multiple Sheets Row" action in Google Sheets within HUXLEY is straightforward. Here's a step-by-step guide:

1. Access Workflow: Begin by accessing the workflow section within HUXLEY platform. This is where you can create and manage automated processes.

2. Add Action: In the workflow editor, click the plus icon to add a new action.

3. Select Google Sheets Action: From the list of available actions, choose the Google Sheets action category.This is a premium action.

4. Specify Details: Select the Google account connected to your Sheets, followed by the appropriate drive, spreadsheet, and worksheet containing the data you want to access.

5. Choose Search Options: You'll now have the option to define your search criteria, such as the starting point within the sheet, the specific values to look for, and whether to consider case sensitivity.

6. Set Row Limit: Determine how many rows you want the action to retrieve based on your search criteria.

7. Additional Options: Explore additional options like creating a new spreadsheet row if the desired data doesn't exist.

8. Update Multiple Spreadsheet Row(s) Action:

Select "Update Multiple Spreadsheet Row(s)" from the Action dropdown menu within your workflow setup.Account and Spreadsheet Selection:Choose the integrated Google account from which you want to access the spreadsheet.Select the drive containing your spreadsheet.Choose the specific spreadsheet and worksheet where you want to update data.Specify Row Range:

Enter the starting row number from which you would like to update the sheet.

Select Start and End Columns:Determine the start and end columns within the worksheet where your data should be updated.Our system automatically considers the first row of the sheet as the header row, ensuring accurate mapping of data to the correct columns.Refresh Headers:If necessary, click the "Refresh Headers" button to fetch the latest header values from the sheet.This ensures that your data is correctly mapped to the appropriate columns, keeping your workflow up-to-date with the latest sheet configurations.

1. Publish Workflow: Once configured, publish your workflow to activate the feature.

NOTE:For an in-depth overview of Workflow Testing see our article, “Using the Testing Features in Workflows”

2. Execute: Once all parameters are set, execute the action to retrieve the specified rows from Google Sheets.

Benefits of the Feature

The ability to lookup multiple rows in Google Sheets brings several benefits to CRM users:

1. Enhanced Data Extraction: Instead of being limited to retrieving a single row of data, users can now extract multiple rows based on specified criteria, allowing for more comprehensive data analysis.
2. Improved Lead Management: With the ability to find leads that match specific criteria across multiple rows, CRM users can streamline lead management processes and identify valuable prospects more efficiently.
3. Increased Workflow Flexibility: By enabling users to operate on multiple rows of data simultaneously, this feature enhances workflow flexibility, making it easier to perform bulk actions and automate repetitive tasks.
4. Enhanced Data Manipulation: Whether it's categorizing data, segmenting leads, or performing actions based on specific values, the ability to lookup multiple rows facilitates more granular data manipulation within Google Sheets.

FAQs

1. What is the "Lookup Multiple Sheets Row" action in Google Sheets?

The "Lookup Multiple Sheets Row" action allows users to retrieve multiple rows of data from Google Sheets based on specified search criteria. This feature enhances data analysis and manipulation by enabling users to work with multiple rows simultaneously.

2. How do I access and set up the "Lookup Multiple Sheets Row" action in HUXLEY?

• Access Workflow: Log in to your HUXLEY account and navigate to the workflow section.
• Add Action: In the workflow editor, click the plus icon to add a new action.
• Select Google Sheets Action: Choose the Google Sheets action category (note that this is a premium action).
• Specify Details: Select your connected Google account, followed by the drive, spreadsheet, and worksheet containing the data.
• Choose Search Options: Define your search criteria, including the starting point, specific values, and case sensitivity.
• Set Row Limit: Specify how many rows you want to retrieve based on your search criteria.
• Additional Options: Explore options like creating a new spreadsheet row if the desired data doesn't exist.

3. What steps are involved in updating multiple spreadsheet rows?

• Select Action: Choose "Update Multiple Spreadsheet Row(s)" from the Action dropdown menu in the workflow setup.
• Account and Spreadsheet Selection: Choose the integrated Google account, drive, spreadsheet, and worksheet.
• Specify Row Range: Enter the starting row number for updating.
• Select Start and End Columns: Define the start and end columns where data should be updated.
• Refresh Headers: Click the "Refresh Headers" button to fetch the latest header values if necessary.
• Publish Workflow: After configuration, publish your workflow to activate the feature.

4. Can I retrieve data from multiple worksheets within a single workflow?

Yes, you can specify the worksheet within the Google Sheets action to retrieve data from different worksheets. Ensure that each worksheet is correctly selected based on your workflow requirements.

5. What happens if the desired data does not exist in the specified range?

You have the option to create a new spreadsheet row if the desired data does not exist. This ensures that your workflow can handle cases where data might not be present in the existing rows.

6. How do I ensure accurate mapping of data to columns when updating rows?

• Specify Columns: Clearly define the start and end columns where the data should be updated.
• Refresh Headers: Click the "Refresh Headers" button to get the latest header values from the sheet, ensuring that data maps correctly to the columns.

7. What are the benefits of using the "Lookup Multiple Sheets Row" feature?

• Enhanced Data Extraction: Retrieve multiple rows based on criteria for more comprehensive data analysis.
• Improved Lead Management: Efficiently identify and manage leads that meet specific criteria.
• Increased Workflow Flexibility: Perform bulk actions and automate repetitive tasks more easily.
• Enhanced Data Manipulation: Facilitate more granular manipulation of data for tasks such as categorizing and segmenting.

8. How do I test the workflow before publishing?

Refer to the article “Using the Testing Features in Workflows” for an in-depth overview of workflow testing. Testing ensures that your workflow operates as expected before deploying it live.

9. Can I use this feature for tasks other than lead management?

Yes, the "Lookup Multiple Sheets Row" feature can be used for various data-related tasks such as categorizing information, segmenting data, or performing bulk updates and actions across multiple rows of data.

Updated on: 11/21/2025