The Lazy Toolbelt

Automate your work with Google Sheets, Blockspring and Supermetrics
Intro to the Lazy Toolbelt
In this section, I’ll introduce you to two tools I use to pull raw data into spreadsheets: Blockspring and Supermetrics.  

I use them in different situations, but love them all equally.  



Why the Lazy Toolbelt?
2 mins
WTF is Blockspring?
2 mins
WTF is Supermetrics?
2 mins
What you'll Build
Dive into what the Lazy Toolbelt allows you to build in Sheets.  

Pick apart the design of templates built with both Blockspring and Supermetrics, and learn how to design your own.
Meet the Templates
2 mins
Spreadsheet Template Design
6 mins
The Blockspring Template
10 mins
The Supermetrics Template
10 mins
Wrangling Data with Blockspring
After you build your first Block, you'll understand why some people compare Blockspring to 'painting with data' in a spreadsheet.
First: Install Blockspring
Your Turn: Chaining APIs Together
What Data to Pull?
4 mins
Setting up Blocks
8 mins
Your Turn: Diving into Blockspring
Rounding out the Template
8 mins
Building Dropdown Menus in Sheets
13 mins
Wrangling Data in Supermetrics
Get your feet wet with Supermetrics, and find out why it's such a powerful reporting tool for SEO and PPC marketers.
First: Install Supermetrics
Key Differences in Supermetrics
3 mins
Meet to the Supermetrics Sidebar
4 mins
Building Queries in Supermetrics
10 mins
Your Turn: Firing up Supermetrics
Modifying Supermetrics Queries
4 mins
Your Turn: Getting Nimble with Supermetrics
Wrapping up with Supermetrics
2 mins
Build your own Lazy Toolbelt
Getting started with your own Blockspring or Supermetrics project, featuring starter templates from the CIFL Vault.
Access the Template Vault
Pick an Add-on
4 mins
Build your own Template
Get Help with a Project
Taking Action with your Wrangled Data
All of this data wrangling is useless is we don't do anything with it.  

Learn how to turn data into insights, with some lightweight data analysis in Google Sheets.
Warning: Google Sheets Formulas Incoming
Data Wrangling: the Final Showdown
9 mins
Teasing out your Next Steps
7 mins
Your Turn: Taking Action
Chaining APIs Together with Blockspring
5 mins
Using Blockspring for Team Communication
4 mins