Save the hourly average of your device's readings directly to a Google Spreadsheet. Every hour, when a new average of the past 60 minutes of readings is available for your device, it will be automatically saved to a spreadsheet.
If
Hourly average AQI from my device
This trigger fires when the hourly AQI of your device is updated.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Explore more great ways to automate Google Sheets and Kaiterra