You will get an Automated PO-to-Delivery Workflow to inform, tracked with dashboard


Project details
I designed and built an end-to-end automation that takes a purchase order from a raw PDF or img all the way through approval, work-order (WO) generation, and delivery tracking, with just one deliberate human checkpoint in the entire chain.
An AI extraction step reads incoming PO documents into a structured, centralized Google Sheet. The user simply confirms the PO number from a dropdown, and everything downstream runs on its own. The system automatically routes the PO for review, emails all stakeholders the moment a new PO is logged, and sends a scheduled digest of every pending approval twice a day, with direct sheet links, so nothing sits waiting because someone forgot to check a folder.
Once approved, it auto-generates the work order and pushes it to PPC and A/C, then links forward into a delivery-tracking sheet that flags delays for action.
The build uses only Google Workspace tools, Apps Script, Sheets, Gmail, and an LLM for extraction, so there was no new software to buy or maintain. The underlying pattern is what I specialize in: rule-based logic that reads data, applies conditions, generates a document, and sends it on schedule.
An AI extraction step reads incoming PO documents into a structured, centralized Google Sheet. The user simply confirms the PO number from a dropdown, and everything downstream runs on its own. The system automatically routes the PO for review, emails all stakeholders the moment a new PO is logged, and sends a scheduled digest of every pending approval twice a day, with direct sheet links, so nothing sits waiting because someone forgot to check a folder.
Once approved, it auto-generates the work order and pushes it to PPC and A/C, then links forward into a delivery-tracking sheet that flags delays for action.
The build uses only Google Workspace tools, Apps Script, Sheets, Gmail, and an LLM for extraction, so there was no new software to buy or maintain. The underlying pattern is what I specialize in: rule-based logic that reads data, applies conditions, generates a document, and sends it on schedule.
Data Entry Type
Data Cleansing, Document ConversionData Entry Tool
Google SheetsWhat's included $280
These options are included with the project scope.
$280
- Delivery Time 20 days
- Number of Revisions 10
- Number of Hours of Work 30
- Formatting & Clean Up
- Graph & Table Creation
Optional add-ons
You can add these on the next page.
Additional Hour of Work
+$25About Abhishek
Business Process Consultant | BRD Writer | AI App Builder | ISO LA
Ghaziabad, India - 1:37 am local time
digitalized, I did it in 90 days — a process that typically takes
7–9 months. Siemens Digital Industries Software published it as a
global case study and featured it at their Worldwide PLM Summit 2025.
That's what I do: I take complex, broken, or non-existent business
processes and build them into clean, digital, measurable systems —
fast and with full ownership from design to go-live.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
WHAT I DELIVER FOR CLIENTS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
✅ Business Process Development
Map, gap-analyse, and design end-to-end business processes from
scratch — customer service, complaint resolution, dealer management,
purchase, and quality functions — with SOPs, KPIs, RACI, and
governance built in.
✅ Business Requirements Documents (BRD / FRD / SRS)
Developer-ready requirement documents for apps and software —
functional specs, use-case flows, process diagrams, and acceptance
criteria. Your development team gets clarity; your project stays
on scope and budget.
✅ AI App Development & Automation
I build practical AI-powered apps using Google AI Studio / Gemini
API combined with low-code platforms (Zoho Creator, Zoho Projects).
Example: an AI Minutes-of-Meeting app that takes a transcript and
outputs structured minutes, decisions, and action items automatically.
✅ PLM / ERP Implementation Advisory
Teamcenter, Polarion ALM, and ERP rollouts — requirement gathering,
workflow configuration, UAT, training, and go-live. I've led
implementations from brief to adoption.
✅ ISO / QMS Consulting
Lead Auditor for ISO 9001:2015 and ISO 45001:2018. Gap audits,
audit-ready SOP packs, IATF 16949 process alignment, APQP, PPAP,
and FMEA for automotive and manufacturing clients.
✅ Presentation & Pitch Deck Design
Professional PowerPoint decks — pitch decks, strategy presentations,
investor reports, and process decks that communicate clearly and
look polished.
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
PROOF THAT I DELIVER
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
→ 90-day PLM implementation (industry norm: 7–9 months) —
Siemens global case study, 30% productivity improvement
→ 80% complaint TAT reduction — field issue response time cut
from 5 days to under 12 hours
→ Complaint resolution processes built from zero at two
EV companies — defined, digitalized, and fully adopted
→ Dealer onboarding app built personally on Zoho Creator —
real-time field-to-plant feedback loop
→ ERP implementation SPOC at Numeros Motors — requirements,
developer coordination, UAT, go-live
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
CREDENTIALS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
- 10 years across automotive, EV, and precision manufacturing
- Lead Auditor — ISO 9001:2015 & ISO 45001:2018
- Lean Six Sigma Green Belt
- MBA in AI in Business — BITS Pilani (pursuing)
- B.Tech — Electrical Engineering
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
HOW I WORK
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
- Full-time availability — immediately
- IST (UTC+5:30) — mornings overlap EU/UK; evenings overlap US
- Weekly updates, documented deliverables, no surprises
- Hourly, fixed-price, and retainer engagements welcome
If you have a process that's broken, undocumented, or stuck in
email and spreadsheets — message me with the problem. I'll outline
a phased approach before you commit to anything.
Steps for completing your project
After purchasing the project, send requirements so Abhishek can start the project.
Delivery time starts when Abhishek receives requirements from you.
Abhishek works on your project following the steps below.
Revisions may occur after the delivery date.
Discovery & Process Mapping
Mapped the manual PO workflow end-to-end — identified every handoff, delay point, and disconnected sheet across procurement, approvals, production, and accounts.
AI Extraction Design
Built an AI-driven extraction layer to read PO data from PDFs and images into a standardized format, eliminating manual re-typing.