Numerly + Google Sheets + IFTTT

I believe one of the most important channels for Numerly is the Google Sheets channel. Google Sheets is such a versatile tool, and showing a cell value from a sheet can actually bridge gaps where Numerly might not have an official channel. Here’s a neat trick that I found which I’d like to share.

If you’re already a user of IFTTT, then you’ll know how powerful it can be. If you’re not already a user, then I highly suggest you sign up and start automating some of your life.

 

I setup an Applet in IFTTT to add a row to a given spreadsheet with the day’s date and current temperature. Then, I added the formula below to a different cell which grabs the latest value from column B.

=INDEX(B1:B, COUNT(B1:B))

Here’s a screenshot to illustrate a few days worth of data from IFTTT.

screen-shot-2017-02-28-at-6-09-54-am
Cell F1 uses a formula to grab the latest value from column B

 

With Numerly + Google Sheets + IFTTT, you’ll be able to place the value from cell F1 onto your Dashboard to display today’s forecasted high temperature.

Note that the Weather Underground service in IFTTT has many other triggers and ingredients to use so you don’t have to limit yourself to just the high temperature. You could set up separate items on your Numerly dashboard for high temperature, low temperature, UV index, humidity, wind speed, pollen count, etc.

How cool is that?

Advertisements

One thought on “Numerly + Google Sheets + IFTTT

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s