Discord Bot + Google doc Excel insert request

What We Need Attendance Tracking We host regular onboarding and community meetings via Zoom. We would like to automatically track: Which members attended Meeting 1 Which members attended Meeting 2 Which members attended Meeting 3 (optional) Attendance date Time spent in the meeting Discord Automation Based on attendance, the system should: Assign attendance roles Update member status Create alerts for staff Examples: Member joined but did not attend Meeting 1 within 3–5 days Member attended Meeting 1 but not Meeting 2 Member appears inactive Staff Notifications We want automatic notifications showing which members may require follow-up. Reporting Simple reporting/dashboard showing: Total active members Meeting attendance rates Members who never attended onboarding Participation statistics Optional AI-generated reminder messages for members who have not attended onboarding meetings. Existing Platforms Discord Zoom Existing verification bot Membership/payment platform Please let us know: Whether Zoom attendance tracking can be automated Recommended tech stack Estimated development time Estimated cost Similar projects you have completed Thank you.