A beginner's guide
Explore
Plans
Mobile menu Close menu
GarageWiFi & Gates Door is open. Google Sheets Add row to spreadsheet.

When garage door is open, register the time in Google Sheets

by GarageWiFi & Gates
10
Connect

When garage door is open, register the time in Google Sheets

If

GarageWiFi & Gates icon
Door is open

This trigger fires when a door is open. This trigger will only work with "garage mode". Remote access must be enabled.

Then

Google Sheets icon
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.

Fewer details
More details