Apps/Google Sheets/Add a new row at the end of a sheet
Google Sheets
Google Sheets Action

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 guide

Your 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.

Rules
Filters (Apply rules only if these are met)
URL of your sheet document
Columns
Sheet selection mode
Sheet Number
Sheet name

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.

  • type
  • rss β†’ rss_new
  • gspreadsheet β†’ add_row_to_end
Save each new NASA news item in Sheets
  • type
  • trabber β†’ one_destination
  • gspreadsheet β†’ add_row_to_end
Tracking in a spreadsheet of flight offers departing from Madrid
  • type
  • telegrambot β†’ webhook
  • gspreadsheet β†’ add_row_to_end
Save each new Telegram message to Google Sheets
  • type
  • amazon_associates β†’ search_by_category
  • gspreadsheet β†’ add_row_to_end
Save every new product from an Amazon category
  • type
  • paypal β†’ new_transaction
  • gspreadsheet β†’ add_row_to_end
Record every transaction in Google Sheets
  • type
  • twitter β†’ twitter_search
  • gspreadsheet β†’ add_row_to_end
Save every new tweet that exceeds 50 RTs (only the most recent ones)
  • type
  • twitter β†’ twitter_search
  • gspreadsheet β†’ add_row_to_end
Look for potential users to follow. Save them in a spreadsheet
  • type
  • twitter β†’ twitter_search
  • gspreadsheet β†’ add_row_to_end
Search and save tweets with +50 replies and +100 faves
  • type
  • telegrambot β†’ webhook
  • gspreadsheet β†’ read_by_column
  • telegrambot β†’ reply
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ reply
Bot that searches for users in Google Sheets and responds with their data if they are in the database; if not, it adds them to the sheet
  • type
  • telegrambot β†’ webhook
  • gspreadsheet β†’ read_by_column
  • telegrambot β†’ reply
  • amazon_associates β†’ get_product_detail
  • fpages β†’ public_image
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ reply
Send publish followed by an ASIN code
  • type
  • telegrambot β†’ webhook
  • gspreadsheet β†’ read_by_column
  • telegrambot β†’ reply
  • telegrambot β†’ reply
  • amazon_associates β†’ get_product_detail
  • gspreadsheet β†’ add_row_to_end
Bot Adding Amazon products to Sheets
  • type
  • amazon_associates β†’ search_by_category
  • gspreadsheet β†’ add_row_to_end
Save every electronic product under €50 and free shipping
  • type
  • ebay β†’ search_fixed_price_product_by_keyword
  • gspreadsheet β†’ add_row_to_end
Save products found on eBay to Google Sheets
  • type
  • amazon_coupons β†’ search_coupons
  • amazon_associates β†’ get_product_detail
  • gspreadsheet β†’ add_row_to_end
Coupons from Amazon Spain to Google Sheets
  • type
  • amazon_coupons β†’ search_coupons
  • gspreadsheet β†’ add_row_to_end
Coupons from Amazon Spain to Google Sheets
  • type
  • telegrambot β†’ webhook_txtimgdoc
  • telegrambot β†’ ask
  • telegrambot β†’ ask
  • gspreadsheet β†’ add_row_to_end
Telegram bot to request 2 pieces of information from the user and save the responses in Google Sheets
  • type
  • amazon_lightning β†’ search_deals
  • gspreadsheet β†’ add_row_to_end
Save each new Amazon deal in Google Sheets
  • type
  • telegrambot β†’ webhook_command
  • amazon_associates β†’ get_product_detail
  • gspreadsheet β†’ add_row_to_end
Telegram bot that extracts and saves product data to Google Sheets when receiving a URL or ASIN
  • type
  • btzai β†’ get_next_message
  • gspreadsheet β†’ add_row_to_end
Log every new message from a bot's conversations in Google Sheets
  • type
  • btzmail β†’ webhook
  • gspreadsheet β†’ add_row_to_end
Log each new email you receive in your Botize mail account to Google Sheets
  • type
  • paidonresults β†’ csv_next_row
  • gspreadsheet β†’ add_row_to_end
Save each new product from a PaidOnResults.com merchant to Google Sheets
  • type
  • telegrambot β†’ webhook_voice_file
  • openai_whisper β†’ transcription
  • chatgpt β†’ completion_as_data
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ reply
Analyze voice messages received on Telegram, extract key data, and store it in Google Sheets.
  • type
  • whatsapp_cloud_api β†’ webhook_voice_message
  • whatsapp_cloud_api β†’ retrieve_media_url
  • openai_whisper β†’ transcription
  • chatgpt β†’ completion_as_data
  • gspreadsheet β†’ add_row_to_end
  • whatsapp_cloud_api β†’ post_message
Analyze voice messages received on WhatsApp, extract key data, and store it in Google Sheets.
  • type
  • whapi β†’ webhook_message
  • gspreadsheet β†’ add_row_to_end
Save every new message received on WhatsApp (via Whapi) to Google Sheets
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • gspreadsheet β†’ add_row_to_end
Save every new message received on WhatsApp to Google Sheets
  • type
  • btzimap β†’ get_mail
  • btzfilters β†’ process
  • btzsmtp β†’ send_mail
  • gspreadsheet β†’ add_row_to_end
Confirm received support emails and log them into Google Sheets
  • type
  • telegrambot β†’ webhook_command
  • btzscraper β†’ execute_commands
  • chatgpt β†’ completion_as_data
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ reply
Telegram bot that exports product data to Google Sheets from unstructured text
  • type
  • telegrambot β†’ webhook
  • btzloop β†’ repeater
  • chatgpt β†’ completion_as_data
  • btzflow β†’ get_flow_next_step
  • drive β†’ copy_file
  • gspreadsheet β†’ add_row_to_end
  • collect_list β†’ collect
  • telegrambot β†’ reply
Telegram conversational assistant to register products in new Google Sheets documents
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • whatsapp_cloud_api β†’ ask
  • whatsapp_cloud_api β†’ post_message
  • gspreadsheet β†’ add_row_to_end
WhatsApp question with options and automatic logging to Google Sheets
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • whatsapp_cloud_api β†’ ask
  • whatsapp_cloud_api β†’ ask
  • whatsapp_cloud_api β†’ post_message
  • gspreadsheet β†’ add_row_to_end
WhatsApp bot that asks the user for their age and email and saves it to Google Sheets
  • type
  • telegram_users β†’ bps_next_message_in_range
  • btztextparser β†’ get_urls
  • gspreadsheet β†’ add_row_to_end
Extract messages from a chat between two dates and save any URLs found to Google Sheets
  • type
  • telegrambot β†’ webhook
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ copy_message
Save each new Telegram message to Google Sheets and also copy it to another Telegram chat, group, or channel
  • type
  • telegram_users β†’ webhook_all
  • amazon_lightning β†’ replace_text_urls
  • btzfilters β†’ process
  • gspreadsheet β†’ add_row_to_end
Detect each new post in a third-party Telegram chat, modify any Amazon affiliate links it contains, and save it to Google Sheets
  • type
  • btzforms β†’ webhook_html_form_submission_create
  • gspreadsheet β†’ add_row_to_end
Manual logging of asset movements and saving to Google Sheets
  • type
  • btzforms β†’ webhook_html_form_submission_create
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ send_message_photo
Manual logging of asset movements, saving them to Google Sheets and publishing them to a Telegram chat
  • type
  • btzforms β†’ webhook_html_form_submission_create
  • whatsapp_cloud_api β†’ ask_location
  • gspreadsheet β†’ add_row_to_end
Logging WhatsApp users' locations in Google Sheets
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • chatgpt β†’ completion_as_data
  • gspreadsheet β†’ add_row_to_end
  • whatsapp_cloud_api β†’ post_message
WhatsApp assistant for order logging in Google Sheets and product inquiries
  • type
  • gnews β†’ rss_keyword
  • gspreadsheet β†’ add_row_to_end
Save each new Google News article related to a specific topic in Google Sheets
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • gcalendar β†’ search_available_slots
  • whatsapp_cloud_api β†’ ask
  • gcalendar β†’ search_available_slots
  • whatsapp_cloud_api β†’ ask
  • whatsapp_cloud_api β†’ ask
  • gspreadsheet β†’ add_row_to_end
  • gcalendar β†’ create_event
  • whatsapp_cloud_api β†’ post_message
WhatsApp bot for appointment booking with Google Calendar and logging in Google Sheets
  • type
  • telegram_users β†’ webhook_all
  • telegram_users β†’ get_post_files_urls
  • gspreadsheet β†’ add_row_to_end
Extract each new message from a third-party Telegram chat, group, or channel and store it in a Google Sheets spreadsheet
  • type
  • telegram_users β†’ bps_next_message_in_range
  • telegram_users β†’ get_post_files_urls
  • gspreadsheet β†’ add_row_to_end
Extracts every minute the next message between two specific dates from a third-party Telegram chat, group, or channel and saves it to a Google Sheets spreadsheet
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • chatgpt β†’ send_prompt
  • whatsapp_cloud_api β†’ post_message
  • gspreadsheet β†’ add_row_to_end
Telegram bot with ChatGPT that automatically saves conversations to Google Sheets
  • type
  • telegram_users β†’ bps_next_message_in_range
  • chatgpt β†’ completion_as_data
  • gspreadsheet β†’ add_row_to_end
Extract every message from a third-party Telegram chat between two specific dates, classify it with ChatGPT, and save the result in Google Sheets
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • btzfilters β†’ process
  • gspreadsheet β†’ add_row_to_end
  • whatsapp_cloud_api β†’ post_message
Save WhatsApp messages from a specific contact to Google Sheets and send a confirmation reply
  • type
  • whatsapp_cloud_api β†’ webhook_message
  • gspreadsheet β†’ add_row_to_end
  • whatsapp_cloud_api β†’ post_message
Save WhatsApp messages to Google Sheets and send a confirmation reply
  • type
  • iterator β†’ iterate
  • gspreadsheet β†’ add_row_to_end
Webhook that receives a list of data and saves each item as a separate row in Google Sheets
  • type
  • telegram_users β†’ webhook_all
  • btzfilters β†’ process
  • gspreadsheet β†’ add_row_to_end
Save each new message from a third-party Telegram chat to Google Sheets, classifying it based on its content
  • type
  • btzforms β†’ webhook_html_form_submission_create
  • whatsapp_cloud_api β†’ post_buttons_template
  • whatsapp_cloud_api β†’ ask
  • whatsapp_cloud_api β†’ post_message
  • gspreadsheet β†’ add_row_to_end
Form to trigger a bot that sends a WhatsApp template to a contact, asks them to choose an option, and stores the result in Google Sheets
  • type
  • telegrambot β†’ webhook
  • gspreadsheet β†’ add_row_to_end
Copy each new message received in a Telegram chat to a new row in Google Sheets, only if it is sent by one of the specified Telegram users
  • type
  • telegrambot β†’ webhook
  • btzfilters β†’ process
  • telegrambot β†’ ask
  • gspreadsheet β†’ add_row_to_end
  • telegrambot β†’ reply
Telegram bot that triggers when receiving the message β€œSORTEO”, records the user’s response in Google Sheets, and replies to the user
  • type
  • gforms β†’ get_next_new_response
  • gspreadsheet β†’ add_row_to_end
  • gmail β†’ send
  • telegrambot β†’ send_message_photo
Detects new submissions in Google Forms, saves them in Google Sheets, and sends notifications via email and Telegram
  • type
  • gmybusiness β†’ get_reviews
  • gspreadsheet β†’ add_row_to_end
Save all Google Business reviews to Google Sheets starting from the first one

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