Hey friends <\/p>\n\n\n\n
Over the past few weeks, I\u2019ve been working on a personal project that\u2019s turning into something I\u2019m really proud of:<\/p>\n\n\n\n
\nA Google Sheets Add-on that fetches and audits GTM container data like tags, triggers, and workspaces \u2014 all from the comfort of a spreadsheet.<\/p>\n<\/blockquote>\n\n\n\n
\n\n\n\nWhy I\u2019m Doing This<\/h5>\n\n\n\n
As a Digital Analyst<\/strong>, I work closely with tools like Google Analytics, GTM, and BigQuery every day.
But I realized something important:<\/p>\n\n\n\nWhile I could analyze data well, I wanted to go deeper technically<\/strong> \u2014 not just use tools, but build them.
That\u2019s how this GTM MVP idea was born.<\/p>\n\n\n\n
\n\n\n\nWhat the Tool Does (so far)<\/h5>\n\n\n\n
\n
- Lets me choose a GTM account > container > workspace<\/li>\n\n\n\n
- Pulls a list of tags, triggers, and workspace details<\/strong><\/li>\n\n\n\n
- Shows which triggers fire which tags<\/li>\n\n\n\n
- Shows parameters<\/strong> used inside each tag (like
eventName<\/code>,conversionId<\/code>)<\/li>\n\n\n\n- Includes a direct “GTM URL” column<\/strong> so I can click and jump to GTM instantly<\/li>\n\n\n\n
- Writes everything into a clean, organized Google Sheet<\/li>\n<\/ul>\n\n\n\n
It\u2019s basically my GTM Inspector for Analysts<\/strong> \u2014 and it works \u2728<\/p>\n\n\n\n
\n\n\n\nThe Courses That Helped Me Kickstart<\/h5>\n\n\n\n
These two courses were a game-changer for me:<\/p>\n\n\n\n
\n
- Google Apps Script Complete Course \u2013 Beginner to Advanced<\/a>
\u2192 Helped me understand how to connect Google Sheets with APIs.<\/li>\n\n\n\n- The Complete Full-Stack Web Development Bootcamp<\/a>
\u2192 Helped me learn JavaScript basics and how frontend\/backend works.<\/li>\n<\/ul>\n\n\n\nBoth gave me the confidence to not just copy code<\/strong>, but understand it and shape it for my own needs.<\/p>\n\n\n\n
\n\n\n\nWhat I\u2019m Learning (and Loving)<\/h5>\n\n\n\n
\n
- JavaScript fundamentals:
map()<\/code>,forEach<\/code>, conditional rendering, error handling<\/li>\n\n\n\n- How the GTM API works (including hidden fields like
parameter[]<\/code>)<\/li>\n\n\n\n- How to write reusable, well-documented Apps Script code<\/li>\n\n\n\n
- How to build a product mindset: small features that solve real problems<\/li>\n<\/ul>\n\n\n\n
\n\n\n\nWhy This Blog?<\/h5>\n\n\n\n
I wanted to keep a small public diary of my journey<\/strong> \u2014 not for likes, but to track my own progress, keep myself accountable, and maybe help someone else thinking:<\/p>\n\n\n\n
\n“Can I learn to build something useful, even if I\u2019m not a developer?”<\/p>\n<\/blockquote>\n\n\n\n
Yes, you absolutely can. I’m doing it one line at a time.<\/p>\n\n\n\n
\n\n\n\nWhat\u2019s Next<\/h5>\n\n\n\n
\n
- Add support for built-in variables and versioning<\/li>\n\n\n\n
- Let users select which columns (parameters) they want to see<\/li>\n\n\n\n
- Add email alerts or summaries for GTM changes<\/li>\n\n\n\n
- Maybe (just maybe) turn it into a small SaaS add-on<\/li>\n<\/ul>\n\n\n\n
\n\n\n\nIf you’re interested in building tools with Apps Script, APIs, and a bit of creative problem solving \u2014 feel free to follow along. I\u2019ll keep sharing what I learn along the way \ud83d\ude4c<\/p>\n\n\n\n
\n\n\n\nWant to see the code?<\/h3>\n\n\n\n
You can check it out here:
\ud83d\udcc2 GitHub Repo \u2192 https:\/\/github.com\/Hisham-ghanayem\/gtm-api-to-sheets<\/p>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey friends Over the past few weeks, I\u2019ve been working on a personal project that\u2019s turning into something I\u2019m really proud of: A Google Sheets Add-on that fetches and audits GTM container data like tags, triggers, and workspaces \u2014 all from the comfort of a spreadsheet. Why I\u2019m Doing This As a Digital Analyst, I […]<\/p>","protected":false},"author":1,"featured_media":7419,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"postBodyCss":"","postBodyMargin":[],"postBodyPadding":[],"postBodyBackground":{"backgroundType":"classic","gradient":""},"footnotes":""},"categories":[70,7,10,37],"tags":[],"class_list":["post-7405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-case-study","category-data-analysis","category-data-storytelling","category-tracking"],"_links":{"self":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts\/7405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/comments?post=7405"}],"version-history":[{"count":4,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts\/7405\/revisions"}],"predecessor-version":[{"id":7424,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/posts\/7405\/revisions\/7424"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/media\/7419"}],"wp:attachment":[{"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/media?parent=7405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/categories?post=7405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hishamghanayem.com\/en\/wp-json\/wp\/v2\/tags?post=7405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}