Google Sheets
Arcade.dev LLM tools for Google Sheets.
Arcade.dev provides LLM tools for Google Sheets, enabling seamless interactions with spreadsheet data through API integration. This toolkit allows developers to automate tasks, manage files, and enhance user experience in Google Sheets.
Capabilities
- Create and manage spreadsheets with flexible data formats.
- Retrieve and update cell contents efficiently.
- Access user profile information and permissions.
- Generate file picker URLs for user-driven file selection and authorization.
OAuth
- Provider: Google
- Scopes:
https://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/userinfo.emailhttps://www.googleapis.com/auth/userinfo.profile
Secrets
- No secret types or names are specified.
Available tools(9)
| Tool name | Description | Secrets | |
|---|---|---|---|
Add a note to a specific cell in a spreadsheet. A note is a small
piece of text attached to a cell (shown with a black triangle) that
appears when you hover over the cell.
sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned,
then always assume the default sheet_position is sufficient. | |||
Create a new spreadsheet with the provided title and data in its first sheet
Returns the newly created spreadsheet's id and title | |||
Generate a Google File Picker URL for user-driven file selection and authorization.
This tool generates a URL that directs the end-user to a Google File Picker interface where
where they can select or upload Google Drive files. Users can grant permission to access their
Drive files, providing a secure and authorized way to interact with their files.
This is particularly useful when prior tools (e.g., those accessing or modifying
Google Docs, Google Sheets, etc.) encountered failures due to file non-existence
(Requested entity was not found) or permission errors. Once the user completes the file
picker flow, the prior tool can be retried.
Suggest this tool to users when they are surprised or confused that the file they are
searching for or attempting to access cannot be found. | |||
Gets the specified range of cells from a single sheet in the spreadsheet.
sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned,
then always assume the default sheet_position is sufficient. | |||
Gets the metadata for a spreadsheet including the metadata for the sheets in the spreadsheet.
Use this tool to get the name, position, ID, and URL of all sheets in a spreadsheet as well as
the number of rows and columns in each sheet.
Does not return the content/data of the sheets in the spreadsheet - only the metadata.
Excludes spreadsheets that are in the trash. | |||
Searches for spreadsheets in the user's Google Drive based on the titles and content and
returns the title, ID, and URL for each matching spreadsheet.
Does not return the content/data of the sheets in the spreadsheets - only the metadata.
Excludes spreadsheets that are in the trash. | |||
Write values to a Google Sheet using a flexible data format.
sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned,
then always assume the default sheet_position is sufficient. | |||
Get comprehensive user profile and Google Sheets environment information.
This tool provides detailed information about the authenticated user including
their name, email, profile picture, Google Sheets access permissions, and other
important profile details from Google services. | |||
Write a value to a single cell in a spreadsheet. |
Selected tools
No tools selected.
Click "Show all tools" to add tools.
Requirements
Select tools to see requirements
GoogleSheets.AddNoteToCell
Add a note to a specific cell in a spreadsheet. A note is a small piece of text attached to a cell (shown with a black triangle) that appears when you hover over the cell. sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned, then always assume the default sheet_position is sufficient.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to add a comment to |
column | string | Required | The column string to add a note to. For example, 'A', 'F', or 'AZ' |
row | integer | Required | The row number to add a note to |
note_text | string | Required | The text for the note to add |
sheet_position | integer | Optional | The position/tab of the sheet in the spreadsheet to write to. A value of 1 represents the first (leftmost/Sheet1) sheet. Defaults to 1. |
sheet_id_or_name | string | Optional | The id or name of the sheet to write to. If provided, takes precedence over sheet_position. |
Requirements
Output
json— The status of the operationGoogleSheets.CreateSpreadsheet
Create a new spreadsheet with the provided title and data in its first sheet Returns the newly created spreadsheet's id and title
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
title | string | Optional | The title of the new spreadsheet |
data | string | Optional | The data to write to the spreadsheet. A JSON string (property names enclosed in double quotes) representing a dictionary that maps row numbers to dictionaries that map column letters to cell values. For example, data[23]['C'] would be the value of the cell in row 23, column C. Type hint: dict[int, dict[str, Union[int, float, str, bool]]] |
Requirements
Output
json— The created spreadsheet's id and titleGoogleSheets.GenerateGoogleFilePickerUrl
Generate a Google File Picker URL for user-driven file selection and authorization. This tool generates a URL that directs the end-user to a Google File Picker interface where where they can select or upload Google Drive files. Users can grant permission to access their Drive files, providing a secure and authorized way to interact with their files. This is particularly useful when prior tools (e.g., those accessing or modifying Google Docs, Google Sheets, etc.) encountered failures due to file non-existence (Requested entity was not found) or permission errors. Once the user completes the file picker flow, the prior tool can be retried. Suggest this tool to users when they are surprised or confused that the file they are searching for or attempting to access cannot be found.
Parameters
No parameters required.
Requirements
Output
json— Google File Picker URL for user file selection and permission grantingGoogleSheets.GetSpreadsheet
Gets the specified range of cells from a single sheet in the spreadsheet. sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned, then always assume the default sheet_position is sufficient.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to get |
sheet_position | integer | Optional | The position/tab of the sheet in the spreadsheet to get. A value of 1 represents the first (leftmost/Sheet1) sheet . Defaults to 1. |
sheet_id_or_name | string | Optional | The id or name of the sheet to get. Defaults to None, which means sheet_position will be used instead. |
start_row | integer | Optional | Starting row number (1-indexed, defaults to 1) |
start_col | string | Optional | Starting column letter(s) or 1-based column number (defaults to 'A') |
max_rows | integer | Optional | Maximum number of rows to fetch for each sheet in the spreadsheet. Must be between 1 and 1000. Defaults to 1000. |
max_cols | integer | Optional | Maximum number of columns to fetch for each sheet in the spreadsheet. Must be between 1 and 100. Defaults to 100. |
Requirements
Output
json— The spreadsheet properties and data for the specified sheet in the spreadsheetGoogleSheets.GetSpreadsheetMetadata
Gets the metadata for a spreadsheet including the metadata for the sheets in the spreadsheet. Use this tool to get the name, position, ID, and URL of all sheets in a spreadsheet as well as the number of rows and columns in each sheet. Does not return the content/data of the sheets in the spreadsheet - only the metadata. Excludes spreadsheets that are in the trash.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to get metadata for |
Requirements
Output
json— The spreadsheet metadata for the specified spreadsheetGoogleSheets.SearchSpreadsheets
Searches for spreadsheets in the user's Google Drive based on the titles and content and returns the title, ID, and URL for each matching spreadsheet. Does not return the content/data of the sheets in the spreadsheets - only the metadata. Excludes spreadsheets that are in the trash.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_contains | array<string> | Optional | Keywords or phrases that must be in the spreadsheet title. Provide a list of keywords or phrases if needed. |
spreadsheet_not_contains | array<string> | Optional | Keywords or phrases that must NOT be in the spreadsheet title. Provide a list of keywords or phrases if needed. |
search_only_in_shared_drive_id | string | Optional | The ID of the shared drive to restrict the search to. If provided, the search will only return spreadsheets from this drive. Defaults to None, which searches across all drives. |
include_shared_drives | boolean | Optional | Whether to include spreadsheets from shared drives. Defaults to False (searches only in the user's 'My Drive'). |
include_organization_domain_spreadsheets | boolean | Optional | Whether to include spreadsheets from the organization's domain. This is applicable to admin users who have permissions to view organization-wide spreadsheets in a Google Workspace account. Defaults to False. |
order_by | array<string> | Optional | Sort order. Defaults to listing the most recently modified spreadsheets first. If spreadsheet_contains or spreadsheet_not_contains is provided, then the order_by will be ignored.createdTimecreatedTime descfolderfolder descmodifiedByMeTimemodifiedByMeTime descmodifiedTimemodifiedTime descnamename descname_naturalname_natural descquotaBytesUsedquotaBytesUsed descrecencyrecency descsharedWithMeTimesharedWithMeTime descstarredstarred descviewedByMeTimeviewedByMeTime desc |
limit | integer | Optional | The maximum number of spreadsheets to list. Defaults to 10. Max is 50 |
pagination_token | string | Optional | The pagination token to continue a previous request |
Requirements
Output
json— A dictionary containing the title, ID, and URL for each matching spreadsheet. Also contains a pagination token if there are more spreadsheets to list.GoogleSheets.UpdateCells
Write values to a Google Sheet using a flexible data format. sheet_id_or_name takes precedence over sheet_position. If a sheet is not mentioned, then always assume the default sheet_position is sufficient.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to write to |
data | string | Required | The data to write. A JSON string (property names enclosed in double quotes) representing a dictionary that maps row numbers to dictionaries that map column letters to cell values. For example, data[23]['C'] is the value for cell C23. This is the same format accepted by create_spreadsheet. Type hint: dict[int, dict[str, int | float | str | bool]] |
sheet_position | integer | Optional | The position/tab of the sheet in the spreadsheet to write to. A value of 1 represents the first (leftmost/Sheet1) sheet. Defaults to 1. |
sheet_id_or_name | string | Optional | The id or name of the sheet to write to. If provided, takes precedence over sheet_position. |
Requirements
Output
json— The status of the operation, including updated ranges and countsGoogleSheets.WhoAmI
Get comprehensive user profile and Google Sheets environment information. This tool provides detailed information about the authenticated user including their name, email, profile picture, Google Sheets access permissions, and other important profile details from Google services.
Parameters
No parameters required.
Requirements
Output
json— Get comprehensive user profile and Google Sheets environment information.GoogleSheets.WriteToCell
Write a value to a single cell in a spreadsheet.
Parameters
| Parameter | Type | Req. | Description |
|---|---|---|---|
spreadsheet_id | string | Required | The id of the spreadsheet to write to |
column | string | Required | The column string to write to. For example, 'A', 'F', or 'AZ' |
row | integer | Required | The row number to write to |
value | string | Required | The value to write to the cell |
sheet_name | string | Optional | The name of the sheet to write to. Defaults to 'Sheet1' |
Requirements
Output
json— The status of the operation