Add a new row at the end of a sheet

Google Sheets

Action

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.


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


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.

Write us

By email or by Telegram.
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Let's talk

Choose day and time.
We share the screen and answer all your questions.