WeMo Insight switch off, add a row to a Google sheet

1
Connect

Choose same sheet and all events will be logged there. Default is "IFTTT/Wemo/Insight Activity." Rows added with 8 columns. A: Insight switch name. B: Event, "Off". C: Wemo "at" time as a string. D: Wemo "at" time turned into a Sheet date/time number. E: IFTTT "applet ran at" time as string. F: IFTTT "applet ran at" time as Sheet date/time number. G: IFTTT "triggered at" time as string. H: IFTTT "triggered at" time as Sheet date/time number. Wemo time has no secs, IFTTT times do.

If

WeMo Insight Switch icon
Switched off

This Trigger fires every time your WeMo Insight Switch is turned off.

When

Filter code

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

Discover more time saving integrations for Google Sheets and WeMo Insight Switch