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.
Illustration. Names and rows are sample data; totals are the project’s.
On this page
Key numbers
4alert 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.