Apps Script Developer | Looker Studio Analyst
Request a quote with no obligation
Google Apps Script Developer | Workflow Automation | Google Workspace Expert
Hi, I’m Pravinkumar R, a Google Apps Script specialist with a proven record of turning manual business processes into automated, data-connected systems using Google Workspace tools.
I’ve helped organizations automate complex tasks like CRM data sync, procurement workflows, attendance tracking, billing, and live reporting dashboards — saving hundreds of work hours each month.
Automate Google Sheets, Forms, Docs, Gmail & Drive workflows
Build custom dashboards in Looker Studio
Integrate external APIs & CRMs using Apps Script
Develop approval systems, alerts, and scheduled reports
Create performance tracking (KPI/KRA) and reporting automation
Sales team tracker with CRM integration & live metrics
Tender & BOQ auto-generation system
Procurement ERP automation with vendor comparison
Geo-fenced project tracking and GRN system
WhatsApp + Email automation for daily updates
Every automation I create is focused on accuracy, speed, and simplicity, ensuring users get results without technical headaches.
Tools & Skills:
Google Apps Script | JavaScript ES6+ | Looker Studio | Google Sheets | Gmail Automation | API Integration | Google Workspace Add-ons | Workflow Design
Let’s collaborate to build smarter systems that save time, reduce manual work, and drive productivity!
Key Contributions & Achievements:
Designed and implemented Google Workspace-based automation systems using Google Apps Script, Looker Studio, and Sheets, replacing manual Excel operations across multiple departments.
Reduced manual effort by 80% and increased productivity by 90% through end-to-end workflow automation.
Built department-specific automation tools (Sales, Procurement, Tendering, HR, and Finance).
Integrated data from various CRM sources into a unified dashboard. Provided live team performance and KPI insights with automated daily WhatsApp and email summaries.
Tender & BOQ Automation:
Automated tender document generation and BOQ comparison using Google Sheets + Apps Script, saving hours of manual consolidation.
Procurement & ERP Billing:
Created a smart billing workflow with vendor comparison, GRN tracking, and purchase order automation — reducing approval time and improving transparency.
Geo-Fence Attendance & Material Tracking:
Developed mobile-friendly Apps Script web apps for site teams with GPS-based attendance, material entry logs, and auto-generated daily reports.
MD Dashboard & Live Reporting:
Delivered executive dashboards with live data visualization using Looker Studio and real-time Google Sheets backend updates.
Automated team and individual performance scorecards using Apps Script to calculate and deliver monthly reports automatically.
Google Apps Script | JavaScript (ES6+) | Looker Studio | Google Sheets | Gmail API | Forms | Drive API | REST API Integration | HTML | CSS
Handled support and communication between drivers and operations, resolving workflow issues through structured data handling.
Created internal spreadsheet automations to improve task efficiency and report turnaround times.
Built a strong foundation in data analytics, communication, and customer satisfaction processes.
Bachelor of Engineering – Mechanical Engineering
Anna University, Tamil Nadu
📅 Graduated: 2018
Developed strong analytical and problem-solving skills.
Applied engineering principles to real-world problem solving, later adapting them to process automation and software solutions.
Capstone project focused on efficiency improvement and data-driven system optimization.
📅 May 2024 – November 2024
Specialized in Python, Machine Learning, Deep Learning, SQL, Data Visualization, and Statistics.
Completed a project on Loan Default Prediction (Finance domain) using machine learning and visualization.
Gained experience in Python libraries such as Pandas, NumPy, and Matplotlib.
2. Google Apps Script Developer Projects (Self-Learned & Industry Implementation)
📅 Ongoing – Practical Application at MIPL Group
Designed real-time automation workflows for Sales, Procurement, Tendering, and Project Tracking.
Hands-on experience integrating Google Workspace APIs, HTML/CSS UIs, and Looker Studio dashboards.
3. Web Development Fundamentals (Self-Taught)
Proficient in HTML, CSS, and JavaScript (ES6+) for front-end automation UI design.
Built internal dashboards and custom web interfaces for data entry and reporting.
4. Power BI & Data Visualization Certification (GUVI)
Gained practical knowledge in designing KPI dashboards and data visualizations.
Connected Power BI/Looker Studio with Google Sheets and Apps Script-based data pipelines.
