Put all your completed tasks in a Google Spreadsheet
Start today
Other popular Google Sheets workflows and automations
- Add new Square payments to a spreadsheet
- Save all of your liked videos in a spreadsheet
- Keep a log of your recently played tracks
- Track your daily Fitbit activity in a Google spreadsheet
- Add a new row to Google Sheets for all new files in Dropbox folder
- Create a new row in Google Sheets when your business is tagged in a Facebook photo
- Automatically add your saved tracks in Spotify to a Google spreadsheet
- Create a Google spreadsheet entry every time you charge your Android device
Useful Google Sheets and MobiLinc integrations
Triggers (If this)
- A lock is locked, unlocked, or jammedThis trigger fires when a lock changes status.
- 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.
- A device turned on or offThis trigger fires when an INSTEON or Z-Wave device turns on or off.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- A variable is set to a valueThis trigger fires when a state or integer variable is set.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- A security area changed stateThis trigger fires when a security area changed state to armed or disarmed.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- A program is true or falseThis trigger fires when a program is true or false.
- A sensor turned on or offThis trigger fires when a Motion, Water Leak, TriggerLinc, or Door sensor turns on or off.
- A Z-Wave device is reporting low batteryThis trigger fires when any Z-Wave device is reporting 20% or less battery remaining.
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.
- History of lock locks, unlocks, or jamsThis query returns a list of when a lock changes status.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of device ons or offsThis query returns a list of when an INSTEON or Z-Wave device turns on or off.
- 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)
- Run, enable, or disable a programThis action will enable, disable, or run a program's If, Then, or Else condition.
- 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.
- Turn a light on, off, or dimThis action will turn an INSTEON or Z-Wave light on, off, or dim.
- 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.
- Lock or unlock a doorThis action will lock or unlock a Z-Wave lock.
- Turn a scene on or offThis action will turn a scene on or off.
- Set a variableThis action will set a state or integer variable to a custom value.
- Arm or disarm a security areaThis action will arm or disarm a security area.
- Adjust a thermostatThis action will adjust a thermostat's mode and setpoint.
- Open or close the garage doorThis action will open or close the garage door controlled by an INSTEON IOLinc.
- Turn a switch on or offThis action will turn an INSTEON, Z-Wave, or X10 device on or off.
IFTTT helps all your apps and devices work better together