Video by Kevin Stratvert on YouTube · 23 min. We did not make this video and we do not host it — watching it here still counts as a view for the creator.
Sheets is more than a spreadsheet; its functions like IMPORTJSON, QUERY, and ARRAYFORMULA let you manipulate API data without code. New users often copy‑paste data manually, which defeats automation. Learn to keep raw data on a hidden tab and use formulas to produce clean reports.
Practice by importing a static CSV file, then use QUERY to filter rows where the campaign equals "spring_sale". This mirrors the filtering you’ll later do on live GA data.
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 continueIt takes about fifteen seconds.