Merge lists
Combine two lists by matching items using a field from each list.
List merger Action
Customization Options
Configurable fields you can adjust in your automation
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
-
Merged list
{{merged_list}}
The resulting list after combining Input 1 and Input 2.
Frequently Asked Questions
How can I get the real Google Sheets row number in the results?
This method uses Google Sheets’ query system based on GViz (Google Visualization Query Language). This system allows you to filter, sort, and limit rows, but it does not return the actual physical row number of the spreadsheet.
For this reason, even if a query returns only a few rows scattered across the sheet, the system cannot know the exact row where each one is located in the original document.
The recommended solution is to add an extra column to your Google Sheets document that contains the row number. To do this:
- 1. Add a new column to your sheet (you can keep it hidden if you like).
- 2. In that column, enter the formula
=ROW(). - 3. Make sure to include that column in your GViz query.
Let's talk
Choose day and time.
We share the screen and answer all your questions.