Google Sheets to BigQuery: Schedule a Daily Data Transfer for Free
Suppose you’ve got new data coming in to Google Sheets each day. You want to automatically push this new data to BigQuery each day. How do you do it? I’ll show you.
Data
How to Match Sales to Facebook Ads Campaigns with an Offline Event Set
Facebook has an incredibly valuable feature that allows you to match sales to your campaigns, ad sets, and ads. This …
The Ultimate Google Sheets Formula to Join Two Tables
If you were stranded on a desert island, this is the Google Sheets formula you’d want to have with you. …
Google Sheets Formula to Get Column by Name / Label
So, you’re working with Google Sheets and you realize, “Hey, I need to get a specific column. But wait… I …
Auto-Lead Data Format XML Template Generator
Here’s a handy little tool I created to generate a customized ADF template.
Query Google Sheets by Column Name
One of the most handy functions in Google Sheets is the QUERY function. Unfortunately, Google Sheets doesn’t have a feature …