Back
Camera widget Specific QR code scanned. Microsoft 365 Excel Add row to workbook.

Add new QR scan data to Microsoft 365 Excel workbook

Connect

How this automation works

Automatically record QR code scans into your Microsoft 365 Excel workbook. This Applet runs when a specific QR code is scanned using the Camera widget and adds a new row with scan details to your chosen worksheet. Perfect for logging check-ins, inventory items, or time entries. Note: Install the IFTTT app and add the Camera widget to your home screen.

If
Camera widget icon
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a specific QR code is scanned using the Camera Widget.
OccurredAt Content Latitude Longitude LocationMapUrl LocationMapImageUrl
Then
Microsoft 365 Excel icon
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.
path filename formatted_row worksheet_name

Services used in this Applet

Create your own Microsoft 365 Excel and Camera widget 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.

11 triggers, queries, and actions

Any new photo

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This Trigger fires every time you take any new photo via Do Camera.

Any QR code scanned

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a new QR code is scanned using the Camera Widget

Any URL QR code scanned

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a new QR code that is a URL (http:// or https://) is scanned using the Camera Widget

Cell updated in workbook

Pro icon
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.

New row added to workbook

Pro icon
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.

QR code scanned - regular expression match

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a QR code is scanned, matching a "regular expression" search, using the Camera Widget.

QR code scanned - wildcard match

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a QR code is scanned, matching a wildcard search, using the Camera Widget. [See our help center for more information](https://help.ifttt.com/hc/en-us/articles/36961503432987-How-to-use-QR-codes-with-IFTTT).

Specific QR code scanned

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a specific QR code is scanned using the Camera Widget.

Current value of a cell

Pro plus icon
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.

Add row to workbook

Pro icon
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.

Update cell in workbook

Pro icon
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

Pro icon
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.

Any new photo

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This Trigger fires every time you take any new photo via Do Camera.

Any QR code scanned

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a new QR code is scanned using the Camera Widget

Any URL QR code scanned

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a new QR code that is a URL (http:// or https://) is scanned using the Camera Widget

Cell updated in workbook

Pro icon
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

Pro plus icon
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.

New row added to workbook

Pro icon
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.

QR code scanned - regular expression match

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a QR code is scanned, matching a "regular expression" search, using the Camera Widget.

QR code scanned - wildcard match

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a QR code is scanned, matching a wildcard search, using the Camera Widget. [See our help center for more information](https://help.ifttt.com/hc/en-us/articles/36961503432987-How-to-use-QR-codes-with-IFTTT).

Specific QR code scanned

Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
Triggered when a specific QR code is scanned using the Camera Widget.

Update cell in workbook

Pro icon
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.

Build an automation in seconds!

You can add delays, queries, and more actions in the next step!

More on Microsoft 365 Excel and Camera widget

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.

Explore Microsoft 365 Excel

More integrations with Microsoft 365 Excel

About Camera widget

The quickest way to save and share your photos. This service works with your phone's camera and creates widgets that you can use from your home screen.

Explore Camera widget

More integrations with Camera widget

IFTTT helps all your apps and devices work better together

Get started for free