For the complete documentation index, see llms.txt. This page is also available as Markdown.

google sheets

The Google Sheets tool lets your AI agent read from and write to a Google Sheets spreadsheet. You add it on the Prompt & Tools page, choose which actions the agent may use, and tell the agent when to use it.

Prerequisites

  • An AI agent. See Create your first AI Agent.

  • The integration must be turned on by your partner. If it is not, the tool is not shown to you. [CHECK: confirm how a customer can tell, and who to ask.]

  • A Google account and a spreadsheet.

  • Edit access to AI Agents. [CHECK: permissions are not part of the PRD. Confirm the role needed.]

Key definitions

Term
Meaning

Tool

Something your agent can use to take an action.

Action

One thing a tool can do. You turn each action on or off with Allowed.

Usage instructions

Your words that tell the agent when to use the tool and what to do.

Connected account

The account of the other service. You connect it once and reuse it for other agents.

What the Google Sheets tool can do

Action
What it does

Create sheet

Creates a new sheet.

Read rows

Looks up rows.

Add row

Adds a new row.

Update sheet

Changes values in the sheet.

Delete row

Removes a row.

You fill in these fields when you set up the tool:

  • Connection (your Google account)

  • Spreadsheet

  • Sheet tab

Steps

  1. Open Prompt & Tools under Setup in the AI Agent sidebar. Click Add tool. In the Add tools window, find Google Sheets. You can search for it, or look under External tools. Click it.

Find Google Sheets in the Add tools window
  1. On the Connect step, choose the account you want. If you have none, click Connect another account and sign in without leaving the page. Click Continue.

Choose the account for Google Sheets
  1. On the Configure step, fill in: Spreadsheet; Sheet tab. Turn on the actions you want the agent to use. Under "How should the agent use Google Sheets?", write when the agent should use the tool and what it should do. This is required.

  2. Click Add tool. The button stays grey until the required fields are filled. The tool now shows under Connected tools with an Active label. Click Done, then click Update to save the page.

Example usage instructions

Use this when the customer asks to book a table. Add a row with their name, date and party size.

Write your own in the same way: say when to use the tool, then what to do.

Change or remove the tool

Under Connected tools, click the gear icon to open the tool's settings again. Click the delete icon to remove it. You are asked to confirm. Deleting removes the tool and its usage instructions from the agent. The connected account stays, so other agents can still use it.

Common errors

The agent does not use the tool

Check that the tool shows Active under Connected tools. Check that the action you need is allowed. Make your usage instructions clearer about when to use the tool.

I cannot save the tool

The usage instructions are required. Fill them in. Also fill in the other required fields.

I do not see Google Sheets in the Add tools window

Your partner may not have turned this integration on. Ask your partner or account owner.

The Continue button is grey

Choose an account first. If you have none, click Connect another account.

Can I use the same account for more than one agent?

Yes. Connected accounts belong to your account, so other agents can use them.

What happens if I delete the tool?

The agent can no longer use it, and its usage instructions are removed. Text about the tool in your prompt stays, so remove it too.

[CHECK: the PRD lists the actions and inputs of this tool but not its screen text, limits or error messages. Confirm these with the dev team before publishing.]

[CHECK: existing customers have the old settings of this tool moved into the agent prompt, with the right action turned on. Confirm what customers should know about this move.]

Support

Still not working? Write to us at support@botpenguin.com. We will reach out to you within 24 hours.