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.
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
To copy the Google Sheets, you first need to log into your Google account, then open one of the three Google Sheets you intend to copy, and then select the File/Make a Copy menu item to copy to your Google Drive.
The is no need to request access to the Goggle Sheets. You already have all the access needed to make the copies you need.
Great write-up. I added a link to your second post at the bottom of the original one to make sure someone sees it if they didnât read the rest of the thread.
@george1 After copying the sheets, open your copy of Observation log and click Tools/Script Editor. This will open a new tab called âArchive Observation Logâ. Then click on the Run button. You will be asked to give permission to the script.
A new Google Sheet will be created called: Copy of Observation log. In this Google Sheet click Tools/Script Editor. This will open a new tab called âArchive Observation Logâ.
Then click on the Run button. You will be asked to give permission to the script.
Choose your account. You will get the worrying message "Google hasnât verified this app. Click on âAdvancedâ and the Go to âArchive Observation Log (unsafe)â.
Rememer you have to copy Observation log Archive and Observation log Dashboard Google Sheets.
I think when we try to copy the observation.log file it opens and runs the script before we can make the copy. Since when I go into tools/Script Editor it says this:
Thanks for the reply. But thatâs not the issue. Iâm not able to open that specific sheet (Observation Log Archive). It gives me the access denied message when I click on it to try to open it. No problem opening and copying the other two sheets.
The instructions did not tell you that inside the script, you will need to change the file ID associated with the file
source â observation log
archive â> observation log archive
dashboard â> observation log dashboard
The script inside the observation log that you copy from cswilly has the file ID uniquely to his Google Drive. This file ID is different for the file you copy to your Google drive. Theyâre the text in your URL after https://docs.google.com/spreadsheets/d/.
Make sure after you make the changes to these file IDs, save the script and then execute it. Google will ask you permission the first time. Choose your account. You will get the worrying message "Google hasnât verified this app. Click on âAdvancedâ and the Go to âArchive Observation Log (unsafe)â. Repeat this with the script inside âObservation Log Dashboardâ file in your Google Drive.
Create âobservation log archiveâ by making a copy from your âobservation logâ. No need to do anything with script here.
I got mine to work only for a few minutes now so hopefully I will see the reading move from observation log to observation log archive and observation log dashboard.
