# Google Sheets

Botize app — id `gspreadsheet`. Official site: https://spreadsheets.google.com.

Create a new spreadsheet and edit with others at the same time, from your computer, phone or tablet.

Botize automates tasks between this app and 200+ other services. A task is one trigger followed by one or more actions.

## Account

Requires connecting a Google Sheets account in Botize. The user links it once and Botize stores the credentials; an assistant never handles them.
- Connect: https://botize.com/en/app/gspreadsheet/authenticate

## Triggers (5)

The event that starts the task. Exactly one per task.

- `read_n_rows_by_column` — Get the next new group rows according to a value
  https://botize.com/en/method/gspreadsheet/read_n_rows_by_column.md
- `read_row` — Extract the next new row
  https://botize.com/en/method/gspreadsheet/read_row.md
- `read_rows_by_sql` — Extract the next new rows from an SQL-like query
  https://botize.com/en/method/gspreadsheet/read_rows_by_sql.md
- `search_row_by_column` — Extract the next new row according to a value (Deprecated)
  https://botize.com/en/method/gspreadsheet/search_row_by_column.md
- `search_row_by_column_v2` — Extract the next new row according to a value
  https://botize.com/en/method/gspreadsheet/search_row_by_column_v2.md

## Actions (20)

What happens next. A task can chain several.

- `add_row` — Insert a new row at the top of a sheet
  https://botize.com/en/method/gspreadsheet/add_row.md
- `add_row_to_end` — Add a new row at the end of a sheet
  https://botize.com/en/method/gspreadsheet/add_row_to_end.md
- `add_sheet` — Add a new sheet in a Document
  https://botize.com/en/method/gspreadsheet/add_sheet.md
- `append_list_of_rows` — Add a list of items to the end of a sheet
  https://botize.com/en/method/gspreadsheet/append_list_of_rows.md
- `clear_row` — Clear a row
  https://botize.com/en/method/gspreadsheet/clear_row.md
- `column_to_array` — Extract multiple rows and columns
  https://botize.com/en/method/gspreadsheet/column_to_array.md
- `count_rows_by_column` — Count rows by column
  https://botize.com/en/method/gspreadsheet/count_rows_by_column.md
- `csv_to_sheet` — Import a CSV file into a sheet
  https://botize.com/en/method/gspreadsheet/csv_to_sheet.md
- `extract_csv_by_column` — Extract multiple rows and columns as CSV
  https://botize.com/en/method/gspreadsheet/extract_csv_by_column.md
- `extract_csv_by_sql_query` — Export CSV from a SQL-like query
  https://botize.com/en/method/gspreadsheet/extract_csv_by_sql_query.md
- `extract_object_by_sql_query` — Get rows from a SQL-like query
  https://botize.com/en/method/gspreadsheet/extract_object_by_sql_query.md
- `get_pdf_export_url` — Get Google Sheets export URLs (PDF/CSV)
  https://botize.com/en/method/gspreadsheet/get_pdf_export_url.md
- `move_sheet_position` — Move a sheet to a new position
  https://botize.com/en/method/gspreadsheet/move_sheet_position.md
- `read_by_column` — Find a row according to a column value
  https://botize.com/en/method/gspreadsheet/read_by_column.md
- `read_first_last_rows` — Extract CSV for first/last rows
  https://botize.com/en/method/gspreadsheet/read_first_last_rows.md
- `read_number_row` — Get row data by number
  https://botize.com/en/method/gspreadsheet/read_number_row.md
- `read_random_row` — Extract a random row
  https://botize.com/en/method/gspreadsheet/read_random_row.md
- `read_range_rows` — Extract a group of rows in CSV format
  https://botize.com/en/method/gspreadsheet/read_range_rows.md
- `search_replace` — Finds and replaces data in cells
  https://botize.com/en/method/gspreadsheet/search_replace.md
- `update_row_by_number` — Update a row of a sheet
  https://botize.com/en/method/gspreadsheet/update_row_by_number.md


## How to build this

An AI assistant (Claude, ChatGPT, Cursor…) can create and edit these tasks in the user's account through the Botize MCP connector, included in every plan:

    https://webhook.botize.es/mcp

- Connection guide: https://botize.com/en/mcp
- Agent map: https://botize.com/llms.txt
- New account: https://botize.com/en/join (500 free operations, no card)

---
Machine-readable summary for AI assistants. Human version: https://botize.com/en/app/gspreadsheet