All case studies

AI meeting-to-task and Workspace security automations

AppSheet Solutions built Gemini automations that turn an engineering team’s meeting transcripts into task tables, plus a daily Google Workspace activity monitor.

Page last updated

Status: In daily use

Ask about this project

Islom Ilkhomov

Sample meeting automation: a task table filled from a meeting, the meeting transcript beside Gemini’s list of new tasks, and a daily Workspace activity email listing four alert rules.
Illustration. Names and rows are sample data; totals are the project’s.
On this page

Key numbers

  • 4 alert rules in a daily scan

The problem

An engineering team agreed tasks in long online meetings, and someone then had to write them up by hand. Management also had no simple view of how company Google accounts and files were being used.

What we did

Two Apps Script automations use Gemini. The first imports the latest meeting transcript from Google Docs and turns it into a task table with owners and deadlines. The second compares the morning and evening sessions and writes a progress summary back to the tracker. Separately, we built a daily activity monitor that reads Google Workspace usage, login, Drive and Meet activity through the Admin SDK and e-mails managers when it sees risky patterns.

Results

  • Meeting tasks extracted and assigned by AI from the transcript
  • Progress summaries written back to the tracker automatically
  • Daily 6 am activity scan with four alert rules
  • Monitoring metrics, retention window and backup approach agreed with the client’s technical lead

How it helps

Tasks no longer have to be written up by hand, and managers get alerts about risky account activity.

More case studies

Purchasing platform for a machinery manufacturer

A machinery manufacturer needed one shared record for requests, supplier prices, approvals and goods receipt, used by many people at once.

Sector
Machinery manufacturer
Platform
AppSheet + Apps Script
Status
In daily use

HR, timesheet and payroll system

Staff records, time, leave, expenses and pay sat outside one shared system, with approvals spread across e-mails and files.

Sector
Engineering consultancy
Platform
AppSheet
Status
In daily use

Start with a conversation

Let’s make your work easier.

  1. Tell us where work gets stuck.
  2. We clarify what an app could help with.
  3. We agree the next step together.

Tell us about your project

WhatsApp (opens in a new tab)

Need an example?

We want to register our equipment and let field staff report faults from their phones. Today, we track everything in messages.

Add project details (optional)

What is it about?

Book a 30-minute call

Discuss your custom app project with Islom on Google Meet.

Choose an available time
Portrait of Islom Ilkhomov

Islom Ilkhomov

Prefer to write directly? Islom.Ilkhomov@appsheet.com.tr

Istanbul, Türkiye

Prefer a conversation? Write to me directly.

Talk to Islom on WhatsApp (opens in a new tab)+90 501 176 94 71