Automate tasks with Google Sheets
Create a new spreadsheet and edit with others at the same time, from your computer, phone or tablet.
https://spreadsheets.google.com
Troubleshooting
Error messages and suggestions to fix it.
Triggers

If it contains rows, select the next
Extract one by one, sequentially, each row of a sheet.

If it contains rows, select the next x rows
Extract 2 by 2 or 3 by 3 rows sequentially.

If it contains rows, select the next x rows according to a value
Extract 2 by 2 or 3 by 3 rows sequentially according to one or more filters you specify.

If it contains rows, select a random one
Extract randomly each row of a sheet.
 You can exclude rows that contain or do not contain certain words or values.

If it contains rows, select next 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.

If it contains rows, select next 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.

If it contains rows, select a group (CSV)
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

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.

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

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 CSV by column

Count rows by column
Related automations
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site:
Copy & paste this code to share the formula on your site: