Have Fingbox record a presence log in a Google Spreadsheet
Start today
Popular Fing and Google Sheets workflows and automations
Useful Fing and Google Sheets integrations
Triggers (If this)
- Internet Outage event happenedTrigger requires you only to have a free Fing Account, you don't need a Fingbox to use this! Trigger fires when there is an Internet outage event on your ISP impacting your location, both when it starts and it is resolved.
- 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.
- Someone arrivedThis trigger fires when someone of a user group is detected in or nearby your network.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Everyone leftThis trigger fires when no one of a user group is detected in or nearby your network.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- A user arrivedThis trigger fires when a user is detected in or nearby your network.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- A user leftThis trigger fires when a user is no more detected nearby.
- A Fingbox is back onlineThis trigger fires when a fingbox get re-connected to the network. This is usually an indication that the network connectivity came back online
- A Fingbox goes offlineThis trigger fires when a fingbox get disconnected from the network. This is usually an indication that the network connectivity is not working
- New device foundThis trigger fires when a new device is detected in your network.
- Internet Speed droppedThis trigger fires when an Internet speed drop or slow down is detected, on download or upload channel.
- Device is ONThis trigger fires when a device is detected ON in your network.
- Device is OFFThis trigger fires when a device is detected OFF (offline) in your network.
- Internet IP changedThis trigger fires when your public Internet IP changes.
Queries (With)
- History of internet speed dropsThis query returns a list of instances when internet speed dropped or slow down was detected, on download or upload channel. Note: this query will only return future events after this Applet is created.
- 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 someone arrivedThis query returns a list of when someone of a user group was detected in or nearby your network.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of everyone leavingThis query returns a list of times when no one of a user group is detected in or nearby your network.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of Internet Outage eventsThis query returns a list of events when there was an Internet outage event on your ISP impacting your location, both when it starts and it was resolved. You only need to have a free Fing Account, you don't need a Fingbox to use this!
- 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 users leftThis query returns a list of time when a user was no longer detected nearby.
- 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 devices foundThis query returns a list of when a new device is detected in your network.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of a user arrivedThis query returns a list of when a user was detected in or nearby your network.
- History of device is ONThis query returns a list of when a device was detected ON in your network.
- History of A Fingbox is back onlineThis query returns a list of when a fingbox get re-connected to the network.
Actions (Then that)
- Turn on Internet accessResume the access to internet for a given user or category.
- 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.
- Pause Internet accessSuspend the access to internet for a given user or category.
- 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.
- Play LED effectThis action will play a light effect on Fingbox LED.
Fing and Google Sheets resources
IFTTT helps all your apps and devices work better together