google-sheets

What it does

This skill allows AI agents to interact with Google Sheets, enabling them to read data from spreadsheets and write new data. It can retrieve specific cells or ranges of cells based on user requests and update existing cell values with provided information. The agent can also create new sheets within a specified spreadsheet.

When to use it

• Data Reporting: Automatically extract key metrics from a Google Sheet and summarize them in a report.
• Inventory Management: Update stock levels in an inventory sheet based on sales data received from another system.
• Lead Tracking: Add new leads with contact information to a lead tracking spreadsheet.
• Project Task Updates: Update the status of tasks listed in a project management Google Sheet.

Key capabilities

• Read cell values from specified ranges within a Google Sheet.
• Write data into specific cells within a Google Sheet.
• Create new sheets inside an existing Google Spreadsheet.
• Access and modify spreadsheets based on their names or IDs.

Example prompts

• "Get the value in cell A1 of 'Sales Data' sheet."
• "Update cell B5 in the 'Inventory' sheet to 25."
• "Create a new sheet named 'Monthly Report' in my spreadsheet."

Tips & gotchas

• Ensure the AI agent has appropriate permissions (access) to the Google Sheet. You may need to share the sheet with the agent’s associated Google account.
• Specify the exact sheet name; incorrect names will result in errors.