Objective of the Role To manage, automate, and troubleshoot day-to-day business data processes using Google Sheets, Google Forms, Apps Script, and REST API integrations. This role ensures real-time visibility, systematic reporting, and smooth data flow across departments like CRM, Order Management, and Delivery. Key Responsibilities 1. Google Workspace Automation Create Google Forms & connect to Google Sheets as per team requirements. Maintain dynamic Forms linked to task management systems. Automate workflows using Google Apps Script (form triggers, custom menus, email & WhatsApp alerts). 2. Daily Tech Troubleshooting Solve real-time formula errors, data inconsistencies, or broken sheet links. Ensure smooth functioning of CRM, Order-to-Delivery FMS, and Feedback trackers. 3. Data Collection & Presentation Gather data from various sources including cloud apps, ERP systems, and Google Sheets. Standardize and clean datasets—remove duplicates, fix date/timestamp issues. Present clean, visual reports using pivot tables, bar/line graphs, and dashboards. 4. Dashboard Development (Owner & Team-Wise) Build custom dashboards for owner and team members to monitor: - Order status - Task completion status - CRM task ageing - Performance KPIs (per person, per department) Dashboards must be auto-updated, visually clear, and action-oriented. 5. System Integration via REST API Connect and sync data from external platforms such as: - POS systems - Sales CRMs - Call tracking apps - Inventory or billing software Use REST APIs (JSON, Webhooks) and Google Apps Script to fetch, push, and organize data within Google Sheets. 6. Insight Generation Identify data trends (e.g. who is submitting late entries, which orders are delayed). Share weekly/monthly summaries with responsible team members. Help the team act on lagging performance through actionable charts. Sample Real-World Tasks You Will Handle Task Description CRM Form Link Broken Investigate and restore Google Form to Sheet mapping logic. Order-Delivery Delay Report Identify who submitted orders late using timestamp data across Forms. Build Daily Order Dashboard Combine order entries from different sources into a single view. Trigger Alerts Send WhatsApp/Mail notifications when specific forms are submitted. Owner Dashboard Summary view of all pending/late tasks by person/category Team Member Dashboards Each doer gets a focused view of their own tasks, delays, and performance trends Skills Required Skill Area Must Have Notes Google Sheets & Forms ✅ Advanced formulas, data structuring Google Apps Script ✅ Triggers, custom functions, automation REST API ✅ Knowledge of POST, GET, tokens, webhooks Excel (Advanced) ✅ Cleaning, dashboards, dynamic analysis Visualization ✅ Pivot tables, bar/line/stacked charts Dashboarding ✅ Per-person, per-process views Debugging ✅ Comfort with error tracing Basic Logic ✅ Can write and explain logical workflows Communication ✅ Can explain solutions to non-technical team members Job Types: Full-time, Permanent, Fresher Pay: From ₹15,000.00 per month Benefits: Leave encashment Ability to commute/relocate: Dehradun, Uttarakhand: Reliably commute or planning to relocate before starting work (Preferred) Work Location: In person

Objective of the Role To manage, automate, and troubleshoot day-to-day business data processes using Google Sheets, Google Forms, Apps Script, and REST API integrations. This role ensures real-time visibility, systematic reporting, and smooth data flow across departments like CRM, Order Management, and Delivery. Key Responsibilities 1. Google Workspace Automation Create Google Forms & connect to Google Sheets as per team requirements. Maintain dynamic Forms linked to task management systems. Automate workflows using Google Apps Script (form triggers, custom menus, email & WhatsApp alerts). 2. Daily Tech Troubleshooting Solve real-time formula errors, data inconsistencies, or broken sheet links. Ensure smooth functioning of CRM, Order-to-Delivery FMS, and Feedback trackers. 3. Data Collection & Presentation Gather data from various sources including cloud apps, ERP systems, and Google Sheets. Standardize and clean datasets—remove duplicates, fix date/timestamp issues. Present clean, visual reports using pivot tables, bar/line graphs, and dashboards. 4. Dashboard Development (Owner & Team-Wise) Build custom dashboards for owner and team members to monitor: - Order status - Task completion status - CRM task ageing - Performance KPIs (per person, per department) Dashboards must be auto-updated, visually clear, and action-oriented. 5. System Integration via REST API Connect and sync data from external platforms such as: - POS systems - Sales CRMs - Call tracking apps - Inventory or billing software Use REST APIs (JSON, Webhooks) and Google Apps Script to fetch, push, and organize data within Google Sheets. 6. Insight Generation Identify data trends (e.g. who is submitting late entries, which orders are delayed). Share weekly/monthly summaries with responsible team members. Help the team act on lagging performance through actionable charts. Sample Real-World Tasks You Will Handle Task Description CRM Form Link Broken Investigate and restore Google Form to Sheet mapping logic. Order-Delivery Delay Report Identify who submitted orders late using timestamp data across Forms. Build Daily Order Dashboard Combine order entries from different sources into a single view. Trigger Alerts Send WhatsApp/Mail notifications when specific forms are submitted. Owner Dashboard Summary view of all pending/late tasks by person/category Team Member Dashboards Each doer gets a focused view of their own tasks, delays, and performance trends Skills Required Skill Area Must Have Notes Google Sheets & Forms ✅ Advanced formulas, data structuring Google Apps Script ✅ Triggers, custom functions, automation REST API ✅ Knowledge of POST, GET, tokens, webhooks Excel (Advanced) ✅ Cleaning, dashboards, dynamic analysis Visualization ✅ Pivot tables, bar/line/stacked charts Dashboarding ✅ Per-person, per-process views Debugging ✅ Comfort with error tracing Basic Logic ✅ Can write and explain logical workflows Communication ✅ Can explain solutions to non-technical team members Job Types: Full-time, Permanent, Fresher Pay: From ₹15,000.00 per month Benefits: Leave encashment Ability to commute/relocate: Dehradun, Uttarakhand: Reliably commute or planning to relocate before starting work (Preferred) Work Location: In person