Automation

Eliminating Manual Submissions: Lucky Draw Automation at Indian Oil

From Excel-Driven Inputs to 100% Lucky Draw Compliance Through Smart Automation.

Client

Indian Oil Corporation (Retail Partner)

Duration

2 days

Industry

Fuel Retail & Customer Engagement

Back to Case Studies

Work Overview

Understanding the context and objectives

During an ongoing lucky draw campaign, Indian Oil petrol pumps required customers to scan a QR code and manually submit their details. Due to time pressure, most customers skipped the process — putting managers at risk of missing submission targets. EGMA built an Excel-driven automation system where customer data (Name, Mobile Number, Bill Number, Fuel Amount, and Vehicle Type – 2W/3W/4W) is uploaded via Excel, automatically submitted to the lucky draw form, and recorded into structured Excel reports for both successful and failed submissions, ensuring 100% compliance with zero customer effort.

Fuel Retail & Customer Engagement

2 days

Automation

Egma Impact

How we transformed obstacles into opportunities

⚠️

Before Egma

Customer Drop-Off at QR Forms: Customers in a hurry avoided scanning and filling lengthy forms, leading to extremely low participation rates.

Strict Compliance Requirements: Petrol pump managers were mandated to ensure every eligible transaction was submitted, creating daily operational pressure.

Manual Data Entry Errors: Staff-entered mobile numbers, bill IDs, and fuel amounts caused validation failures and rejected submissions.

High Transaction Volume: Hundreds of transactions per day made manual form filling completely unscalable.

No Submission Visibility: There was no structured way to track which entries succeeded or failed.

Vehicle Type Validation Requirement: Forms required accurate classification of 2-wheelers, 3-wheelers, and 4-wheelers, adding another failure point.

💡

After Egma

Excel-Based Input Automation: Designed a standardized Excel template capturing Customer Name, Mobile Number, Bill Number, Fuel Amount, and Vehicle Type (2W/3W/4W) as the single source of truth for automation.

Automated Form Filling & Submission Engine: Built a headless automation workflow that reads each Excel row, maps it to the lucky draw form fields, selects the correct vehicle type option, and submits automatically.

Success & Failure Excel Reporting: Generated separate Excel files for successful and failed submissions, including confirmation IDs and failure reasons for complete auditability.

Intelligent Retry Logic: Implemented automatic retries for network or validation failures, ensuring maximum submission success rates.

Lightweight High-Volume Processing: Designed the system to process hundreds of Excel rows per run without impacting pump operations.

Client Testimonial

What our client had to say

“EGMA’s automation completely transformed our lucky draw campaign. What was once a daily struggle for compliance is now effortless, fast, and fully trackable through Excel reports. Our team can focus on customers instead of paperwork.”

Retail Operations Manager

Indian Oil Partner Outlet

Read Full Detailed Case Study