I will automate google sheets and excel with apps script or python
Websites, landing pages and Google Sheets automation
About this Gig
Hi! If you spend time every week copying rows, fixing dates or building the same report again, I can automate that for you.
I work with Google Sheets (Apps Script and formulas) and with Excel or CSV files (Python).
Things I can set up:
- Clean up messy data: duplicates, dates, names, empty cells
- Merge a bunch of sheets or files into one
- Google Form answers sorted into a sheet with IDs and dates
- A custom menu with buttons that do the boring stuff in one click
- Daily or weekly reports and simple dashboards
- An email to you or your team when something changes
- Export to Excel, CSV or PDF
- Run it on a schedule, like every morning
How we'll work: send me a copy of your file with fake or sample data and tell me what you do by hand now. I build it, test it and deliver it in your order with short notes and a quick demo video.
Please message me before ordering so I can look at your file first. I never need your passwords.
Technology:
Excel
•
Google Sheets
•
Python
My Portfolio
FAQ
Do I need to give you my Google password?
No, never. Just send me a copy of the sheet with fake data. I send back the script and show you how to add it to your sheet. It takes a few minutes.
My data is private. What do I send?
Same columns, fake values. Change names, phone numbers and emails to anything. I only need to see how the sheet is set up.
Google Sheets or Excel?
Both. Google Sheets I do with Apps Script and formulas. Excel and CSV I do with a Python script you run on your computer. I don't do VBA macros.
Can it run by itself?
Google Sheets ones can run on a timer, even when your computer is off. Python scripts run on your computer when you start them, or on a schedule you set.
Do I need to install anything?
Not for Google Sheets. For Python you install Python, which is free, and I'll walk you through it.
Can it email my customers?
Only emails they expect, like a confirmation after they fill in your form. Google also limits how many emails you can send a day. No bulk marketing emails.
Can it pull data from websites?
From public APIs and feeds, yes. I don't scrape social media or sites that don't allow it, and I don't log into anything.
Can you make a dashboard?
Yes, charts and summary tables that update when your data changes.
What if it breaks later?
If it's a bug in my work, tell me and I'll fix it. If your sheet layout changes later, I can update it in a new order.
Do you work with bank or payment accounts?
No. Only your sheets and files.

