The Scenario
A new development project just got created in MOCO. The project manager has a Google Sheet with 20 standard service tasks defined — the same ones she applies to every new project at the agency: Discovery, Architecture, Frontend Development, Backend Development, QA, and so on, each with its billable status and hourly rate already set.
She has been adding these tasks manually every time a new project launches. It takes about 20 minutes per project, longer when she gets interrupted. Three new projects started last month. That's an hour of task entry that produces nothing except a correctly configured MOCO project.
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 hourly rate, save.
- Repeat for all 20 tasks, referencing the Sheet each time.
- Realize task 14 has a rate that changed recently and the Sheet wasn't updated — go back and fix it in both places.
Every project gets the same tasks. Every time, it's manual. The pattern is the definition of something a computer should do.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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 tab — 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 sheet.
- 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 add the same task list to multiple projects at once
For each project ID in column A of my Task Assignment tab, create all tasks from my Standard Tasks tab (columns B through D: task name, billable flag, hourly rate). Write results showing project ID, task name, and creation status to my Results tab.
Some tasks have different rates for different project types
Create MOCO tasks for project ID [X] from my Standard Tasks tab. 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 of these tasks already exist on the project before adding
For each row in my Standard Tasks tab, 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 to column E.
Create tasks for three new projects, apply different rates per project type, and confirm all are live
I have three new project IDs in my New Projects tab (column A) with their project type in column B (fixed or hourly). For fixed projects, create tasks from my Fixed Tasks tab. For hourly projects, create tasks from my Hourly Tasks tab. Write task creation results — project ID, task name, status — to my Results tab.
Twenty tasks applied in seconds. The project is ready for the team before the kickoff call ends.
Try It
Get the 7-day free trial of SheetXAI and open your task template spreadsheet, 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.