Google Sheets

What it does

This skill enables an AI agent to interact with Google Sheets data directly through the Google Sheets API. It allows agents to retrieve spreadsheet metadata (title, sheets), read cell values from specific ranges or entire sheets, write cell values, and append new rows to a sheet. The skill requires a valid GOOGLE_SHEETS_TOKEN for authentication.

When to use it

• Automating data extraction from Google Sheets for reporting purposes.
• Updating spreadsheet data based on external events or calculations.
• Appending new records to a Google Sheet as part of an automated workflow.
• Retrieving specific information from a Google Sheet to inform decision-making within the agent.
• Populating a Google Sheet with data generated by other skills or tools.

Key capabilities

• Retrieve spreadsheet metadata (title, sheet names).
• Read cell values from specified ranges in a sheet.
• Read all data from an entire sheet.
• Write/update cell values within a range of cells. Supports RAW and USER_ENTERED value input options.
• Append new rows to the end of a sheet.

Example prompts

• "Get the title and list of sheets in spreadsheet with ID [SPREADSHEET_ID]."
• "Read the values from cells A1:D10 in Sheet1 of spreadsheet [SPREADSHEET_ID]."
• "Append a new row to Sheet1 in spreadsheet [SPREADSHEET_ID] containing 'John Doe', '[email protected]', and 'Active'."

Tips & gotchas

• You need a valid GOOGLE_SHEETS_TOKEN for authentication. Refer to the troubleshooting section for checking connector status.
• The Spreadsheet ID is found in the URL of the Google Sheet (e.g., https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit).
• When writing data, you can choose between RAW and USER_ENTERED value input options; USER_ENTERED will evaluate formulas.