---

Triggers

The trigger is the event that starts the automation.

• 

  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

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.

• 

  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.

Troubleshooting

Error messages and suggestions to fix it.

• add"This operation is not supported for this document"
  If you receive this error message, it may be because your spreadsheet saved in Google Drive is in a different format than Google Spreadsheets, for example Excel format.
  
  To fix this, open the document in Google Sheets and save it with a new name. This will save the new file in Spreadsheets format and you can use it from Botize.