Inder Book Agency

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. Job Type: Full-time Pay: ₹20,000.00 - ₹25,000.00 per month Work Location: In person