Manage Google Sheets data with AI
Read a selected range, append a row or edit spreadsheet data under the permissions of your work account.
To manage Google Sheets data with AI, give gws-sheets the particular tab and range that hold the records you need. The guide exposes operations for reading values, creating spreadsheets and applying updates, alongside a row-append helper. A daily dispatch log is a useful case because the new figures should follow the order of an established set of columns.
Tell the agent whether the request adds a new observation or corrects a previous one. Those are different changes to a shared register. Reading the header row first can prevent an order count from landing in the neighbouring returns column when somebody has rearranged the sheet.
What it does
- Read only the range relevant to the question
- Inspect column headings before preparing a new row
- Append a dated entry to a working register
- Create a spreadsheet for a new collection of data
- Apply a requested change to a chosen range
Install and use
- Install the skill, gws and its shared guidance. Connect an account with permission to read the target spreadsheet and edit it when changes are required.
- Ask “Read the headers on Dispatch and prepare today's new row in that order. Show it to me before appending.”
- Read back the affected cells. Take particular care with amounts or descriptions containing commas so one value remains in its intended cell.
FAQ
Source
Made by Google Workspace CLI contributors. Original skill: gws-sheets, published on GitHub under the Apache-2.0 licence.
View on GitHub