Anna 0.0.60: integration with Google Sheets

Anna 0.0.60: Personal Assistant with Google Sheets Integration and Business Mode

The personal assistant Anna in version 0.0.60 now integrates with Google Sheets to automate expense tracking. Users describe the table structure in plain language, and the system generates sheets with formulas to aggregate data automatically.

Example request to create a "March 2026 Expenses" spreadsheet:

Create a March 2026 expenses sheet with the following:
Sheet: Expense Log
Columns: Date, Expense Type, Amount
Sheet: Expenses by Type
Columns: Expense Type, Amount
Last row: TOTAL
Sheet: Expenses by Day
Columns: Date, Amount
Use formulas to link the second and third sheets to the Expense Log

Anna generates the spreadsheet using QUERY or SUMIF functions to connect the sheets. Data is added via voice or text from Telegram—messages are parsed, the current date is extracted, and entries are logged automatically. Formulas update dynamically without manual editing.

This functionality is powered by the Google Sheets API: OAuth authentication, batchUpdate for inserting rows, and dynamic formulas for real-time calculations.

Business Mode: Automating Client Appointments

A new business mode has been introduced for small businesses like barbershops, salons, and service providers. When launching, users choose between a personal agent or a business agent.

The database stores:

• A list of clients with contact info (Telegram/WhatsApp ID).
• A list of staff members with schedules.
• A booking calendar (date, time, client, staff member).

How it works:

• A client messages: "I need a haircut at 7 PM."
• Anna checks availability in the calendar and creates a slot.
• The staff member receives a message: "Client booked for 7 PM—confirm?"
• The staff member accepts or declines.
• Anna notifies the client of the status.

Supports adjustments: rescheduling appointments, replacing staff during absence. An admin panel lets you view conversations and simulate client/staff messages for testing.

Technical foundation: SQLite for local database storage, Telegram Bot API for messaging, cron-like tasks for reminders.

New Features in This Release

Added in just 10 days:

• Google Sheets API integration (create, update, formula support)
• Natural language parsing for expenses (regex + LLM for categorization)
• Business database with full CRUD operations
• Multi-agent chat: message routing between client → agent → staff
• Local deployment without registration (500 MB archive, unpack in ~10 seconds)
• Cloud mode via subscription (supports WhatsApp & Telegram)

Screenshots showcase the interfaces: expense tracker, calendar, chat views, and admin dashboard.

Key Points

• Personal mode: alpha stage — functional but may have bugs.
• Business mode: proof-of-concept — free to test, no payment required.
• Local setup is free; cloud access requires a subscription.
• Supported APIs: Google Sheets, Telegram, WhatsApp.
• Focus on automating routine tasks: expense tracking, bookings, notifications.

— Editorial Team