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, "On". 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.
When
Filter code
Then
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.
ID TpsdQYe3
Discover more time saving integrations for Google Sheets and WeMo Insight Switch