I will build a google sheets tracker with apps script automation and ai

Turkey

I speak English, German, Turkish

Electronics Engineer PCB Design and Schematic Specialist

I'm Adem, an electronics engineer in Turkey, specializing in PCB design and schematics. I run TasCOM, building automation electronics. My latest project: an Ethernet backup card with 8 relays, an NE5...
About this Gig

I build custom Google Sheets systems using Apps Script automation, going beyond formulas to create tools that actually do work for you.


What I can help with:

  • Automated tracking dashboards (student progress, sales, inventory, etc.)
  • - Conditional alerts and warnings based on your own thresholds
  • - Auto-generated charts and summaries per category
  • - Connecting Sheets to AI APIs (Gemini, OpenAI) for smart suggestions and natural-language reports
  • - Automated email or PDF reporting
  • - Cleaning up and restructuring messy existing spreadsheets

Recent example: I built a weekly study planner for a tutor that tracks student quiz results, flags subjects below a performance threshold, auto-updates the study plan, and generates per-subject charts for practice exam analysis.


I work iteratively: I start from your existing sheet or a clear description of what you need, confirm the logic with you, then build and test it. Message me with your current sheet (or a description of what you want to track) and I will tell you exactly what is possible and how long it will take.

Technology:

Excel

Google Sheets

Expertise:

API integration

Data manipulation

Data validation

ETL

My Portfolio