Hey friends
Over the past few weeks, I’ve been working on a personal project that’s turning into something I’m really proud of:
A Google Sheets Add-on that fetches and audits GTM container data like tags, triggers, and workspaces — all from the comfort of a spreadsheet.
Why I’m Doing This
As a Digital Analyst, I work closely with tools like Google Analytics, GTM, and BigQuery every day.
But I realized something important:
While I could analyze data well, I wanted to go deeper technically — not just use tools, but build them.
That’s how this GTM MVP idea was born.
What the Tool Does (so far)
- Lets me choose a GTM account > container > workspace
- Pulls a list of tags, triggers, and workspace details
- Shows which triggers fire which tags
- Shows parameters used inside each tag (like
eventName,conversionId) - Includes a direct “GTM URL” column so I can click and jump to GTM instantly
- Writes everything into a clean, organized Google Sheet
It’s basically my GTM Inspector for Analysts — and it works ✨
The Courses That Helped Me Kickstart
These two courses were a game-changer for me:
- Google Apps Script Complete Course – Beginner to Advanced
→ Helped me understand how to connect Google Sheets with APIs. - The Complete Full-Stack Web Development Bootcamp
→ Helped me learn JavaScript basics and how frontend/backend works.
Both gave me the confidence to not just copy code, but understand it and shape it for my own needs.
What I’m Learning (and Loving)
- JavaScript fundamentals:
map(),forEach, conditional rendering, error handling - How the GTM API works (including hidden fields like
parameter[]) - How to write reusable, well-documented Apps Script code
- How to build a product mindset: small features that solve real problems
Why This Blog?
I wanted to keep a small public diary of my journey — not for likes, but to track my own progress, keep myself accountable, and maybe help someone else thinking:
“Can I learn to build something useful, even if I’m not a developer?”
Yes, you absolutely can. I’m doing it one line at a time.
What’s Next
- Add support for built-in variables and versioning
- Let users select which columns (parameters) they want to see
- Add email alerts or summaries for GTM changes
- Maybe (just maybe) turn it into a small SaaS add-on
If you’re interested in building tools with Apps Script, APIs, and a bit of creative problem solving — feel free to follow along. I’ll keep sharing what I learn along the way 🙌
Want to see the code?
You can check it out here:
📂 GitHub Repo → https://github.com/Hisham-ghanayem/gtm-api-to-sheets
