Google Sheets
www.google.comUse Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
What your agent can do
Add a single row to a Google Sheet. By default the row is appended to the end. To INSERT the row at a specific position instead — pushing the rows at and below that position DOWN without overwriting them — set Row Index (e.g. Row Index 2 inserts directly below a header row). Use this tool (not… Full schema: https://pipedream.com/apps/google-sheets/actions/add-single-row.md
Via MCP.
Tasks depend on the interface and permissions.
Connection methods
Choose a route that fits your agent.
MCP
For compatible agent apps
an access token
View setup for MCPAPI
For custom integrations
an access token
View paths for APIMCP connection
MCP server URL
https://remote.mcp.pipedream.net/v3- Authentication
- Provide the Pipedream Connect access token and the documented project, environment, external-user and app-slug headers; provider account connection may be required.
POST https://remote.mcp.pipedream.net/v3
API connection
API path
https://api.pipedream.com/v1/connect/{project_id}/proxy/aHR0cHM6Ly9zaGVldHMuZ29vZ2xlYXBpcy5jb20v?external_user_id={external_user_id}&account_id=apn_xxxxxxx- Authentication
- Send a Pipedream Connect access token; Pipedream forwards the connected account credentials to the upstream provider.
View sources and checks
- MCP · Use the Pipedream MCP tool Add Single Row (Write) for Google Sheets: Add a single row to a Google Sheet. By default the row is appended to the end. To INSERT the row at a specific position instead — pushing the rows at and below that position DOWN without overwriting them — set Row Index (e.g. Row Index 2 inserts directly below a header row). Use this tool (not… Full schema: https://pipedream.com/apps/google-sheets/actions/add-single-row.md
- API · Proxy a request to a provider endpoint using a connected account.