The Scenario
Your sprint retrospective ended 20 minutes ago. The team reprioritized 40 tasks — new priority values are already in column B of your Google Sheet, next to the task IDs in column A. Some tasks moved from Medium to ASAP. Some dropped from High to Low. A few had their due dates shifted too, now in column C.
Motion has those same 40 tasks. None of them reflect the new priorities yet.
You ran this update manually after the last sprint. It took 35 minutes — opening each task, changing the priority dropdown, saving, moving to the next. You finished six minutes before the next standup started.
The bad version:
- Open Motion. Search for task ID from row 1. Click the task. Find the priority dropdown. Change it. Save.
- Search for the next ID. Motion does not keep you in the list view — you go back to the search bar. Search again.
- At task 22, you accidentally set ASAP instead of Medium. You catch it 10 tasks later when you spot the inconsistency.
- At task 35, you realize you forgot to update the due dates on the tasks where column C had a new value.
The sprint is live and the team's schedules are already showing the old priorities.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the task IDs and new values from your sheet and sends the updates to Motion directly. Open the sidebar and ask.
For each row in this sheet, update the Motion task whose ID is in column A — set priority to the value in column B and status to the value in column C.
What You Get
- All 40 Motion tasks updated with the new priority values from column B.
- If column C has a new due date, those are updated in the same pass.
- Any row where the task ID is not found in Motion surfaces an error note in a status column — no silent misses.
What If the Data Is Not Quite Ready
The priority values in the sheet do not match Motion's accepted values
Your sheet uses "High", "Medium", "Low" but Motion expects "ASAP", "Medium", "Low".
For each row in this sheet, normalize the priority value in column B so that High maps to ASAP and Low maps to Low. Then update the Motion task whose ID is in column A with the normalized priority.
You only want to update tasks where the priority actually changed
The sheet has all 40 tasks but only 15 have a new priority — updating the unchanged ones wastes API calls.
For each row where column D says "changed", update the Motion task whose ID is in column A — set priority to the value in column B.
Some task IDs no longer exist in Motion
A few tasks were deleted from Motion since the sheet was created.
Read task IDs from column A and new priorities from column B. For each row, update the Motion task priority. If the task is not found, write "not found" in column C. If the update succeeds, write "updated" in column C.
Full reprioritization — clean values, update priorities and due dates, and report status
The full sprint update in one pass: normalize priority values, update priorities and due dates, write a status for every row.
In this sheet, normalize the values in column B so that High maps to ASAP, Med maps to Medium, and Low stays as Low. Then for each row, update the Motion task whose ID is in column A — set priority to the normalized column B value and, if column C is not blank, update the due date to column C. Write "updated" or "error: [reason]" in column D for every row.
One prompt handles what used to take 35 minutes of task-by-task navigation.
Try It
Open your sprint reprioritization sheet with task IDs and new priority values, then Get the 7-day free trial of SheetXAI and ask it to apply the batch update to Motion. For related workflows, see how to bulk-create Motion tasks from a sprint sheet or update custom field values on Motion tasks.