Google Sheets
Gives your Botonom agent a durable working surface: it creates Google Sheets, appends and updates rows, and reads ranges, so records survive beyond the chat.
We start with What Google Sheets does for you, move on to What it can do, cover How to use it, and wrap up with Good to know.
What Google Sheets does for you
The Google Sheets skill gives your Botonom agent a place to write things down. Chat is where work happens, but results scroll away; a spreadsheet is where records live. With this skill your agent creates spreadsheets, appends every new lead or order as a row, reads ranges back when you ask, and keeps summary cells up to date.
It uses your company's Google connection (the same one Google Analytics uses), so setup is one connect.
What it can do
Once connected and assigned to an agent:
- Create spreadsheets. New sheets with named tabs, straight from chat, link returned.
- Append rows. Leads, orders, expenses, log lines: one row per record, always at the end.
- Read ranges. Any range in A1 notation ("Sayfa1!A1:D50"), returned clean and capped.
- Update cells. Fix a value or refresh a summary block in place.
- Add tabs. Grow one workbook instead of scattering files.
The strongest pattern is Sheets + scheduled tasks: "every Friday at 17:00, write this week's sales into the summary sheet" becomes a task you can see and edit in your Calendar, and the numbers land in the same spreadsheet every week.
How to use it
1. Install it. Open the Skill Marketplace, find Google Sheets under Productivity, and click Install.
2. Connect Google. If your company connected Google before Sheets existed, reconnect once so the connection gains the Sheets permission.
3. Just ask. Talk to the agent in normal language:
User: Create a spreadsheet called "Sales Tracker" with tabs Leads and Summary.
Agent: Done. Here is the link: docs.google.com/spreadsheets/d/... I set Leads and Summary tabs.
User: Add this lead: Ali Kaya, 0555 111 22 33, from Instagram.
Agent: Added to the Leads tab as a new row.
User: What is in the summary tab?
Agent: Summary!A1:C4 shows: total leads 42, this week 7, conversion 12%.
Good to know
- Which sheets it can touch: anything the connected Google account can open (by link or id), plus sheets it creates itself.
- Caps keep it safe: reads return at most 200 rows per call (narrow the range for big sheets); writes take up to 500 rows per call.
- Team-wide by design: reading and writing sheets is available to staff roles and above; sheets are an internal working surface, not outbound messaging.
- Data stays in your Google account. Botonom stores the connection token encrypted and touches only the sheets you point it at.