Gohar A.

I automate Google Sheets and Excel so your team stops doing manual data work. Apps Script, Power Query, dashboards, CRM systems, and automated reporting - built around how your business actually operates. 100% Job Success Score | Top Rated | 22+ projects delivered | 186 hours logged WHAT I BUILD Google Sheets Automation Custom Apps Script automations that replace repetitive data entry, calculations, and updates. Workflows connecting Sheets with Forms, Gmail, Drive, Docs, and external APIs. Automated emails, notifications, reports, and document generation. Excel Automation & Reporting Advanced Excel formulas, Power Query, and Pivot Tables for data cleaning, transformation, and consolidation. Automated recurring reports, KPI scorecards, and dashboard builds. Excel models designed to reduce manual work and improve accuracy. Dashboards & Reporting Sales, finance, operations, and KPI dashboards in Google Sheets and Excel. Automated reporting systems that refresh themselves. Management-ready reports built from raw business data. Real-time visibility into the metrics that matter. CRM & Business Workflows Google Sheets CRM systems: leads, pipelines, follow-ups, task assignment. Inventory, order, and operational trackers. Form-to-sheet workflows and automated data collection. Systems that keep your team organized and your data clean. E-commerce & Shopify Reporting Shopify sales and performance dashboards. Revenue, orders, products, customers, CAC, ROAS, and profit tracking. Automated e-commerce reporting in Google Sheets and Excel. All your store data in one place. Formula & Spreadsheet Solutions Complex formula fixes across Google Sheets and Excel: QUERY, FILTER, ARRAYFORMULA, XLOOKUP, INDEX/MATCH, SUMIFS, IMPORTRANGE. Template and tracker builds. Cleanup, restructuring, and optimization of slow or unreliable spreadsheets. Data Cleaning & Analysis Turning messy, raw, or disconnected data into clean, structured datasets ready for reporting. Removing duplicates, fixing inconsistencies, standardizing formats, and validating accuracy before analysis begins. Trend analysis, variance analysis, and KPI calculation that turn clean data into clear business insights. WHY WORK WITH ME I don't just build spreadsheets or write scripts. I understand the business workflow behind them and design solutions that save time, reduce errors, and are easy to maintain. Whether it's a Google Sheets automation or an Excel reporting system, the goal is the same: systems that work reliably and scale with your business. Business-focused. Simple. Reliable. Scalable. SELECTED WORK • Sales Reporting System - Automated Google Sheets and Excel reporting that consolidates sales data, calculates KPIs, and generates management reports without manual work. • CRM & Follow-Up Automation - Google Sheets CRM workflows that organize leads, track follow-ups, assign tasks, and automate notifications. • Inventory Management - Automated inventory and SKU mapping systems that connect product data and reduce duplicate entries. • Financial & KPI Dashboards - Dashboards that turn raw business data into clear KPIs, trends, and performance insights. • E-commerce Dashboards - Shopify reporting dashboards tracking sales, orders, customers, CAC, ROAS, and profit in one place. • Excel Reporting Automation - Automated recurring reports and KPI scorecards built in Excel using Power Query and advanced formulas. MY APPROACH Understand → Design → Automate → Test → Deliver I first understand your workflow, identify repetitive work and errors, then build the simplest solution around your needs. LET'S TURN YOUR SPREADSHEET INTO A SYSTEM If your Google Sheets or Excel workflow is slow, repetitive, error-prone, or hard to manage - message me. I'll review how it works and suggest a practical solution. No obligation.