Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Start for freeCategory
Works with
AI Compatible
Tools
Create Column
Create a new column in a spreadsheet. See the documentation Return only the translated text without explanations.
Add Conditional Format Rule
Create conditional formatting with color scales or custom formulas. See the documentation
Add Multiple Rows
Add multiple rows of data to a Google Sheet. See the documentation
Add Protected Range
Add edit protection to cell range with permissions. See the documentation
Add Single Row
Add a single row of data to Google Sheets. Optionally insert the row at a specific index (e.g., row 2 to insert after headers, shifting existing data down). See the documentation Return only the translated text without explanations.
Clear Cell
Delete the content of a specific cell in a spreadsheet. See the documentation
Clear Rows
Delete the content of a row or rows in a spreadsheet. Deleted rows will appear as blank rows. See the documentation Return only the translated text without explanations.
Copy Worksheet
Copy an existing worksheet to another Google Sheets file. See the documentation Return only the translated text without explanations.
Create Spreadsheet
Create a blank spreadsheet or duplicate an existing spreadsheet. See the documentation
Create Worksheet
Create a blank worksheet with a title. See the documentation Return only the translated text without explanations.
Delete Conditional Format Rule
Remove conditional formatting rule by index. See the documentation
Delete Rows
Deletes the specified rows from a spreadsheet. See the documentation
Delete Worksheet
Delete a specific worksheet. See the documentation Return only the translated text without explanations.
Find Row
Find one or more rows by a column and value. See the documentation Return only the translated text without explanations.
Get Cell
Fetch the contents of a specific cell in a spreadsheet. See the documentation Return only the translated text without explanations.
Get Current User
Retrieve Google Sheets account metadata for the authenticated user by calling Drive's about.get, returning the user profile (display name, email, permission ID) and storage quota information. Helpful when you need to verify which Google account is active, tailor sheet operations to available storage, or give an LLM clear context about the user identity before composing read/write actions. See the Drive API documentation.
Get Spreadsheet by ID
Returns the spreadsheet at the given ID. See the documentation for more information
Get Values in Range
Get all values or values from a range of cells using A1 notation. See the documentation Return only the translated text without explanations.
Insert an Anchored Note
Insert a note on a spreadsheet cell. See the documentation
Insert Comment
Insert a comment into a spreadsheet. See the documentation Return only the translated text without explanations.
Insert Dimension
Insert a dimension into a spreadsheet. See the documentation Return only the translated text without explanations.
List Worksheets
Get a list of all worksheets in a spreadsheet. See the documentation
Merge Cells
Merge a range of cells into a single cell. See the documentation Return only the translated text without explanations.
Move Dimension
Move a dimension in a spreadsheet. See the documentation
Set Data Validation
Add data validation rules to cells (dropdowns, checkboxes, date/number validation). See the documentation
Update Cell
Update a cell in a spreadsheet. See the documentation
Update Conditional Format Rule
Modify existing conditional formatting rule. See the documentation
Update Formatting
Update the formatting of a cell in a spreadsheet. See the documentation
Update Multiple Rows
Update multiple rows in a spreadsheet defined by a range. See the documentation
Update Row
Update a row in a spreadsheet. See the documentation Return only the translated text without explanations.
Upsert Row
Upsert a row of data in a Google Sheet. See the documentation Return only the translated text without explanations.