Merge lists
Combine two lists by matching items using a field from each list.
200+ apps to connect·Tested & maintained tasks·Human support in English & Spanish
In detail
What it does and what it's for
How it works
How it fits in an automated task
A Botize task pairs a trigger with one or more actions. This piece is one of them.
Pick a trigger
The event that starts the task, from this app or any other.
This action runs
Botize performs it automatically using the data the trigger delivers.
Turn it on and forget it
The task runs on its own from then on. If something's off, tweak it or we'll help you.
Setup
Customization options
Fields you can adjust when using it in your automation.
Output data
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.
Learn by watching
Video tutorials
Short videos where you watch a real task being built from start to finish.
Get inspired
Ready-to-use automations
Real tasks built with List merger: switch them on in minutes and tweak them to your liking.
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.
Need a hand?
Real people behind it
Email us
info@botize.com
Monday to Friday from 7 a.m. to 1 p.m. (Spain).
Message us on Telegram
t.me/botize
Monday to Friday from 7 a.m. to 1 p.m. (Spain).
Come with an idea.
Leave with an automation.
Create your first task in minutes. Do it once and forget about it forever.
Start automating