An IFTTT WeatherFlow Applet can be used to send station updates to a Google Sheet every 60 seconds ( IFTTT Applet stores 1min data to Google Sheets). The following three Google Sheets can be used to create a full archive the all the data received from the stations and to create a 24-hour dashboard.
-
Sheet1 receives the updates from IFTTT
-
Sheet 1 has a script that runs on the OnUpdate event of Sheet1. This script copies the data to the two Google Sheets below. It then removes the data from Observation log. This is needed to avoid the problem described and solved in this post: Google Sheets, IFTTT and the 2000 row limit - a query [EDIT - and Solution]
-
The Sheet1 sheet receives the updates from IFTTT
-
When there are many thousands of rows of data, Observation log Archive is very slow to open.
-
The Sheet1 sheet receives the updates from IFTTT.
-
Sheet 1 has a script that runs on the OnUpdate event of Sheet1. This script deletes the oldest rows to ensure only 1440 (60*24) rows and copies the rows to â24H Dataâ sheet
-
The purposed of the â24H Dataâ sheet ensures that rows referenced by the âCleaned Dataâ and the âDashboardâ sheet are consistent
-
The âCleaned Dataâ sheet references data in the â24H Dataâ sheet and adds a column to covert the TiimestampEpoch date to Google Sheets date
-
The âDashboardâ sheet weather data statistics and graphs for the last 24 hours.
Installation
-
Copy the three Google to your IFTTT/Weatherflow folder on Google Drive
-
Set the permissions for the scripts in Observation log and Observation log Archive to allow it access
-
Clear (not delete) the rows in the â24H Dataâ sheet to get rid of my data
-
Go to your IFTTT webpage and create the applet with WeatherFlow service to update Observation log Google Sheet
â