Blog

API Authentication Apps Script Reference

This post is a summary of common authentication protocols for API authentication with Apps Script.

I got fed up digging around in my Drive folder for old scripts to refresh my memory on the syntax, so I created this reference.

It’s not a comprehensive post on how to connect to APIs, instead, it’s a short summary of common protocols for easy reference.(If you’re new to APIs, start with my Apps Script API tutorial for beginners.)

This post looks at four different API authentication methods:

  1. No API authentication
  2. Requires API key in query string
  3. Requires API key in header
  4. OAuth2: Secure API authentication

Continue reading API Authentication Apps Script Reference

How To Use The Choose Function In Google Sheets

The CHOOSE Function in Google Sheets lets you choose between different options.

It’s a lookup function, akin to a limited VLOOKUP rather than an alternative to the IF function.

It takes an index number and returns a value at that numbered position from the list of possible options.

Here’s a simple example:

=CHOOSE(1,"A","B")

which will output:

CHOOSE Function in Google Sheets

The first argument is the index number: 1.

Subsequent arguments are possible choices. The CHOOSE function returns the value at index position 1 in this case, i.e. “A”.

If I changed the index number to 2, the CHOOSE function would output “B”.

🔗 Get this example and others in the template at the bottom of this article.

Continue reading How To Use The Choose Function In Google Sheets

A Behind The Scenes Look At How I Create A Technical Video Course

Last week I launched a new Google Sheets course — The QUERY Function In Google Sheets — so I thought it would be interesting and helpful to share how such a course comes about.

It’s my 14th online course and my 19th launch. Along the way, I’ve made just about every mistake in the book, but I’ve now settled on a reliable framework for online course creation, the outline of which I share below.

Online Course Screenshot

I think about technical video course creation in six distinct phases:

  1. Ideation
  2. Research
  3. Planning
  4. Course Creation
  5. Launch
  6. Post-launch

Continue reading A Behind The Scenes Look At How I Create A Technical Video Course

How To Create A Heat Map In Google Sheets

Heat maps in Google Sheets are a great way to add context to your data.

They bring attention to the high and low values in your data, to outliers that demand attention.

Best of all, heat maps in Google Sheets are easy to create.

Consider this dataset showing monthly temperatures for Washington D.C.:

Temperature Data In Google Sheets

Without any formatting, it’s boring to look at, doesn’t convey any immediate takeaways, and it’s hard to spot trends such as which years were hotter than others.

Now compare that to the same dataset with a heat map overlay (click to enlarge):

Temperature Heat Map In Google Sheets

Wow! The stories jump off the page at you now. You can easily compare the years and see which years had longer winters, or hotter summers.

Let’s see how to create a heat map in Google Sheets.

Continue reading How To Create A Heat Map In Google Sheets

How To Create Arrays In Google Sheets (a.k.a. Array Literals)

Arrays in Google Sheets are collections of data, consisting of rows and columns. You can use arrays in formulas in the same way that you use regular A1-type ranges.

You construct arrays in Google Sheets with curly brackets: { }

They’re also known as ARRAY LITERALS.

Continue reading How To Create Arrays In Google Sheets (a.k.a. Array Literals)