01 · Project Snapshot
The Engagement, at a Glance
| Client | Mercedes-Benz Skyline |
| Solution Provider | Gramosoft Private Limited, Chennai |
| Source System | Mercedes-Benz Skyline Portal (GST Invoice & PO Reports) |
| Target System | Mercedes-Benz Skyline |
| Technologies | Python, Robot Framework, OpenPyXL, SMTP |
| Automation Type | Robotic Process Automation (RPA) |
| Deployment | Ubuntu Server + Headless Browser (Scheduled Jobs) |
| Status | Production — Actively Running |
03 · The Solution
Two Scheduled Workflows Zero Human Touchpoints
Gramosoft designed and deployed a Python + Robot Framework RPA solution with two modular automation workflows that run on schedule, fully replacing the manual process.
GST Invoice Data Cleansing
- Invalid invoice removal - detects and removes cancelled, test, and non-applicable entries using configurable, client-approved invoice-number rules.
- State code backfill - validates the GST state-code column and populates missing entries per the client's approved default mapping, so mandatory GST fields are always complete.
- Automated file management - saves cleaned output to a processed folder, maintaining an audit-ready file trail.
- Alert on failure - any error triggers an instant email to the operations team.
Vendor Purchase Order Backfill
- Incomplete vendor detection - identifies purchase-order rows with no supplier assignment across both vendor fields.
- Default vendor assignment - applies the client's designated default supplier so every procurement order carries a valid vendor reference.
- Automated file save - outputs updated files to the processed folder for downstream ERP upload.
- Alert on failure - the same email-based alerting ensures no failure goes unnoticed.
04 · Architecture
How the data travels - every day, on its own
Skyline Portal
MB Reports
RPA Scheduler
Robot Framework
Python ETL
Cleanse & Backfill
Nextflo ERP
Processed Upload
05 · Results
What Changed After Go-live?
| Before Automation | After Automation | Business Benefit |
|---|---|---|
| Manual download & review daily | ✅ Fully automated on schedule | Zero human touchpoints required |
| T+1 data availability (24hr lag) | ✅ Same-day (T+0) availability | Real-time financial visibility |
| Human error in data cleaning | ✅ Rule-based deterministic logic | 100% consistent data quality |
| No failure visibility | ✅ Instant email alerts on error | Rapid issue detection & response |
| Full FTE dedicated to task | ✅ Staff redeployed to value work | Cost saving + productivity gain |
| Inconsistent vendor mapping | ✅ Auto-filled default vendor | Clean procurement audit trail |
06 · Built to Scale
Can this Run at Your Dealership?
07 · Technology Stack
Proven, Maintainable, Observable
Python 3.x
Core automation scripting language for data transformation logic
Robot Framework
Enterprise RPA orchestration and scheduling engine
OpenPyXL
Excel file read, write and cell-level manipulation library
smtplib / email
Built-in alert and notification system on failure events
08 · Why Gramosoft
RPA that's aMintainable, Observable, Production-grade
Gramosoft Private Limited is a Chennai-based AI and IT services company with deep expertise in Robotic Process Automation, Document AI, and enterprise ERP integrations. Our RPA practice combines the reliability of proven frameworks like Robot Framework with custom Python intelligence.
- Production-grade RPA deployments across automotive, aviation, and insurance sectors
- Enterprise clients across India and Southeast Asia
- Flagship product — GdoczAI: Intelligent Document Processing (IDP)
- Flagship product — GcrawlAI: Transform any website into structured, LLM-ready data
- Flagship product — GsearchAI: Enterprise GraphRAG platform for source-cited AI search across enterprise knowledge
09 · FAQ
Frequently Asked Questions
What did Gramosoft automate for the Mercedes-Benz Skyline Portal?
The daily download, cleansing, and ERP upload of GST invoice and purchase-order data from the Mercedes-Benz Skyline Portal into Nextflo ERP using Python and Robot Framework, running on schedule in production, replacing a full-time manual workflow.
What business results did the RPA automation deliver?
Data availability improved from T+1 (24-hour lag) to same-day T+0, manual effort dropped to zero FTE, data quality became 100% rule-consistent, and any failure now triggers an instant email alert to the operations team.
Can this be replicated at other Mercedes-Benz dealerships?
Yes. All business rules are configuration-driven, so the same solution can be deployed at any dealership using the Skyline Portal or adapted to other OEM portals in a fraction of the original build time.
Which technologies power the solution?
Python 3.x for data transformation, Robot Framework for RPA orchestration and scheduling, OpenPyXL for Excel manipulation, and smtplib for failure alerting deployed on an Ubuntu server with a headless browser running scheduled jobs.
