Automate tasks with Google Sheets
Connect Google Sheets with 200+ apps and let your tasks run themselves. Describe what you want and Botize builds it. No code.
Create a new spreadsheet and edit with others at the same time, from your computer, phone or tablet.
Triggers & actions
What can you automate with Google Sheets?
Everything you see below. Just pick a trigger and one or more actions.
Triggers
The trigger is the event that starts the automation.
-
Get the next new group rows according to a value
Extract 2 by 2 or 3 by 3 rows sequentially according to one or more filters you specify.
-
Extract the next new row
Extract one by one, sequentially, each row of a sheet.
-
Extract the next new rows from an SQL-like query
Iterates through the rows returned by an SQL query, one by one or in groups.
-
Extract the next new row according to a value (Deprecated)
Extract one by one, sequentially, each row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
- You can limit the search of the rows to a specific sheet or to all of them.
-
Extract the next new row according to a value
Extract one by one, sequentially, each row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
- You can limit the search of the rows to a specific sheet or to all of them.
Actions
The action is what happens automatically, without you having to do anything else.
-
Insert a new row at the top of a sheet
Move rows in a sheet to insert a new row at the beginning, allowing you to specify the values that each of the columns will take.
-
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.
-
Add a new sheet in a Document
Allows you to add a new sheet to an existing document, specifying the number of rows, columns, and a name for the sheet.
-
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
-
Clear a row
Clear the contents of a row in a Google Sheets spreadsheet.
-
Extract multiple rows and columns
Extract one or more specific rows and columns.
-
Count rows by column
Allows you to count the total rows in a specific column of a spreadsheet, applying optional filters such as exact matches or non-empty values.
-
Import a CSV file into a sheet
Import a CSV file into a spreadsheet, allowing you to specify the row and column of the spreadsheet to start the dump of data from the CSV file.
-
Extract multiple rows and columns as CSV
Extract one or more specific rows and columns as CSV.
-
Export CSV from a SQL-like query
Exports the result of a SQL-like query (Google Sheets QUERY / Google Visualization API) to a CSV file.
-
Get rows from a SQL-like query
Exports the result of a SQL-like query (Google Sheets QUERY / Google Visualization API) to object.
-
Get Google Sheets export URLs (PDF/CSV)
Given a Google Sheets document URL, returns the direct download URLs for its PDF and CSV exports.
-
Move a sheet to a new position
Move a sheet in a document containing two or more to a new position, modifying the order.
-
Find a row according to a column value
Extract first row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
- You can limit the search of the rows to a specific sheet or to all of them.
- If no row matches, this step still answers: the Row found tag is set to no and the task carries on. To stop the task in that case, add the rule “Row found = yes” on the next step. If your task predates this change, that rule is already in place — we added it so the task would keep behaving as before.
-
Extract CSV for first/last rows
Extract the first or last rows of a Google Sheets spreadsheet as CSV.
-
Get row data by number
Given a row number extract the values of each column.
-
Extract a random row
Extract randomly each row of a sheet.
- You can exclude rows that contain or do not contain certain words or values.
-
Extract a group of rows in CSV format
Extract first row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.
- You can limit the search of the rows to a specific sheet or to all of them.
-
Finds and replaces data in cells
Finds and replaces data in cells over a sheet or column.
- Case sensitive and insensitive matching.
- Match the entire cell content or part of a cell.
- Include or skip cells with formulas.
-
Update a row of a sheet
Update a specific row in a Google Sheets document, indicating the URL, sheet name or number, row number, and the values of the different columns that you want to update.
For AI assistants
Let your AI build your automations for Google Sheets
Claude, ChatGPT or Cursor can create, edit and fix these tasks by talking with you. They connect to your Botize account with this connector, and one install covers all 200+ apps:
https://webhook.botize.es/mcp
How to connect it, step by step
Included in your plan, at no extra cost.
The integration
About Google Sheets
This integration allows you to automate tasks in Google Sheets, facilitating the management and updating of your spreadsheets without manual intervention. With Botize, you can set up triggers and actions that execute automatically, optimizing your workflow and reducing errors.
Highlighted features include sequential row extraction, real-time data updating, and CSV file import. These tools enable you to keep your spreadsheets updated and organized efficiently, enhancing productivity and accuracy in your processes.
How it works
From idea to automation with Google Sheets
No flowcharts, no learning curve. You say it, it gets done.
Pick a trigger
The Google Sheets event that starts the task: a new message, a mention, a post…
Add actions
What happens next, in Google Sheets or in any of the 200+ connectable apps.
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.
Troubleshooting
Error messages and suggestions to fix it.
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.
PERMISSION_DENIED - Request had insufficient authentication scopes.
To resolve this, when adding a new profile in Botize for Google Sheets, select the option "View, edit, create, and delete all your Google Sheets spreadsheets" that appears. This will grant Botize the necessary permissions to properly operate with your spreadsheets.
Sheet name not found
The maximum size (7 MB) for a response has been exceeded
This usually happens when the spreadsheet contains too many rows, columns, or large amounts of text.
To solve this, you can:
1. Reduce the size of the Google Sheets document by removing unnecessary rows, columns, or content.
2. Use the method "Get rows from an SQL-like query" (
gspreadsheet.extract_object_by_sql_query), which allows more flexible queries and is not affected by the total size of the spreadsheet.Come with an idea.
Leave with an automation.
Create your first task with Google Sheets in minutes. Do it once and forget about it forever.
Start automating