j
jaisramyadav82

Jaisram Yadav

@jaisramyadav82

Google Apps Script And Sheets Automation Expert

Índia
Hindi, Inglês
Algumas informações são exibidas no idioma inglês.
Sobre mim
I build custom automation systems on Google Sheets & Google Apps Script that replace manual work. I have built real business tools used daily: stock & inventory systems, PO/GRN web apps, task trackers with scorecards, cash ledgers, auto email reports, Gmail-to-Sheet PDF extraction, and live Looker Studio dashboards. I also work with Advanced Excel, Power Query & Power BI. Tell me your manual process and I'll turn it into a clean, automated system. Fast delivery, clear communication.... Saiba mais

Habilidades

j
jaisramyadav82
Jaisram Yadav
offline • 
Tempo médio de resposta: 1 hora

Conheça meus serviços

BI Analytics
I will do excel google sheets and data analysis work
A partir deUS$ 15 /projetoMais detalhes
Redação de Roteiro
I will automate google sheets with apps script and build custom web apps
A partir deUS$ 15 /projetoMais detalhes

Portfólio

Experiência profissional

ABIT_Technology

MIS Executive

ABIT Technology • Período integral

Nov 2025 - Present • 11 mos

Google Apps Script Web Apps: Built mobile-friendly web apps on Google Sheets for stock entry, purchase orders, gate inward (GRN), cash ledger and production entry, with PIN-based user access. Workflow Automation: Automated daily reports, email alerts, reminders and data transfers between sheets using Apps Script triggers, removing hours of manual work every day. Gmail and PDF Automation: Created scripts that read emails, save PDF attachments to Drive and extract order data into Google Sheets automatically. Dashboards and Reporting: Designed MIS reports, live dashboards and scorecards in Google Sheets, Looker Studio and Power BI for management review. Excel and Data Management: Advanced Excel, Power Query, VLOOKUP, Index-Match, Pivot Tables and data cleaning to keep data accurate across departments. Collaboration: Worked with department heads to understand their process and turned manual work into simple, automated systems.