Track when your LinkJapan device is turned on in a Google Sheet
Start today
Other popular LinkJapan eHome workflows and automations
-
- "Turn on LinkJapan device" with Alexa
77 - Turn on your LinkJapan device when your BroadLink Switch it turned on
- Turn on your LinkJapan device when the sun rises
- Change mode on your LinkJapan device with the press of a button 1
- Turn on your LinkJapan device when the sun sets
- Turn your LinkJapan device on or off when an event from your Google Calendar starts
Useful LinkJapan eHome and Google Sheets 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 turns on or offThis trigger fires when a device turns on or off
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- 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.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- 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)
- Turn device on or offThis action will turn a device on or off
- 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.
- Change modeThis action will control the mode of your device
- 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.
- Set temperatureThis action control the temperature of your device
- Set windspeedThis action will control the windspeed of your device
- Set channelThis action will control the channel of your TV
- Adjust volumeThis action adjust the volume of your device
- Mute adjustmentThis action adjust your device to mute or unmute
- Adjust channelThis action can adjust your TV/STB to the previous or next
- Adjust brightnessThis will adjust the brightness of the light configured under your eRemote mini/eRemote
- PlayThis action can control your TV/STB to play
- Fast ForwardThis action can control your TV/STB to fast forward
- RewindThis action can control your TV/STB to rewind
- PauseThis action can control your TV/STB to pause
- ResumeThis action can control your TV/STB to resume
IFTTT helps all your apps and devices work better together