The Scenario
A new development project just launched in MOCO. The project manager has a standard task list in an Excel workbook: 20 service tasks, each with its name, billable status, and hourly rate, the same ones applied to every new project at the agency.
She has added these tasks manually every time a new project starts. It takes 20 minutes per project, longer if she gets interrupted. Four new projects started last month. That's 80 minutes of task entry that produces nothing except correctly configured MOCO projects.
The bad version:
- Open MOCO, navigate to the new project, find the Tasks section, click Add Task, type the name, set billable to yes, enter the rate, save.
- Repeat for all 20 tasks, referencing the workbook each time.
- Realize task 14 has a rate that changed recently and the workbook wasn't updated — fix it in both places.
Every project. Same tasks. Manual every time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the task template and uses its built-in MOCO integration to add all 20 tasks to the target project in one operation.
Create MOCO project tasks for every row in my Standard Tasks worksheet — column A is project ID, B is task name, C is billable flag, D is hourly rate
What You Get
- One MOCO task created per row, attached to the specified project.
- Column E populates with the MOCO task ID and creation status for each row.
- Billable flag and hourly rate are set exactly as specified in the workbook.
- Any row where the project ID doesn't resolve surfaces as an error immediately.
What If the Data Is Not Quite Ready
I need to apply the same task list to multiple projects at once
For each project ID in column A of my Task Assignment worksheet, create all tasks from my Standard Tasks worksheet (columns B through D: task name, billable flag, hourly rate). Write results showing project ID, task name, and creation status to my Results worksheet.
Some tasks have different rates for different project types
Create MOCO tasks for project ID [X] from my Standard Tasks worksheet. For tasks flagged as Senior in column E, use the rate in column D. For tasks flagged as Junior, use the rate in column F.
I need to check if any tasks already exist on the project before adding
For each row in my Standard Tasks worksheet, check if a task with the same name already exists on MOCO project [X]. If yes, write the existing task ID to column E and skip. If no, create the task and write the new ID.
Create tasks for multiple project types, apply different rate tables, and confirm all are live
I have three new project IDs in my New Projects worksheet (column A) with their project type in column B (fixed or hourly). For fixed projects, create tasks from my Fixed Tasks worksheet. For hourly projects, create tasks from my Hourly Tasks worksheet. Write task creation results to my Results worksheet.
Twenty tasks applied in seconds. The project is ready before the kickoff call ends.
Try It
Get the 7-day free trial of SheetXAI and open your task template workbook, then ask it to apply the task list to a new MOCO project. See also the bulk project creation spoke if you need to create the project shell first.