The Scenario
You're coordinating the kickoff for a 120-task software migration. Every task lives in an Excel workbook — task title in column A, description in column B, due date in column C, assignee email in column D. The kickoff meeting is in three hours. The Wrike folder has been set up, the team is waiting, and not a single task exists in it yet.
The bad version:
- Open Wrike, click "New Task," paste the first task title, switch to the workbook to copy the description, switch back, paste it, manually type or copy the due date, search for the assignee by name, save.
- Repeat 119 more times. Each task takes 90 seconds. That's three hours of clicking before you've reviewed a single agenda item.
- Lose your place at row 47, re-enter it, realize the date format pasted wrong in Wrike, fix it, continue.
Three hours before a kickoff is not when you want to be manually entering data. That's the moment you should be reviewing the agenda and making sure the right people are in the right room.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data you're already looking at and talks to Wrike on your behalf — no export, no template mapping, no API setup. Open the SheetXAI sidebar and describe what you need.
Add all rows in this Excel table as Wrike tasks in folder 12345678 — column A is title, column B is assigned user email, column C is due date, column D is status
What You Get
- One Wrike task created per row, with title, description, due date, and assignee populated exactly from the workbook.
- Wrike task IDs written back into column E so you have a persistent reference for each task.
- Any rows with missing assignee emails flagged in column F rather than silently skipped.
- The 120-task folder ready before you walk into the meeting.
What If the Data Is Not Quite Ready
Some rows have missing or malformed due dates
Create Wrike tasks for all rows in column A where column C contains a valid date — skip rows where column C is blank or contains text like "TBD", and flag those rows in column G with the text "missing due date"
Assignees are listed by name, not email
For each row in the "Tasks" sheet, look up the email address for the name in column D from the "Team Directory" sheet where column A is name and column B is email — then create a Wrike task in folder 12345678 using column A as title, column B as description, column C as due date, and the matched email as assignee
Tasks belong to different Wrike folders depending on their phase
Create Wrike tasks for each row in this sheet — use the folder ID from column E to determine which Wrike folder each task goes into, with title from column A, description from column B, and due date from column C
Full cleanup and creation in one shot
Trim all extra whitespace from column A, convert dates in column C from MM/DD/YYYY to YYYY-MM-DD format, look up assignee emails from the "Team" sheet matching on column D, then create a Wrike task for each row in folder 12345678 using the cleaned values — write Wrike task IDs back into column F
The pattern: cleaning the data and creating the tasks are one ask, not two separate operations.
Try It
Get the 7-day free trial of SheetXAI and open your project plan workbook — even a rough one with mixed date formats — then ask it to create the Wrike tasks. Link back to the hub overview or try exporting timelogs for invoicing next.