google.com

•

One-click Login

•

Ready to use

About Google Sheets

Google Sheets is a browser-based spreadsheet application that allows multiple users to edit simultaneously with full version history. It integrates natively with Google Drive, Forms, and Data Studio, and supports formulas, pivot tables, charts, and scripting via Google Apps Script. In 2026, Gemini AI is bundled into Workspace plans, enabling natural-language data analysis and formula generation directly in Sheets.

AI Agent Use Cases

- Real-time multi-user collaboration with comment and suggestion modes

- Google Apps Script automation and macro recording

- Pivot tables, charts, and conditional formatting

- Native integration with Google Forms, Data Studio, and BigQuery

- Gemini AI for formula suggestions and natural-language data queries (Workspace plans)

- Offline editing with automatic sync on reconnect

Available Actions

These are the specific actions that AI agents can perform with this tool

Append Values to Google Sheet

5 inputs

Appends values to a specified range in a Google Sheet.

Inputs

spreadsheetId

The unique identifier of the Google Sheet to which data will be appended.

range

The range in the Google Sheet where new values will be appended.

valueInputOption

Specifies how the input data will be added to the sheet (e.g., USER_ENTERED, RAW).

insertDataOption

Defines how existing data is changed when new data is input (e.g., OVERWRITE, INSERT_ROWS).

includeValuesInResponse

If true, the response includes the values that were appended.

Append Values to Spreadsheet

7 inputs

Appends values to a spreadsheet.

Inputs

spreadsheetId

The ID of the spreadsheet that you want to update.

range

The A1 notation of the range in which you want to append values.

valueInputOption

Specifies how the input data should be interpreted (e.g., RAW or USER_ENTERED).

insertDataOption

Specifies how existing data is changed when new data is input (e.g., OVERWRITE or INSERT_ROWS).

includeValuesInResponse

Determines if the update response should include the values of the cells that were appended.

responseValueRenderOption

Determines how values in the response should be rendered.

responseDateTimeRenderOption

Determines how dates, times, and durations in the response should be rendered.

Copy And Paste Cell Formatting

2 inputs

Copies formatting from one cell range and pastes it to another range within a Google Sheet.

Inputs

SPREADSHEET_ID

The ID of the spreadsheet containing the source and destination ranges.

SHEET_ID

The ID of the sheet where the copy and paste operation should occur.

Copy Sheet To Another Spreadsheet

4 inputs

Copies an existing sheet from one Google Spreadsheet to another, including all values, formatting, and formulas.

Inputs

spreadsheetId

The unique ID of the spreadsheet containing the sheet to be copied.

sheetId

The ID of the sheet in the source spreadsheet that will be copied.

destinationSpreadsheetId

The unique ID of the spreadsheet where the new copied sheet will be created.

access_token

OAuth 2.0 Bearer token used to authenticate the request; must have appropriate Google Sheets API scopes.

Create Spreadsheet

1 input

Creates a new sheet

Inputs

title

The title of the spreadsheet to create

Find Spreadsheet Id

1 input

Finds a unique spreadsheet ID from a given URL.

Inputs

spreadsheetUrl

The URL of the Google Spreadsheet from which the ID will be extracted.

Get Authenticated User Basic Profile Info

3 inputs

Retrieves basic profile details such as names, emails, and photos for the authenticated Google user.

Inputs

resourceName

The resource name of the person to provide information about. Use 'people/me' to indicate the authenticated user.

personFields

A mask to restrict which fields on the person resource are returned. Must specify at least one field; multiple fields are separated by commas. If omitted, the API returns a 400 error.

sources

A comma-separated list specifying the data sources to return. Defaults to READ_SOURCE_TYPE_PROFILE and READ_SOURCE_TYPE_CONTACT if not set. Optional parameter.

Get Authenticated User Personal Info

3 inputs

Retrieves profile details for the authenticated user, including name, email, photo, organizations, phone numbers, and addresses.

Inputs

resourceName

Resource name of the person to provide information about. To get data for the authenticated user, specify 'people/me'.

personFields

Field mask specifying which person fields to return, separated by commas. Required and must be at least one valid field (e.g., 'names,emailAddresses').

sources

Mask of what source types to return. If unset, defaults to profile and contact sources. Values should be provided as a repeated query parameter (sources=...).

Get Current User Contact Details

2 inputs

Retrieves the authenticated user's names, email addresses, and profile photos from their Google account.

Inputs

resourceName

The resource name of the person to provide information about; use 'people/me' to refer to the authenticated user.

personFields

A field mask that selects which data fields are returned in the response (e.g., 'names,emailAddresses,photos'). Multiple fields are separated by commas and must be chosen from the API's allowed values.

Get Developer Metadata

2 inputs

Retrieves developer metadata from the specified Google Sheets document using its unique metadata ID.

Inputs

spreadsheetId

The ID of the spreadsheet to retrieve metadata from.

metadataId

The ID of the developer metadata to retrieve.

Get Google User Profile Information

1 input

Retrieves basic profile information about the authenticated Google user using an access token.

Inputs

access_token

The OAuth 2.0 access token used to authenticate and authorize the API request. This must be included as a Bearer token in the Authorization header, and must have the appropriate userinfo or OpenID scopes.

Get My Basic Profile Details

3 inputs

Retrieves the authenticated user's basic profile information including names, email addresses, and profile photos.

Inputs

resourceName

The resource name of the person to provide information about. Use 'people/me' to indicate the authenticated user.

personFields

Specifies which fields on the person resource to return. Must be a comma-separated list of fields such as 'names,emailAddresses,photos'.

sources

Optional. Restricts returned sources. If omitted, defaults to profile and contact sources. Usually not required for basic profile details.

Get My Basic Profile Info

2 inputs

Retrieves the authenticated user's basic profile information including their names, email addresses, and profile photos.

Inputs

resourceName

The resource name of the person whose information is to be retrieved. For the current authenticated user, this must be 'people/me'.

personFields

Specifies which fields on the person resource to include in the response. Must be a comma-separated list of valid fields such as 'names', 'emailAddresses', and 'photos'. Omitting this will result in a 400 error.

Get My Contact Names Emails and Phones

1 input

Retrieves the authenticated user's own profile information including names, email addresses, and phone numbers.

Inputs

personFields

A required comma-separated string specifying which person fields to include in the response. Must be a list of valid field names supported by the People API, such as 'names', 'emailAddresses', 'phoneNumbers', etc.

Get My Contact Profile Details

2 inputs

Retrieves the authenticated user's own profile information including names, email addresses, phone numbers, and addresses.

Inputs

personFields

A comma-separated list of person field names specifying which fields to return for the person resource. At least one valid field name must be specified. Common values include 'names', 'emailAddresses', 'phoneNumbers', and 'addresses'.

access_token

The OAuth 2.0 access token used for authenticating the request, provided in the 'Authorization' header as 'Bearer <access_token>'. Must be a valid token with scope for People API.

Get My Google Profile Names And Emails

2 inputs

Retrieves the names and email addresses of the authenticated user's Google profile.

Inputs

resourceName

The resource name of the person whose profile is being retrieved; use 'people/me' to reference the currently authenticated user.

personFields

A comma-separated list specifying which fields to include in the response, such as 'names,emailAddresses'; must be non-empty or the request will fail with a 400 error. Allowed values are specific field names defined in the API.

Get Sheet Data From Range

2 inputs

Fetches values from a specific range in a Google Sheet

Inputs

Spreadsheet ID

The ID of the spreadsheet to retrieve data from

Range A1 Notation

The range of cells to read from, in A1 notation

Get Spreadsheet

3 inputs

Retrieves the details of a specific Google Sheet using its ID.

Inputs

spreadsheetId

The ID of the spreadsheet to be requested.

ranges

The ranges to retrieve from the spreadsheet using A1 notation.

includeGridData

If true, grid data should be returned. Ignored if a field mask is set.

Get Spreadsheet Data By Filter

3 inputs

Retrieves specific spreadsheet data based on given filters.

Inputs

spreadsheetId

The ID of the spreadsheet to retrieve.

dataFilters

The filters to select which ranges to retrieve.

includeGridData

Include grid data in the response if true.

Get Spreadsheet Structure Metadata

1 input

Retrieve metadata of a specific spreadsheet structure.

Inputs

spreadsheetId

The unique identifier for the spreadsheet from which to retrieve structure metadata.

Get Spreadsheet Values

2 inputs

Retrieves the values from a specified range in a Google Spreadsheet.

Inputs

spreadsheetId

The ID of the spreadsheet to retrieve values from.

range

The A1 notation of the range to retrieve values from.

Get Structural Metadata

2 inputs

Retrieve structural metadata for a specific web page.

Inputs

url

The URL of the web page from which to retrieve structural metadata.

language

The preferred language for the structured data.

Rename Sheet

3 inputs

Rename a specific sheet within a Google Spreadsheet

Inputs

SPREADSHEET_ID

The ID of the spreadsheet containing the sheet to rename. This is found in the URL of the spreadsheet.

SHEET_ID

The ID of the specific sheet to rename within the spreadsheet. This can be obtained via the spreadsheets.get method.

newTitle

The new title for the sheet.

Search Spreadsheets MetaData

2 inputs

Retrieve all metadata entries matching specific criteria from a Google Sheets spreadsheet.

Inputs

spreadsheetId

The ID of the spreadsheet from which to retrieve metadata.

dataFilters

The data filters that describe the criteria used to select which DeveloperMetadata entries to return.

Spreadsheet Batch Update

5 inputs

Applies multiple updates to a Google spreadsheet in a single request.

Inputs

spreadsheetId

The ID of the spreadsheet to apply updates to.

requests

A list of update requests to apply to the spreadsheet. Each request is executed in sequence.

includeSpreadsheetInResponse

Determines if the update response should include the spreadsheet resource.

responseRanges

Specifies the ranges included in the response spreadsheet. Applies only if includeSpreadsheetInResponse is true.

responseIncludeGridData

Indicates if grid data should be returned. Relevant only if includeSpreadsheetInResponse is true.