Google Workspace Office Suite: Best of AI in Docs, Sheets, Slides, Drive & Vids

Google Sheets: =AI() Function, Formulas & Smart Fill

Generate complex XLOOKUP/QUERY formulas from plain English, categorise thousands of messy text rows simultaneously with the =AI() cell formula, and spot job-costing or GST anomalies in seconds.

Google Docs: @Drive Grounded Proposal Drafting

Type @ inside any Google Doc to pull facts from client emails, meeting notes, and rate cards in your Drive — drafting complete statements of work, variations, and SOPs in your exact house style.

Google Vids: AI Training & SOP Video Studio

Turns a written Google Doc SOP or prompt into a complete multi-scene training or onboarding video with scripts, screen recordings, stock visuals, and realistic AI voiceovers.

Google Drive & Slides: Folder Q&A and Imagen 3

Ask Drive questions across an entire project folder of 30 PDFs without opening individual files, and generate brand-safe presentation slides and visuals with Imagen 3.

Trades & Field Services

50-staff civil & landscaping contractor (Bay of Plenty)

Bottleneck: Written Health & Safety SOPs were ignored by seasonal crew, and project managers spent Sunday nights formatting progress reports.

Workflow: Converted machinery SOPs into 2-minute visual induction videos in Google Vids watched on phones, and used Gemini in Sheets/Docs to summarise weekly site diaries.

Outcome: 100% induction completion and 4 hours saved per project manager every week.

Professional Services

25-staff chartered accounting practice (Wellington)

Bottleneck: Preparing quarterly management commentary from raw Xero CSV exports took 3 hours of senior advisor time per client.

Workflow: Used Gemini in Sheets to isolate variance drivers across exported trial balances, then referenced the sheet in Docs to draft plain-English director commentary.

Outcome: Cut quarterly reporting preparation time by 55% across 120 clients.

Wholesale & Operations

30-staff hospitality equipment distributor (Auckland)

Bottleneck: Supplier price lists arrived in messy spreadsheets that took 3 days to clean and rewrite for their ecommerce website.

Workflow: Used Sheets Smart Fill and =AI() formulas to standardise dimensions, extract electrical specs, and write clean NZ product descriptions across 800 rows at once.

Outcome: 3-day catalogue updates now finish before morning tea.

Do it yourself today

• Open any Google Doc or Sheet, click the Gemini spark icon at the top right, and type @ to reference a file in Drive.
• Test =AI("Categorise this line item", A2) inside Google Sheets.
• Open vids.google.com and turn an existing SOP Doc into a 2-minute training video.

Maintain AI production build

• Automated Apps Script + Gemini pipelines so Sheets and Docs reports compile and email themselves on a schedule.
• Clean Drive taxonomy and template locks so Gemini never pulls outdated 2022 pricing into a 2026 quote.
• Live Xero, CRM, and BigQuery data feeds wired directly into your master Google Sheets.