Courses / Build a UTM Tracker & Dashboard with Google Sheets & GA
Lesson 4 of 9

Connecting GA to Sheets with the GA Add‑on (Project 1)

4
▶

Video by MeasureSchool on YouTube · 12 min. We did not make this video and we do not host it — watching it here still counts as a view for the creator.

The official Google Analytics add‑on lets you pull reports directly into Sheets. Beginners often pull the wrong dimensions, ending up with duplicate rows. Choose the correct metric (sessions) and dimensions (source/medium, campaign) that match your UTM setup.

In this hands‑on lesson, create a sheet named "Raw GA Data" and schedule a daily refresh. Verify that the data updates automatically; this will be the backbone of your dashboard.

Start learning free

Sign in with your email, Google or GitHub. No password to remember. The same account carries your progress, your certificates and anything else you do with Nexgino later.

Sign in to continue

It takes about fifteen seconds.