# PromptRails + Google Sheets Integration

Source: https://0.0.0.0:8080/integrations/google-sheets

---

[All Integrations](/integrations)

![Google Sheets](/images/logos/google-sheets.svg)

# 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

[Documentation](/docs/mcp-tools)[Google Sheets API Reference](https://developers.google.com/sheets/api/reference/rest)

[Get Started](https://app.promptrails.ai)