Add a list of items to the end of a sheet
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
200+ apps to connect·Tested & maintained tasks·Human support in English & Spanish
In detail
What it does and what it's for
This integration allows you to automate the addition of item lists to the end of your Google Sheets spreadsheets. For each item in the list, a new row is created, assigning specific values to each column according to your needs. The first available row, where column 'A' is empty, will receive the new data.
This functionality is ideal for keeping your spreadsheets updated without manual intervention, facilitating efficient real-time data management.
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.
Already using Botize?
Connect your Google Sheets
Add a profile to use it in your tasks. There's a step-by-step guide if you need it.
Add a new profile Step-by-step guideYour profiles
Your connected Google Sheets accounts
These are the accounts you already have linked to Botize, ready to use in your tasks. You can reconnect or remove any of them.
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
- New Row Id {{new_row_id}}
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 Google Sheets: switch them on in minutes and tweak them to your liking.
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.
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