# PromptRails + Google Sheets Integration

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

---

[promptrails](/)

[Website ↗](https://promptrails.ai)[Sign in](https://app.promptrails.ai/?utm_source=website&utm_medium=cta&utm_campaign=signup&utm_content=header_signin)[Get started →](https://promptrails.ai/company/contact)

[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](/mcp-tools)[Google Sheets API Reference](https://developers.google.com/sheets/api/reference/rest)

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