Pravinkumar Raja

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.

What I Do:

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

Recent Projects:

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!

Software Developer – Marlecha Interiors Pvt Ltd (MIPL Group)

📍 Chennai, India | Jan 2023 – Present

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).

Major Projects:

Sales Team Tracking System:

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.

Performance Evaluation (KPI/KRA):

Automated team and individual performance scorecards using Apps Script to calculate and deliver monthly reports automatically.

Tech Stack:

Google Apps Script | JavaScript (ES6+) | Looker Studio | Google Sheets | Gmail API | Forms | Drive API | REST API Integration | HTML | CSS

Community Support Representative – Uber India

📍 Chennai, India | 2019 – 2021

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.

🧾 Professional Certifications

1. Advanced Programming & Data Science (IIT Madras – GUVI Platform)

📅 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.