I will automate excel and google sheets with vba macros and apps script
Shopify Developer, Python Automation and Excel
About this Gig
If you are doing the same thing in a spreadsheet every week, it should be doing it itself.
WHAT I BUILD
VBA macros that turn a 40-minute manual process into one button
Google Apps Script automations for Sheets, Gmail, Drive, Forms and Calendar
Formulas that actually hold up: INDEX/MATCH, XLOOKUP, array formulas, nested logic
Dashboards that update themselves from your raw data
Data cleaning: deduplication, splitting, merging, reformatting the export nobody can use
ALSO
Fixing what is already broken. #REF!, #N/A, circular references, the workbook someone built in 2019 and then left the company.
WHAT YOU GET
The working file plus a short note explaining how it works, so you are not dependent on me to change it later.
A NOTE ON YOUR DATA
Please do not send confidential records. Send a copy with the real values replaced by dummy data but the same structure. The automation works identically either way, and your data stays yours.
Send me the file and tell me what you want to stop doing by hand.
Technology:
Excel
•
Google Sheets
•
Python
•
VBA
FAQ
Can I send a file with confidential data?
Please do not. Send a copy with the real values replaced by dummy data but the same structure. The automation works identically either way, and your data stays yours.
Will macros work on Mac?
Mostly, but VBA on Mac has genuine limitations. Tell me upfront if Mac users need it and I will build around them or use Apps Script instead.
Can you fix a workbook someone else built?
Yes, that is a large part of what I do. Send it over with a note on what is going wrong and I will tell you what is fixable before you order.
Do I need to know VBA to use what you build?
No. I include a short plain-English note explaining how it works and how to run it. You will not need to touch the code.

