Log every time you disconnect from OnHub into a Google Spreadsheet
Start today
Popular Google Sheets and Google Wifi workflows and automations
3- Device connect logs4
- Log every time you disconnect to OnHub in a Google Spreadsheet109
- Savanah Home2
- Jacob Home1
Useful Google Sheets and Google Wifi integrations
Triggers (If this)
New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
Device ConnectsThis Trigger fires every time a device connects to Google Wifi.- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Device DisconnectsThis Trigger fires every time a device disconnects from Google Wifi.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
Queries (With)
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of device disconnectsThis query returns a list of when a device disconnects from Google Wifi.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of device connectsThis query returns a list of when a device connects to Google Wifi.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
- Add row to spreadsheetThis 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.
- Prioritize DeviceThis Action will prioritize a device for 1 hour on your Google Wifi network.
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
Google Sheets and Google Wifi resources
Applets for Google
You can do so much more with Google, Google Drive, Google Calendar, Google Assistant, Google Home, Google Sheets, Google Wifi, and your other favorite services. Check out our favorite tips!
How to write a business plan (with examples)
Click to learn how to write a business plan and automate it with IFTTT!
Best automation blogs of 2025
Check out our best and most read blog articles of 2021. A list of Applet collections and some round ups of our most-enabled services.
IFTTT helps all your apps and devices work better together