Log daily currency rates from Finance to Google Sheets and Excel
Other popular Microsoft 365 Excel workflows and automations
-
-
-
Log missed Android calls to Microsoft Excel
-
-
-
-
-
- 1+
Log new Google Drive files to Google Tasks, Sheets, and Excel -
-
Send Gmail alert when an Excel cell updates
1
-
-
Log Shortcut estimate updates to Microsoft Excel 365
-
-
Copy new Google Sheets rows to Microsoft Excel
14
-
-
Log new Android notifications to Excel workbook
-
-
Log SmartThings door closures to Microsoft 365 Excel
-
-
Log SmartThings door openings to Microsoft 365 Excel
-
Automate Microsoft 365 Excel and U-tec Ultraloq Smart Lock from your AI assistant
Have Claude, ChatGPT, or Cursor build and run Microsoft 365 Excel and U-tec Ultraloq Smart Lock automations for you, like “Log daily currency rates from Finance to Google Sheets and Excel”, with IFTTT MCP.
Set up IFTTT MCP
Create your own Microsoft 365 Excel and U-tec Ultraloq Smart Lock 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.
13 triggers, queries, and actions
Cell updated in workbook
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 workbook you specify.
Lock is locked
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 lock is locked
Lock is locked by specific person
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 your lock is locked by a specific person.
Lock is unlocked
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 lock is unlocked
Lock unlocked by specific person
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 your lock is unlocked by a specific person.
New row added to workbook
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 workbook 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 workbook.
History of lock being unlocked
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 the lock was unlocked.
History of lock unlocks by specific person
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 your lock was unlocked by a specific person.
Add row to workbook
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 worksheet you specify in the workbook.
Lock
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 locks the door
Unlock
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 unlocks the door
Update cell in workbook
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 workbook you specify.
Add row to workbook
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 worksheet you specify in the workbook.
Cell updated in workbook
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 workbook 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 workbook.
History of lock being unlocked
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 the lock was unlocked.
History of lock unlocks by specific person
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 your lock was unlocked by a specific person.
Lock
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 locks the door
Lock is locked
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 lock is locked
Lock is locked by specific person
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 your lock is locked by a specific person.
Lock is unlocked
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 lock is unlocked
Lock unlocked by specific person
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 your lock is unlocked by a specific person.
New row added to workbook
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 workbook you specify.
Unlock
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 unlocks the door
Build an automation in seconds!
If
Select a trigger the automation will use
Cell updated in workbook
Lock is locked
Lock is locked by specific person
Lock is unlocked
Lock unlocked by specific person
New row added to workbook
Then
Select an action the automation will perform
Add row to workbook
Lock
Unlock
Update cell in workbook
You can add delays, queries, and more actions in the next step!
GET STARTED
How to connect to a Microsoft 365 Excel automation
Find an Applet using Microsoft 365 Excel and U-tec Ultraloq Smart Lock
Find an automation to connect to, or create your own!Connect IFTTT to your accounts
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
Microsoft 365 Excel and U-tec Ultraloq Smart Lock tips, tools, and resources
-
Business
5 best cloud storage apps to access docs easily
-
Business
What is Dropbox: everything you need to know
-
Business
Best email apps for Android in 2026
-
Productivity
Evernote vs OneNote and Automations with IFTTT
-
Business
Google Meet versus Zoom
-
Business
Evernote vs OneNote; Best note-taking app for you
More on Microsoft 365 Excel and U-tec Ultraloq Smart Lock
About Microsoft 365 Excel
Microsoft 365 Excel is a powerful spreadsheet program used for organizing, analyzing, and visualizing data. Leverage its capabilities to manage finances, track projects, and perform complex calculations with ease. Connect Microsoft 365 Excel to IFTTT to automate data entry, generate reports, and trigger actions based on spreadsheet changes. Optimize your data workflows and enhance productivity across your personal and professional tasks.
About U-tec Ultraloq Smart Lock
Ultraloq provides you with an ultimate keyless experience - Real Keyless for maximum flexibility and convenience. You are free to use fingerprint, code, key fob or smartphone to unlock. You can let your guests in by sharing an Ekey to them. With Ultralog Bridge, you can access and unlock Ultraloq remotely. Buy now'Buy'