The Scenario
You're coordinating the kickoff for a 120-task software migration. Every task lives in a Google Sheet — 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 sheet 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 Google Sheet. 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.
Create a Wrike task for each row in the "Tasks" tab using the task title in column A, description in column B, and due date in column C, all in folder 12345678 — set the assignee from column D using the email address
What You Get
- One Wrike task created per row, with title, description, due date, and assignee populated exactly from the sheet.
- 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" tab, look up the email address for the name in column D from the "Team Directory" tab 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" tab 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 sheet — 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.