Jacob Home
Start today
Triggers (If this)
Queries (With)
Actions (Then that)
Popular Google Sheets and Google Wifi workflows and automations
-
1
-
-
Savanah Home
2
-
-
Device connect logs
4
-
-
Log every time you disconnect to OnHub in a Google Spreadsheet
109
-
-
Log every time you disconnect from OnHub into a Google Spreadsheet
3
-
Useful Google Sheets and Google Wifi integrations
Triggers (If this)
-
New spreadsheet added to folder
This 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 Connects
This Trigger fires every time a device connects to Google Wifi.
-
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
-
Device Disconnects
This Trigger fires every time a device disconnects from Google Wifi.
-
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
-
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
New spreadsheet added to folder
This 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 Connects
This Trigger fires every time a device connects to Google Wifi.
New worksheet in spreadsheet
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Device Disconnects
This Trigger fires every time a device disconnects from Google Wifi.
New row added to spreadsheet
This trigger fires when a new row is added to a spreadsheet you specify.
Cell updated in spreadsheet
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Queries (With)
-
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
-
History of device disconnects
This query returns a list of when a device disconnects from Google Wifi.
-
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
-
History of device connects
This query returns a list of when a device connects to Google Wifi.
-
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
-
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
-
History of spreadsheets added to folder
This 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 spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Current values of a row
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of device disconnects
This query returns a list of when a device disconnects from Google Wifi.
Current value of a cell
This query returns the current value of a single cell in your spreadsheet.
History of device connects
This query returns a list of when a device connects to Google Wifi.
History of rows added to spreadsheet
This query returns a list of when a new row is added to a spreadsheet you specify.
History of when Cell was updated in spreadsheet
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of spreadsheets added to folder
This 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 spreadsheet
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Actions (Then that)
-
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.
-
Prioritize Device
This Action will prioritize a device for 1 hour on your Google Wifi network.
-
Update cell in spreadsheet
This 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.
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.
Prioritize Device
This Action will prioritize a device for 1 hour on your Google Wifi network.
Update cell in spreadsheet
This 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
How to write a business plan (with examples)
Click to learn how to write a business plan and automate it with IFTTT!
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!
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