Add new ClickUp tasks to a Google Sheets spreadsheet
Start today
Other popular Google Sheets workflows and automations
- Automatically add your saved tracks in Spotify to a Google spreadsheet
- Automatically log work hours in a spreadsheet
- Log People ringing door bell
- Automatically log every call you make on your Android phone to a Google spreadsheet
- Save your Fitbit sleep logs to a Google Spreadsheet
- Add a new row to Google Sheets for all new files in Dropbox folder
- Create a spreadsheet of new laws, eliminating the need for countless Washington, DC interns
- Back up new texts you receive on your Android device to a Google Spreadsheet
Useful Google Sheets and Scout Alarm integrations
Triggers (If this)
- Mode armedThis Trigger fires when a mode is armed.
- 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.
- Mode disarmedThis Trigger fires when a mode is disarmed.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Alarm triggeredThis Trigger fires when the alarm for a specific mode is triggered.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Alarm dismissedThis Trigger fires when the alarm for a specific mode is dismissed.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Door panel openedThis Trigger fires when any or a specific door panel is opened.
- Door panel closedThis Trigger fires when any or a specific door panel is closed.
- Access sensor openedThis Trigger fires when any or a specific access sensor is opened.
- Access sensor closedThis Trigger fires when any or a specific access sensor is closed.
- Motion detectedThis Trigger fires when any or a specific motion sensor detects motion. Your Scout system must be in an Armed state.
Queries (With)
- History of Access sensor closedThis query returns a list of when any or a specific access sensor was closed.
- 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 whena mode was armedThis query returns a list of when a mode was armed.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of when a Door panel was closedThis query returns a list of when any or a specific door panel was closed.
- 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 a mode was disarmedThis query returns times when a mode was disarmed.
- 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 times Alarm was dismissedThis query returns a list of when the alarm for a specific mode was dismissed.
- 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 when Door panel was openedThis query returns a list of times when any or a specific door panel was opened.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- History of Alarm triggersThis query returns a list of times when the alarm for a specific mode was triggered.
- History of times Access sensor openedThis query returns a list of times when any or a specific access sensor was opened.
- History of Motion detectedThis query returns a list of when any or a specific motion sensor detected motion while your Scout system was in an Armed state.
Actions (Then that)
- Start arming a modeThis Action will arm a mode at your location of choice (home, vacation home, etc).
- 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.
- Disarm a modeThis Action will disarm a mode at your location of choice (home, vacation home, etc).
- 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.
- Disarm all modesThis Action will disarm any mode at your location that is in arming or armed mode.
- Turn on sirenThis Action will turn on the siren in the Scout Hub and Scout Door Panels (if you have any).
- Turn off sirenThis Action will turn off the siren in the Scout Hub and Scout Door Panels (if you have any).
- ChirpThis Action will make the hub chirp.
- Enable key fobThis Action will enable a key fob at your location of choice.
- Disable key fobThis Action will disable a key fob at your location of choice.
IFTTT helps all your apps and devices work better together