Log QNAP system events to Google Sheets
1 ready-made Google Sheets and QNAP Applets
Turn one on, or build your own. Google Sheets can start an automation with "Cell updated in spreadsheet", and IFTTT can then run "Append text to file" on QNAP.
Automate Google Sheets and QNAP from your AI assistant
Ask OpenClaw to create Google Sheets applets for you, right from your AI assistant, with IFTTT MCP.
Set up IFTTT MCP
Create your own Google Sheets and QNAP workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
28 triggers, queries, and actions
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
New file in your folder
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time when a new file is stored to the selected folder.
New row added to spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new row is added to a spreadsheet you specify.
New spreadsheet added to folder
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This 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 system event
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time a new system event occurs on your QNAP device. This trigger is only available to the device administrator.
New worksheet in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a new worksheet is added to a spreadsheet you specify.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
History of files in your folder
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of every time when a new file is stored to the selected folder.
History of rows added to spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.
History of spreadsheets added to folder
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This 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 system events
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This 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.
History of when Cell was updated in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a particular cell was updated within the spreadsheet you specify.
History of worksheets in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new worksheet is added to a spreadsheet you specify.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Append text to file
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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.
Control device power
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
These 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)
Control music on QNAP Device via Music Station
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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)
Control surveillance cameras of QNAP Device via Surveillance Station
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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)
Create spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.
Download file from URL
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will download a file from a given URL to your NAS at a path which you specify.
Play any music station playlist on QNAP Device
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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)
Set user profile picture on QNAP NAS
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will set/change the user profile picture on QNAP Device.
Update cell in spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
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.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Append text to file
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Control device power
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
These 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)
Control music on QNAP Device via Music Station
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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)
Control surveillance cameras of QNAP Device via Surveillance Station
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This 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)
Create spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Download file from URL
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will download a file from a given URL to your NAS at a path which you specify.
Build an automation in seconds!
If
Select a trigger the automation will use
Then
Select an action the automation will perform
You can add delays, queries, and more actions in the next step!
GET STARTED
How to connect to a Google Sheets automation
Find an automation using Google Sheets
Find an automation to connect to, or create your own!Connect IFTTT to your Google Sheets account
Securely connect the Applet services to your respective accounts.Finalize and customize your Applet
Review trigger and action settings, and click connect. Simple as that!Upgrade your automations with
-
Connect to more Applets
Connect up to 20 automations with Pro, and unlimited automations with Pro+ -
Add multiple actions with exclusive services
Add real-time data and multiple actions for smarter automations -
Get access to faster speeds
Get faster updates and more actions with higher rate limits and quicker checks
