So, you’re working with Google Apps Script. Perhaps you’re working in Google Sheets. You’ve got a long list of URLs …
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.
Step by step instructions for recreating the equivalent of a (SQL) right outer join in Google Sheets.
Facebook has an incredibly valuable feature that allows you to match sales to your campaigns, ad sets, and ads. This …
If you were stranded on a desert island, this is the Google Sheets formula you’d want to have with you. …
The Google Sheets function “QUERY” is one of the handiest functions in a Google Sheets wizard’s toolbox. And one of the great things about QUERY is that it can interpret the first row of data as a header row. But what if you don’t want the header row at all?
Yes, you can absolutely name a column and use the column name in your formulas instead of the the usual A1-style column reference. Here’s how.
Sometimes you’ll have multiple separate ranges or columns or even entire sheets that you’ll want to “stack” on top of each other (i.e. append one or more to another) so that you end up with a single huge master range. Here’s how you achieve this.
In Google Sheets is there a simple way to convert a column index to the corresponding column letter? Absolutely. Here’s how you do it in two easy steps.
