Log location entries and exits to Microsoft 365 Excel
by
About this Applet
Automatically record every estimate assignment or change in Shortcut to a Microsoft Excel 365 worksheet. Each update adds a new row with story details, helping teams track story point history over time. Ideal for agile coaches and scrum masters looking to analyze velocity and estimation patterns in retrospectives.
If
Trigger ingredients
StoryId
StoryName
StoryUrl
StoryDescription
StoryType
CreatedAt
UpdatedAt
RequestedById
OwnerIds
TeamId
TeamName
IterationId
IterationName
IterationStartDate
IterationEndDate
IterationStatus
Estimate
CommentIds
CompletedAt
WorkflowId
WorkflowName
WorkflowStateId
WorkflowStateName
EpicName
FileUrls
TaskDescriptions
Blocked
Blocker
Then
Action fields
Enter the folder path...
and enter the filename
Formatted row
The name of the worksheet
Services used in this Applet
You might also like...
-
45
-
-
Add new saved Spotify tracks to Microsoft Excelby
26
-
-
Add new iOS Contacts to Microsoft 365 Excelby
19
-
Related services
-
-
App store rating
Create your own Shortcut and Microsoft 365 Excel 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.
22 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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the workbook you specify.
Epic created
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a new epic is created in your Shortcut workspace.
Estimate assigned to story
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when an estimate (story points) is assigned or changed on a story.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a new row is added to a workbook you specify.
New story created
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a story is created in your Shortcut workspace.
Owner assigned to story
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when an owner is assigned to a story in your Shortcut workspace.
Story completed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a story is moved to a completed state in your Shortcut workspace.
Story updated
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when an existing story is updated in your Shortcut workspace.
Team assigned to story
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a team (group) is assigned to a story in your Shortcut workspace.
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.
Find a story
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.
Search your Shortcut workspace for stories. Supports Shortcut's search operators (e.g. state:, type:, owner:, label:, epic:) in addition to plain keywords.
Get a story by ID
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.
Look up a single Shortcut story by its numeric ID and return its full details.
List epics
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.
List the active (non-archived) epics in your Shortcut workspace, most recently updated first.
List iterations
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.
List the iterations (sprints) in your Shortcut workspace, most recent first.
List team members
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.
List the active members of your Shortcut workspace.
List workflows and states
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.
List the active workflows in your Shortcut workspace along with their states.
Add a Comment to a Story
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.
Adds a comment to an existing story.
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.
Create Epic
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.
Creates a new epic in your Shortcut workspace.
Create story
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.
Creates a new story in your Shortcut workspace.
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.
Update Story State
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.
Moves a story to a different workflow state.
Add a Comment to a Story
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.
Adds a comment to an existing story.
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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the workbook you specify.
Create Epic
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.
Creates a new epic in your Shortcut workspace.
Create story
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.
Creates a new story in your Shortcut workspace.
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.
Epic created
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a new epic is created in your Shortcut workspace.
Estimate assigned to story
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when an estimate (story points) is assigned or changed on a story.
Find a story
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.
Search your Shortcut workspace for stories. Supports Shortcut's search operators (e.g. state:, type:, owner:, label:, epic:) in addition to plain keywords.
Get a story by ID
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.
Look up a single Shortcut story by its numeric ID and return its full details.
List epics
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.
List the active (non-archived) epics in your Shortcut workspace, most recently updated first.
List iterations
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.
List the iterations (sprints) in your Shortcut workspace, most recent first.
Build an automation in seconds!
If
Select a trigger the automation will use
Cell updated in workbook
Epic created
Estimate assigned to story
New row added to workbook
New story created
Owner assigned to story
Story completed
Story updated
Team assigned to story
Then
Select an action the automation will perform
Add a Comment to a Story
Add row to workbook
Create Epic
Create story
Update cell in workbook
Update Story State
You can add delays, queries, and more actions in the chat.
More on Shortcut and Microsoft 365 Excel
About Shortcut
Streamline your software development workflow with Shortcut, the agile project management platform designed for modern teams. Effortlessly track issues, manage sprints, and plan roadmaps to deliver products faster and more efficiently. Shortcut empowers your team to collaborate seamlessly, ensuring every task from strategic planning to product development is organized and actionable.
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.