Skip to main content
The @guildai-services/guildai~google-sheets package gives your agents access to Google Sheets spreadsheets through Guild’s Google Sheets integration.

​
Authentication

  • Type: OAuth 2.0
  • Token management: Refreshed automatically

​
Setup

1

Open Credentials

Go to Credentials in Guild.
2

Connect Google Sheets

Click Google Sheets and authorize with your Google account.

​
Usage

import { googleSheetsTools } from "@guildai-services/guildai~google-sheets"
import { llmAgent } from "@guildai/agents-sdk"

export default llmAgent({
  description: "An agent that reads and writes spreadsheet data",
  tools: { ...googleSheetsTools },
})

​
Selecting specific tools

Tools are named with the google_sheets_ prefix. Use pick() to include only what your agent needs. 
import { googleSheetsTools } from "@guildai-services/guildai~google-sheets"
import { llmAgent, pick } from "@guildai/agents-sdk"

export default llmAgent({
  description: "An agent that updates a tracking spreadsheet",
  tools: {
    ...pick(googleSheetsTools, [
      "google_sheets_spreadsheets_values_get",
      "google_sheets_spreadsheets_values_update",
      "google_sheets_spreadsheets_values_append",
    ]),
  },
})