Log the time spent at a specific location in an Excel spreadsheet
How this automation works
Monitor changes to story points in Shortcut with ease. Whenever an estimate is assigned or updated, this Applet logs the details into Microsoft Excel. Perfect for scrum masters and agile coaches, it provides a clear record of how estimates evolve, helping teams analyze accuracy, velocity, and planning improvements during retrospectives. This Applet can also be modified to use Google Sheets!
If
Estimate assigned to story
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
Add row to workbook
Action fields
path
filename
formatted_row
worksheet_name
Services used in this Applet
You might also like...
-
28
-
-
Sync all your new iOS Contacts to an Excel spreadsheet
12
-
-
Automatically add your saved tracks in Spotify to an Excel spreadsheet
10
-
Related services
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.
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.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 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.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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.
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 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.
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.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 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.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a team (group) is assigned to a story in your Shortcut workspace.
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!
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.
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.
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.