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.
200+ apps to connect·Tested & maintained tasks·Human support in English & Spanish
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.
-
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.
-
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 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 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.
-
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.
Actions
The action is what happens automatically, without you having to do anything else.
-
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.
-
Get Google Sheets export URLs (PDF/CSV)
Given a Google Sheets document URL, returns the direct download URLs for its PDF and CSV exports.
-
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.
-
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
-
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.
-
Get 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.
-
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.
-
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.
-
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 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.
-
Move a sheet to a new position
Move a sheet in a document containing two or more to a new position, modifying the order.
-
Clear a row
-
Extract CSV for first/last rows
-
Get row data by number
Given a row number extract the values of each column.
-
Extract multiple rows and columns as CSV
Extract one or more specific rows and columns as CSV.
-
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.
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.
This error occurs because the Google account connected to Botize does not have sufficient permissions.
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
In the automatic task, you specified a sheet name that does not exist in the corresponding Google Sheets document. Edit the automatic task and verify that the sheet name exactly matches an existing sheet in your Google Sheets document, paying attention to possible typographical errors and case sensitivity.
The maximum size (7 MB) for a response has been exceeded
The query sent to Google Sheets is returning more than 7 MB of data, exceeding the maximum response size supported by the Google Sheets API.
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