Tutorials on all the shiny new tools we use to build data pipelines: APIs, BigQuery, Google Data Studio, Google Sheets, Stitch, Supermetrics and more.
Reviewing all the best SEO APIs out there: Google Search Console, Majestic, Moz and SEMrush. Includes a starter Google Sheets template to get up and running.
Diving into Data Studio: connecting a Google Sheets as a data source, building tables and charts, and styling them with themes.
How we build automated data pipelines at CIFL, using the Google Cloud stack of BigQuery, Sheets and Data Studio.
A bridge connecting Google Sheets to a BigQuery analytics warehouse. Automates creation of BQ views, tables, and uploading of data.
Reviewing the pros and cons of two powerful Google Sheets reporting automation Add-ons, Blockspring and Supermetrics.