Add a new row at the end of a sheet
Add a new row allowing you to specify the values that each of the columns will take. The first row of the sheet whose column 'A' is empty will be the one that receives 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 new rows at the end of a Google Sheets spreadsheet, specifying the values for each column. The first row in the sheet where column 'A' is empty will receive these values, facilitating the management and updating of your data without manual intervention.
With this functionality, you can optimize processes such as user information registration, inventory tracking, or any task that requires the constant addition of new data to spreadsheets. Customization of rules, filters, and sheet configuration provide flexibility to tailor it to your specific needs.
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
What is the purpose of the 'type' field when inserting data into Google Sheets from Botize?
When you add a new row to a spreadsheet from Botize, you can specify not only the value to be inserted into each cell, but also the data type of that cell.
This is very useful because Google Sheets interprets text, numbers, formulas, and dates differently. For example:
- If you enter a formula but don't mark the type as 'Formula', the cell will display the formula text (e.g., `=NOW()`) as plain text instead of executing it.
- If you send a date and time value but only want the date to appear in the sheet, you can choose a type like `Date DD-MM-YYYY` to display it in the desired format.
- If you have a timestamp (like `1713259854`), you can convert it into a human-readable date format by selecting a type like `Timestamp DD-MM-YYYY HH:MM`.
This field gives you full control over how each piece of data will be displayed in the spreadsheet, helping you avoid formatting issues or misinterpretations.
Common Errors
There's no data to add
Values, column names, or both have not been specified to save the information in the Google Sheets spreadsheet. Make sure to provide both the values and the necessary column names to complete the operation.
FAILED_PRECONDITION - This operation is not supported for this document
This error usually means that the file you're using is not in Google Sheets format, but instead saved as an XLSX (Excel) file.
To fix it, simply open the document in Google Drive and choose File > Save as Google Sheets. Once the file is in the correct format, Botize will be able to access it and run the automation properly.
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