Add a list of items to the end of a sheet
Google Sheets
Action
Create a new row for each element, allowing you to specify the values that each of the columns will take. The first row of the sheet whose 'A' column is empty will be the one to receive the values
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
- New Row Id {{new_row_id}}
Frequently Asked Questions
How do I add a list of items (simple values or objects) to a Google Sheets spreadsheet?
When importing a list into Google Sheets, there are two possible scenarios:
1. List of simple values (text, URLs, numbers, etc.)
- In the column where you want to save the list, enter the column letter(s) (e.g., A).
- In the
valuefield, enter the full tag containing the list, such as{{urls}}. - The system will create one row for each item in the list and place its value in that column.
2. List of objects (each item has multiple keys, such as
title, price, description, etc.)- Create as many columns as the number of keys you need (e.g., “Title”, “Price”, “Description”).
- For each column, write the corresponding letter(s), and in the
valuefield, specify the key you want to save:
{{title}}for the “Title” column,
{{price}}for “Price”,
{{description}}for “Description”. - One row will be inserted for each object in the list, and each cell will receive the value of the corresponding key.
This allows you to import both simple and complex lists without overwriting data, keeping each element well-structured.
Let's talk
Choose day and time.
We share the screen and answer all your questions.