You will get a Google Sheets task automated with Apps Script
Project details
I'll automate the repetitive thing in your Google Sheets or Workspace with Apps Script - auto-send emails from rows, auto-format and clean incoming data, sync between sheets, generate PDFs, or run on a schedule with triggers. You tell me the workflow and the rules; I build it, test it, and hand it over with a short how-it-works note. The busywork just disappears - and I confirm anything unclear before building.
Programming Languages
JavaScriptWhat's included
| Service Tiers |
Starter
$35
|
Standard
$75
|
Advanced
$150
|
|---|---|---|---|
| Delivery Time | 2 days | 3 days | 5 days |
Number of Revisions | 1 | 2 | 3 |
Install Script | - | - | - |
Test Script | - | - | - |
Task Automation |
About William King
Data & Automation Expert | Excel, Google Sheets, Dashboards & Python
San Francisco, United States - 5:55 am local time
Technical freelancer with a Management Information Systems degree (Ateneo de Manila) and 7+ years in product management, technical pre-sales, and software delivery at fintech and IT firms - including GCash / Globe Fintech (Mynt). I have shipped real products end to end, so I focus on your goal, not just the task.
WHAT I DO BEST
- Excel & Google Sheets automation - dashboards, formulas (VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS), pivot tables, auto-calculating templates, and reporting
- Data cleaning & entry - accurate, fast, de-duplicated, and consistently formatted
- Merge, clean & de-duplicate spreadsheets - turn messy multi-file data into one reliable master sheet
- Google Apps Script automation - auto-emails, scheduled triggers, PDF generation, sheet-to-sheet sync
- Custom Python scripts - process or convert data, organize files, collect data into CSVs, and small automations
- Live crypto & stock trackers in Google Sheets - watchlists, portfolio profit/loss, and trading journals (I am an active trader)
- PDF / image to clean Excel or Word - typed and checked by hand, not just auto-converted
- Lead lists & web research - verified, sourced, ready-to-use spreadsheets
- Website features & fixes - contact forms, maps, chat buttons, landing pages, plus speed & mobile fixes (HTML/CSS/JS, React/Next.js)
WHY CLIENTS WORK WITH ME
- Business + technical background - I translate a real-world need into a working solution
- Clear communication and fast replies - I confirm anything unclear before guessing
- Detail-oriented - every entry, formula, and result is double-checked
- Reliable delivery - on time, with a short how-it-works note so you can run it yourself
BACKGROUND & CERTIFICATIONS
BS Management Information Systems (Ateneo de Manila). Product Manager at Mynt / GCash. Technical Pre-Sales Engineer. ITIL Foundation certified. Most recently, Project Director of iCASH - I-Remit's e-wallet - leading development, marketing, and partnerships from concept to production launch, reporting directly to the President.
Available 30+ hrs/week and responsive across time zones. Tell me the task, the source, and the result you want - and I will take it from there.
Send me a message with what you need and I will reply with a clear plan and timeline.
Steps for completing your project
After purchasing the project, send requirements so William King can start the project.
Delivery time starts when William King receives requirements from you.
William King works on your project following the steps below.
Revisions may occur after the delivery date.
Share the workflow
Tell me the task and the rules; I confirm scope and timing.
I build & test
I write the Apps Script and test it on your sheet so it runs reliably.