Wants to automate its BDM daily performance tracking via a smart Google Workspace workflow that measures productivity and sales outcomes across teams in India and UAE. The goal is to replace manual WhatsApp updates with an automated reporting system that: Collects daily activity via Google Form Calculates key sales KPIs automatically Generates a Daily Leaderboard (ranked by Impact Score) Emails and optionally posts a WhatsApp-ready summary at 8 PM (Dubai time) This project should eliminate all noise and make sales performance transparent, data-driven, and motivating. The hired freelancer will: Set up a Google Form with all FineAcers BDM performance fields. Link the Form to a Google Sheet and configure: Form Responses Helper columns (WeekStart, DIS, Month) Daily Leaderboard tab Weekly Summary tab Monthly Dashboard tab Install and test the Apps Script (provided below) to: Create these sheets automatically Generate and email the leaderboard summary Schedule the report to run automatically at 8 PM Dubai time daily (Optional) Integrate with WhatsApp or Google Chat API via webhook for automatic posting. Deliver a working system + short setup guide + 1 test run. System Deliverables: Working Google Form titled: FineAcers BDM Daily Performance Log Linked Google Sheet with these tabs: Form Responses 1 Daily Leaderboard Weekly Summary Monthly Dashboard Config (for email list & timezone) Auto email + WhatsApp message generator at 8 PM (GMT+4, Dubai) Clean formulas, readable layout, no broken references. Google Form Fields Date BDM Name City / Region (dropdown) Direct Meetings with Decision-Makers (count) Top 3 Meetings (Name – Org – Est. Value) Sales Closed today (Currency) Sales Month-to-Date (Currency) Deals Closed Month-to-Date New Qualified Leads today Qualified Leads Month-to-Date Lead Sources (checkboxes) Channel Partners added today Channel Partners added Month-to-Date Top 3 Next Actions for Tomorrow Blockers (if any) Fix / Action Plan Platform: Google Workspace (Forms + Sheets + Apps Script) Automation: Google Apps Script time trigger Timezone: GMT+04:00 (Dubai) Email notifications via Gmail API Optional webhook posting (Zapier, WhatsApp Cloud, or Google Chat) At the end of the project, freelancer will deliver: Working Form + Sheet + Script Documentation: “How to add new users, change emails, or edit the trigger” 1 recorded test run using a sample BDM entry