Query, append, and visualize Google Sheets data straight from WhatsApp
Google Sheets is the cloud spreadsheet used by millions of teams for reporting, tracking, and collaborative data management. The LunoGen Google Sheets integration connects your AI agent to the Sheets API v4 so it can read ranges, append rows, run formulas, update cells, and generate charts from spreadsheets — all driven from WhatsApp.
Spreadsheets are the world's universal database, but they live inside a browser tab. LunoGen brings them into WhatsApp. Log conversations automatically, ask the agent natural-language questions about your data, append expenses or leads from chat, and get visualized reports on demand — without ever opening a sheet.
In Google Cloud Console, create a project (or reuse one), then enable the Google Sheets API under APIs & Services.
Open Credentials → New → Google Sheets in LunoGen and sign in with OAuth. Approve the Sheets and Drive read/write scopes.
Pin the spreadsheets the agent should know about (e.g. 'Leads', 'Expenses', 'Inventory') so it can resolve them by name.
In each sheet, create named ranges for common queries — e.g. Sales!Revenue, Inventory!Stock. The agent uses these for stable lookups.
Send the agent 'How many leads did we get last week from the Leads sheet?' to confirm the integration is live.
Every customer conversation on WhatsApp gets parsed and logged as a row — contact, intent, sentiment, agent reply, timestamp — so your team has a searchable record without copy-pasting.
Thread closed. Parsing intent and sentiment, then appending to the Conversations sheet...
Ask the agent plain-English questions about any spreadsheet. It builds the right formula or reads the right range and returns the answer on WhatsApp in seconds.
Show me the top 10 sales from last month in the Sales 2026 sheet
Reading Sales 2026 → tab 'March', filtering by date and sorting by amount...
Log expenses, leads, time entries, or any structured input by just texting the agent. It parses the fields, appends the row, and confirms with a running total.
Log expense: $42.80 lunch with Samir from Brightline, today, category client meetings, paid with Amex
Parsing and appending to the Expenses 2026 sheet...
Ask for a chart in plain English. The agent reads the right range, renders a clean PNG, and sends it back to WhatsApp — ready for a deck or a Slack thread.
Chart our weekly signups from the Growth sheet for the last 12 weeks. Line chart.
Reading Growth → tab 'Weekly', range B2:B14. Rendering a line chart...
A Monday morning cron job reads the previous week's rows, runs aggregations (sum, avg, top N), and delivers a tidy summary to WhatsApp — perfect for OKR tracking and team updates.
Reading 'OKRs 2026 Q2' → tab 'Weekly' for the previous week's rows...
Your warehouse team maintains stock in a Google Sheet. Sales reps ping the agent from WhatsApp with a SKU, and the agent returns live availability, location, and last restock date.
Stock on WDG-PRO-V2 and WDG-LITE?
Querying 'Warehouse Stock' → tab 'Live' on the SKU column...
Run your Notion workspace from WhatsApp — create pages, query databases, and answer questions from your wiki
Query Airtable bases in natural language, add records from chat, and get daily reports on WhatsApp
Search, share, and organize Drive files from WhatsApp with an AI agent
Run your calendar from WhatsApp — agenda briefs, reminders, and event creation by AI
Replace 15 Zaps with one AI agent — catch any webhook, reason, and act
Turn WhatsApp bug reports into Linear issues, get cycle reports, and route customer bugs to the right team
Spin up an AI agent in under 2 minutes, plug in your Google Sheets credentials, and start running your workflows from WhatsApp.