PromptRails
All Integrations
Google Sheets

Google Sheets

Google

Read, write, and manage Google Sheets spreadsheets. Your agents can analyze data, update cells, create formulas, and build data-driven reporting workflows.

How to Connect

  1. 1Go to the MCP Templates marketplace.
  2. 2Find the Google Sheets template.
  3. 3Enter your Google service account credentials.
  4. 4Add the template to your agent.

Available Tools

gsheets_get_values

Get values from a range in a Google Sheets spreadsheet

gsheets_update_values

Write values to a range in a Google Sheets spreadsheet

gsheets_append_values

Append rows to a Google Sheets spreadsheet

gsheets_list_sheets

List all sheets (tabs) in a Google Sheets spreadsheet

gsheets_get_metadata

Get metadata for a Google Sheets spreadsheet

gsheets_create_spreadsheet

Create a new Google Sheets spreadsheet