Manage cookies
We use essential cookies to run the site and, with your consent, analytics and marketing cookies. Cookie Policy
Manage cookies
Cookie Settings
Cookies necessary for the correct operation of the site are always enabled.
Other cookies are configurable.
Essential cookies
Always On. These cookies are essential so that you can use the website and use its functions. They cannot be turned off. They're set in response to requests made by you, such as setting your privacy preferences, logging in or filling in forms.
Analytics cookies
Disabled
These cookies collect information to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you. See a list of the analytics cookies we use here.
Advertising cookies
Disabled
These cookies provide advertising companies with information about your online activity to help them deliver more relevant online advertising to you or to limit how many times you see an ad. This information may be shared with other advertising companies. See a list of the advertising cookies we use here.
AI assistant for Google Workspace — LLM integration for business productivity
AI assistant for Google Workspace — LLM integration for business productivity
AI assistant for Google Workspace — LLM integration for business productivity
AI assistant for Google Workspace — LLM integration for business productivity
Clutch top artificial intelligence company

Case Study: AI Assistant for Google Workspace

Case study on building an assistant that searches Gmail and Drive, retrieves the right context, and prepares safe reply drafts with human control.

Context and Goal

The client is a condominium management company handling daily operational communication with residents, suppliers, and property stakeholders. The team manages a high volume of emails and relies on Google Drive for storing invoices, meeting minutes, building regulations, technical documents, and historical communications.

The goal was to reduce time spent searching for the right information and improve response quality, while keeping full human control over sensitive replies.

The challenge

The hard part was not writing the reply

The real bottleneck was finding the right context quickly. Before anyone could answer, most requests needed four checks.

1

Find the document

An invoice, the minutes of a meeting, a regulation or a notice, somewhere in Drive.

2

Check past emails

Earlier threads with the same sender, to know what was already said.

3

Identify the building

From partial references: an address, a unit number, an internal code.

4

Reply safely

A professional answer, without missing details or making assumptions.

The assistant at work

From a new email to a ready draft

Pick a typical request and watch the assistant find the context and prepare a reply. The team always has the last word.

  1. 1A new email arrivesIt is read and classified. Newsletters, promotions and no-reply senders are skipped.
  2. 2Key details are extractedAddress, unit, supplier, invoice number and other references.
  3. 3Gmail and Drive are searchedPast threads with the sender, documents and attachments.
  4. 4A draft waits for approvalIt is saved in Gmail. Nothing is sent until a person approves it.

Example scenarios. Names, addresses and documents are invented.

Example scenarios. Names, addresses and documents are invented.

How it is built

An assistant that knows where to look

A human-in-the-loop assistant built on Google Workspace and an LLM (Gemini / Vertex AI).

Gmail integration

Reads incoming messages, classifies them and saves reply drafts.

Drive integration

Searches and reads the right files, even across non-linear folder structures.

Entity extraction

Recognises addresses, invoice numbers, building names and key references.

Safety rules

Newsletters, promotions and no-reply sources are excluded.

Search without manual indexing

No rigid spreadsheets: it searches directly where the information already is.

Drive folders and documentsPast email threadsAttachments and recurring document patterns

A person always approves

Emails are never sent automatically. The team reviews, edits and approves every draft.

Results

A digital colleague for the office

The assistant became a practical everyday tool: it finds the context and prepares replies ready for review.

Less time searching

A significant reduction in manual search time.

Consistent replies

More consistent and professional communication.

Fewer errors

Confirmation prompts when information is incomplete.

Ready to scale

The same workflow works across multiple condominiums and folder structures.

Technologies Used

Google Workspace (Gmail, Drive)
Google Apps Script automation
Gemini API / Vertex AI
Prompt engineering and security rules
Human-in-the-loop workflow design

Related Services

The services behind projects like this one.

AI Development & Integration

Add AI features into a product you already run or are building.

Learn more →

Workflow Automation

Your team repeats the same manual steps between tools every day.

Learn more →

AI Chatbot & Assistant

Visitors ask the same questions and nobody replies after hours.

Learn more →

API Development

Your CRM, payments and other systems need to share data automatically.

Learn more →

FAQ – AI Development

Ready to apply this to your workflow?

We work with leading AI providers and models, selecting the right technology based on the use case, data sensitivity, and cost structure:
Ai glass processor
Open-source and self-hosted models (when required)
Anthropic Claude
Azure OpenAI
Google Gemini
OpenAI (GPT-4 / GPT-4o, Assistants, embeddings)

Let’s design your Google Workspace assistant

European business hours
Chiara Mastino
Chiara Mastino
Commercial director
Schedule a call Calendly
or
Service
Let's talk
Development
Artifical intelligence
Cyber Security
Other
Budget in EUR
Up to 5K
5K–10K
10K–50K
more than 50K
By clicking the button
you confirm you have read our Privacy Policy
Something went wrong. Please try again.
✓

Request sent!

We'll get back to you within 1 business day.