sheets-cli

What it does

The sheets-cli skill allows users to interact with Google Sheets directly from a command line interface (CLI). It enables reading existing data within a sheet, writing new values into specific cells, and appending entire rows of data. This provides a programmatic way to manage spreadsheet content without needing to open the Google Sheets web application.

When to use it

• A user asks to retrieve the current sales figures from a particular sheet.
• The user wants to automatically update inventory levels in a spreadsheet after receiving shipment information.
• You need to append new customer data received from an external source into a Google Sheet.
• A request comes in to modify a specific cell containing project deadlines.

Key capabilities

• Read data from Google Sheets cells and ranges.
• Write values to individual cells within a sheet.
• Append rows of data to the end of a spreadsheet.
• Update existing cells with new information.

Example prompts

• "Get the value in cell A1 of my 'Sales Data' sheet."
• "Add a new row to 'Customer List' with these details: John Doe, [email protected], 555-1234."
• "Update cell B5 in 'Project Timeline' to reflect the new deadline of October 27th."

Tips & gotchas

• Requires proper authentication and authorization with Google Sheets API for access. Ensure you have set up credentials correctly before use.
• The skill’s functionality is limited to what can be achieved through the Google Sheets API; complex formatting or advanced features may not be supported.