How I Built an Automated Team Management System Using G Suite and Claude AI

Hi Everyone! Sharing a build that’s changed how I run my team — Gong, but for internal projects. The stack is simple: G Suite + Claude. Team turns on Meet transcripts / Gemini notes for every meeting, a Google Apps Script (written by Claude — I didn’t hand-code it) routes each transcript into a Drive folder per project every 15 minutes, and a custom Claude skill reads everything weekly — transcripts, Gmail, Slack, Jira — and maintains a persistent RAG-status tracker per direct report. A scheduled task DMs each person their refreshed notes 4 hours before our 1:1, so both of us walk in prepared. Beyond 1:1s, the same transcript archive publishes project updates to a company-wide Confluence page — people who were never in the meetings stay current without another status meeting. I put together a full architecture walkthrough (attached, company details removed): the 5-stage pipeline, the design principles that kept it from becoming an AI-generated mess, a starter kit you can paste into Claude to build your own, and an FAQ of everything that broke and how it evolved. Nothing to sell here — you can build this yourself with the doc. If you like this and want to collaborate on more projects like it, hit connect on LinkedIn: here. Always happy to trade notes with other RevOps folks automating the unglamorous parts of the job.