I will do google sheets and excel automation, formulas and custom dashboard


About this gig
Tired of slow manual spreadsheet workflows and broken formulas
I build high performance Google Sheets and Excel automation systems designed to save you hours of manual work and streamline your daily operations.
Whether you need a quick formula fix or a complete multi tab business dashboard, I deliver clean, reliable, and fully automated spreadsheet solutions.
Services Offered
1. Google Apps Script and VBA Macros Automate tasks, send email triggers, and connect APIs.
2. Advanced Formulas Complex XLOOKUP, INDEX MATCH, ARRAYFORMULA, and nested IF statements.
3. Custom Dashboards Interactive visual summaries with KPI cards, charts, and clean data organization.
4. Data Cleaning and Fixes Repair broken formulas, deduplicate data, and organize messy files.
5. Workflow Integration Auto calculate metrics and reduce manual data entry.
Why Choose This Service
1. Tailored solutions built specifically for your operational workflow.
2. Clean, well structured, and reliable spreadsheet architecture.
3. Prompt communication and fast delivery options.
Contact me before placing an order so we can discuss your project requirements and select the right package for your workflow.
Get to know Piyumal
Google Sheets Automation and KPI Dashboard Specialist
- FromSri Lanka
- Member sinceSep 2026
- Avg. response time1 hour
Languages
English
FAQ
Do you write custom Google Apps Script and Excel VBA macros
Yes, I create custom Google Apps Script and Excel VBA macros to automate repetitive manual tasks, send automated email triggers, format raw data, and connect external APIs directly to your spreadsheets.
What information or files do I need to provide before starting
Please share a detailed description of your goal, your sample spreadsheet or data structure, and an example of your expected output. If you have confidential data, you can replace sensitive values with dummy data.
Can you fix broken formulas or optimize slow spreadsheets
Yes, I audit existing Google Sheets and Excel workbooks to fix broken complex formulas like XLOOKUP, INDEX MATCH, or ARRAYFORMULA, reduce latency, and restructure calculations for fast performance.
Will my automated dashboard work on both Google Sheets and Excel
Google Sheets and Excel use different scripting languages, Google Apps Script in JavaScript versus Excel VBA. Please message me prior to placing your order so we can select the exact platform for your setup.
Should I message you before placing an order
Yes, contacting me first allows us to clarify your specific workflow requirements, confirm data source compatibility, and ensure you select the exact package or custom offer needed for your project.
