Add a row to spreadsheet in Google Drive when error system events occurred on QNAP Device
Start today
Popular Google Sheets and QNAP workflows and automations
Useful Google Sheets and QNAP 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.
- New file in your folderThis trigger fires every time when a new file is stored to the selected folder.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- New system eventThis trigger fires every time a new system event occurs on your QNAP device. This trigger is only available to the device administrator.
- 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.
- History of system eventsThis query returns a list of every time a new system event occurs on your QNAP device. This trigger is only available to the device administrator.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of files in your folderThis query returns a list of every time when a new file is stored to the selected folder.
- 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)
- Download file from URLThis action will download a file from a given URL to your NAS at a path which you specify.
- 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.
- Append text to fileThis action will append to a text file as determined by the filename and folder path you specify. If there is no file present, a new file will be created. Once a file’s size reaches to maximum a new file will be created.
- 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 user profile picture on QNAP NASThis action will set/change the user profile picture on QNAP Device.
- Control music on QNAP Device via Music StationThis action allows you to control basic music station operations like stop playing current song, play next song in the current playlist and play previous song in the current playlist. (This action requires IFTTT Agent v1.1 or above, Music Station v5.0.4 or above and Media Streaming addon v430.1.0.3 or above to be installed on your QNAP device)
- Play any music station playlist on QNAP DeviceThis action allows you to play any music station playlist. (This action requires IFTTT Agent v1.1 or above, Music Station v5.0.4 or above and Media Streaming addon v430.1.0.3 or above to be installed on your QNAP device)
- Control surveillance cameras of QNAP Device via Surveillance StationThis action allow the user to control the camera recording via Surveillance Station (Requires IFTTT Agent v1.1 or above and Surveillance Station v5.1.1.2 or above to be installed on your QNAP device)
- Control device powerThese actions will either shutdown the device, reboot the device or put the device in sleep mode Action Fields. (This action requires IFTTT Agent v1.1 or above to be installed on your QNAP device)
IFTTT helps all your apps and devices work better together