Deborah T

Google Sheets Automation Specialist

Spreadsheetsoftware • Tiempo completo

Mar 2020 - Dec 2024 • 4 yrs 9 mos

Developed complex Google Sheets systems with Apps Script automation for inventory management, financial tracking, and CRM databases. Built dynamic dashboards with real-time data imports via API integrations (Zapier, Make.com). Created automated data cleaning workflows that processed 50,000+ rows of messy data into structured reports. Implemented pivot tables, QUERY functions, and custom formulas for business intelligence. Integrated Google Sheets with external platforms including Airtable, HubSpot, and Xero. looker studio, google sheets, dashboard, data visualization, excel dashboard, kpi dashboard, automation, report, data studio, power bi, visualization, data dashboard, microsoft excel, data analyst, charts, power bi dashboard, data analytics, gohighlevel, zapier integration, excel data cleaning, looker, excel data analysis, zoho crm, ai automation, excel, crm automation, excel automation, hubspot, data entry, workflow automation, analytics report, dashboard design, reporting, tableau, instagram marketing, social media manager, n8n automation, facebook marketing, kpi, api, airtable, google apps script, apps script, kpi tracker, hubspot crm, interactive, social media post, content creator, social media content, marketing automation, lead generation, make automation, make com automation, make com, sales funnel, email automation, n8n workflow, data reporting, hubspot workflow, hubspot expert, data formatting, pipedrive, resimpli, linkedin automation, digital marketing, make expert, made com, make com scenario, n8n ai agent, email marketing, gohighlevel website, landing page, instagram ads, sales analytics, marketing analysis, pitch, powerpoint, professional, deck, slides, sales automation, databox, python, pivot table, excel expert, facebook marketing, data collection, vba, chart, google sheets expert, dynamic dashboard, data reports, business report, real time, kpi reports, power bi reports, custom dashboard, clean up, formatting, ui ux, web analytics, dax

Excel Dashboard & KPI Specialist

Excel in Business • Freelance

Jun 2019 - Sep 2023 • 4 yrs 3 mos

: Designed executive-level Excel dashboards for financial forecasting, sales performance, and operational metrics. Built automated Excel systems using VBA macros and Power Query to eliminate manual data entry. Created KPI trackers with conditional formatting, sparklines, and interactive slicers. Developed budget planners and financial models for startups and small businesses. Implemented data validation rules and error-checking protocols to ensure data integrity across 100+ client workbooks. looker studio, google sheets, dashboard, data visualization, excel dashboard, kpi dashboard, automation, report, data studio, power bi, visualization, data dashboard, microsoft excel, data analyst, charts, power bi dashboard, data analytics, gohighlevel, zapier integration, excel data cleaning, looker, excel data analysis, zoho crm, ai automation, excel, crm automation, excel automation, hubspot, data entry, workflow automation, analytics report, dashboard design, reporting, tableau, instagram marketing, social media manager, n8n automation, facebook marketing, kpi, api, airtable, google apps script, apps script, kpi tracker, hubspot crm, interactive, social media post, content creator, social media content, marketing automation, lead generation, make automation, make com automation, make com, sales funnel, email automation, n8n workflow, data reporting, hubspot workflow, hubspot expert, data formatting, pipedrive, resimpli, linkedin automation, digital marketing, make expert, made com, make com scenario, n8n ai agent, email marketing, gohighlevel website, landing page, instagram ads, sales analytics, marketing analysis, pitch, powerpoint, professional, deck, slides, sales automation, databox, python, pivot table, excel expert, facebook marketing, data collection, vba, chart, google sheets expert, dynamic dashboard, data reports, business report, real time, kpi reports, power bi reports, custom dashboard, clean up, formatting, ui ux, web analytics, dax, data modeling

Looker Studio Dashboard Developer

DATA • Freelance

Jan 2021 - Mar 2023 • 2 yrs 2 mos

Built 200+ interactive dashboards in Looker Studio (Google Data Studio) for marketing agencies, e-commerce brands, and SaaS companies. Connected data sources including Google Sheets, Google Ads, Facebook Ads, and HubSpot CRM. Designed KPI dashboards tracking ROI, conversion rates, and customer acquisition costs. Created automated reporting systems that refresh daily, reducing manual report preparation by 90%. Implemented data storytelling techniques to make complex analytics accessible to C-suite executives. looker studio, google sheets, dashboard, data visualization, excel dashboard, kpi dashboard, automation, report, data studio, power bi, visualization, data dashboard, microsoft excel, data analyst, charts, power bi dashboard, data analytics, gohighlevel, zapier integration, excel data cleaning, looker, excel data analysis, zoho crm, ai automation, excel, crm automation, excel automation, hubspot, data entry, workflow automation, analytics report, dashboard design, reporting, tableau, instagram marketing, social media manager, n8n automation, facebook marketing, kpi, api, airtable, google apps script, apps script, kpi tracker, hubspot crm, interactive, social media post, content creator, social media content, marketing automation, lead generation, make automation, make com automation, make com, sales funnel, email automation, n8n workflow, data reporting, hubspot workflow, hubspot expert, data formatting, pipedrive, resimpli, linkedin automation, digital marketing, make expert, made com, make com scenario, n8n ai agent, email marketing, gohighlevel website, landing page, instagram ads, sales analytics, marketing analysis, pitch, powerpoint, professional, deck, slides, sales automation, databox, python, pivot table, excel expert, facebook marketing, data collection, vba, chart, google sheets expert, dynamic dashboard, data reports, business report, real time, kpi reports, power bi reports, custom dashboard, clean up, formatting, ui ux, web analytics