ChatGPT
Claude
Gemini
WhatsApp
Google Sheets
Google Forms
Google DocsA restaurant chain in Mumbai with six outlets, or a clinic chain in Pune with four branches, usually gets its daily numbers as WhatsApp photos of registers. The owner then spends the evening retyping them. This guide sets up a simpler flow: one Google Form that every outlet fills in, one linked Google Sheet, and an AI assistant that writes the summary. No developer is needed.
What you need
- A Google account for the business, with access to Google Sheets and Google Forms.
- A list of outlets with the manager's name for each one.
- The daily numbers you already track: sales in ₹ split into cash, card and UPI, footfall or covers, stock-outs, complaints and staff absences.
- ChatGPT, Claude or Gemini. Any one of them will do.
Step 1: Build one Google Form for all outlets
Create a Form with the same questions for every outlet. Add a dropdown for the outlet name, a date field, number fields for cash, card and UPI sales, a number field for footfall, and a short text box for issues. Keep the questions identical for every outlet so the Sheet stays clean. Ask one manager per outlet to submit it before closing.
Step 2: Link the Form to a Google Sheet
Open the Form, go to the Responses tab and click the green Sheets icon. Choose to create a new spreadsheet. Every submission now lands as a new row. A third-party walkthrough of this step is How to link Google Forms to Google Sheets.
Step 3: Add totals with Gemini in Sheets
Gemini in Google Sheets can create tables, write formulas and summarise content from the sheet itself. Open the spreadsheet, click Ask Gemini at the top right, and either pick a suggested prompt or write your own. Gemini in Sheets is available through a Gemini for Google Workspace add-on or Google One AI Premium, so check what your account includes. Google's help page is Gemini in Google Sheets.
Look at the responses in this sheet. Add a column called Total sales that adds cash, card and UPI for each row. Add a column called Sales per footfall that divides total sales by footfall. Make the header row bold and freeze it.
Step 4: Group the issues with the AI function
The issue text box will fill up with lines like "AC not working", "short staff at lunch" and "customer shouted at billing". Google's Workspace team describes an =AI function in Sheets that runs an instruction on each cell. Google's announcement is Workspace feature drop: AI in Sheets. Check that your account has it, then type this into the cell next to the first issue and fill it down:
=AI("Classify this issue into one of: equipment, staffing, stock, customer complaint, other. Reply with the category name only.", [issue cell])
Step 5: Write the nightly summary
Each evening, copy the day's rows from the sheet and paste them into ChatGPT, Claude or Gemini as plain text, with the column headers in the first line.
Below are today's rows from our outlet report, one row per outlet. The columns are outlet, manager, cash sales, card sales, UPI sales, footfall and issues. Write a summary the owner can read on WhatsApp in under 150 words. Start with total sales in ₹ and the best and weakest outlet by sales per footfall. Then list each outlet on its own line with its main issue. Do not invent numbers. If an outlet has no row, say that it did not report. Rows: [paste rows]
Step 6: Send it to the owners' group
Copy the summary into a WhatsApp group for owners and managers. Keep it to one message. If you send it every night, save the opening lines as a WhatsApp Business quick reply, so you only edit the numbers. Quick replies are inserted by typing a slash and a shortcut. Sending the summary automatically from the sheet needs a WhatsApp Business API provider and approved message templates, which is a bigger project than this guide covers.
Step 7: Check the totals once a week
Compare the sheet total with the cash-up or the POS report for two or three days. AI tools can slip on long lists, and a manager can type a number into the wrong box. A short weekly check catches both before the owner relies on the numbers.
Tips
- Put the deadline in the form title, for example "Submit by 9 pm".
- Use a dropdown for outlet names, never free text. A typo in an outlet name breaks the summary.
- Keep one Sheet for all outlets. Separate sheets for each branch make the nightly summary harder to build.
- Lock the form questions once they are set, so nobody edits them by accident.
- Ask the summary to name any outlet that did not report. That makes the deadline visible to managers.
Keep it safe
Staff names and customer complaints are personal information. Share the Sheet only with owners and managers, and remove customer names from the issue box. Do not paste bank statements, POS exports with card details or salary data into a personal chat account. Use the business account, and review the Sheet's sharing settings once a month.
Sources
More for Multi-location businesses: see what AI can do for your industry →
