Google Sheets

Use Google Sheets with Agno agents.

Enable Agno agents to read, create, update and duplicate Google Sheets.

Prerequisites

• To use a service account for access to Google Sheets, provide the absolute path to the service account file either using the service_account_path arg in the GoogleSheetsTools constructor or specify the GOOGLE_SERVICE_ACCOUNT_FILE environment variable.

• Add the complete auth URL as an authorised redirect URIs for the Client ID in the Google Cloud Console. For example, to use Localhost and port 8080, specify: http://localhost:8080/flowName=GeneralOAuthFlow and pass the oauth_port to Google Sheets Toolkit.

"""

Google Sheets Toolkit can be used to 

Example spreadsheet: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/
The ID is the URL of the spreadsheet and the range is the sheet name and the range of cells to read.

"""

from agno.agent import Agent
from agno.tools.googlesheets import GoogleSheetsTools

# ---------------------------------------------------------------------------
# Create Agent
# ---------------------------------------------------------------------------


SAMPLE_SPREADSHEET_ID = "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"
SAMPLE_RANGE_NAME = "Class Data!A2:E"

google_sheets_tools = GoogleSheetsTools(
    spreadsheet_id=SAMPLE_SPREADSHEET_ID,
    spreadsheet_range=SAMPLE_RANGE_NAME,
    oauth_port=8080,  # or any other port
)

agent = Agent(
    tools=[google_sheets_tools],
    instructions=[
        "You help users interact with Google Sheets using tools that use the Google Sheets API",
        "Before asking for spreadsheet details, first attempt the operation as the user may have already configured the ID and range in the constructor",
    ],
)

# ---------------------------------------------------------------------------
# Run Agent
# ---------------------------------------------------------------------------
if __name__ == "__main__":
    agent.print_response("Please tell me about the contents of the spreadsheet")

Run the Example

# Clone and setup repo
git clone https://github.com/agno-agi/agno.git
cd agno/cookbook/91_tools

# Create and activate virtual environment
./scripts/demo_setup.sh
source .venvs/demo/bin/activate

python googlesheets_tools.py

For details, see Google Sheets cookbook.