If you’re committed to automating your work with Google Sheets, follow this 3-step yellow-brick road.
You can access all of the below templates, tutorials + course discounts from the CIFL Template Vault on Trello – click to claim your invite.
1. PULL RAW DATA INTO SHEETS
Avoid copy-pasting data or exporting CSV files. Learn to import data directly into Google Sheets from the tools (like Google Analytics) that you use everyday.
Templates we’ve built at CIFL pull data from: Google Analytics, Google Search Console, Facebook Ads, Mailchimp, Reddit, Salesforce, SEMrush, Twitter and a few other random sources.
Articles to Get Started:
Blockspring vs Supermetrics
Just Enough Blockspring
And a Course to Master It:
The Lazy Toolbelt – Automate your Work with Blockspring, Supermetrics and Zapier
2. MANIPULATE YOUR DATA WITH GOOGLE SHEETS FORMULAS
At CIFL, we *do not* recommend learning every single formula.
With just a few key Sheets formulas, you can make your data sing.
Articles to Get Started:
The Google Sheets Query Function
VLOOKUP like the Pros
All the Google Sheets Formulas (plus some Formula Hacks for Marketers)
And a Course to Master It:
The Google Sheets Query Function – Forget your Other Functions
3. VISUALIZE AND SHARE DATA
Analyzing data is way more fun with friends.
Google Sheets plays nicely with Google Data Studio, making it easy to build sexy reports for sharing.
Articles to Get Started:
A Beginner’s Guide to Google Data Studio
Building an Automated KPI Dashboard in Google Sheets
The Google Analytics + Blockspring Action Dashboard
And a Course to Master It:
Google Data Studio, the Lazy Way
PS – If you’d like to just grab all of the free resources, automation templates, and Google Sheets tutorials that CIFL has to offer, claim your invite to the Template Vault on Trello below.