The Scenario
The kick-off call is in four hours, and your project plan isn't in Magnetic yet.
You built the plan in Google Sheets — 120 rows, each with a task name, assignee email, due date, and linked opportunity ID. The client signed last Thursday. The PM who was going to handle the Magnetic setup is out sick. You're looking at the sheet, doing the math: 120 tasks, click-through form, probably 8 clicks per task. That's not something you can finish before the call.
The bad version:
- You open Magnetic's task creation panel and start entering row 1 by hand, copying from the sheet and pasting into each field one at a time
- You get through 15 tasks in 25 minutes, realize the date format you're pasting doesn't match what Magnetic expects, and have to go back and fix the ones you already entered
- You hit row 40 and accept you're not finishing this before the call — the client will see an empty project board at kick-off
Leadership will be on that call. Showing up with an unpopulated project board after signing is not the first impression your agency needs.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Google Sheet. It reads your sheet, understands the structure, and through its Magnetic integration it can create tasks, push records, and write results back — without you touching the Magnetic UI at all.
Open the SheetXAI sidebar in your project plan sheet and ask:
Sheet 'Project Plan' has columns: task_name, assignee_email, due_date, opportunity_id — create a Magnetic task for every row and write the new task_id back in column E
What You Get
- A Magnetic task created for each of the 120 rows, with the assignee, due date, and linked opportunity mapped correctly
- The Magnetic task ID for each row written back into column E, so your sheet stays the source of truth
- Any rows where Magnetic returned an error flagged in a note in column F, rather than silently skipped
- The full operation completes before the call
What If the Data Is Not Quite Ready
The assignee column has names instead of email addresses
You've got full names in the assignee column, but Magnetic's task API expects email addresses. Before creating tasks:
Column C in sheet 'Project Plan' has assignee names — look up each name in sheet 'Team Directory' column A and return the matching email from column B, write results into column C, then create Magnetic tasks for all rows
Some due dates are in MM/DD/YYYY and others are in text like "end of May"
Normalize all values in column D of sheet 'Project Plan' to ISO date format YYYY-MM-DD — convert text dates relative to today's date — then create Magnetic tasks for all rows
The opportunity IDs need to be looked up from a second sheet
Column D of 'Project Plan' has opportunity names, not IDs — look up each name in sheet 'Opportunities' column B and return the Magnetic opportunity ID from column A, then create tasks with the correct opportunity_id
Clean up, confirm, and create — all in one
In sheet 'Project Plan': normalize dates in column C to YYYY-MM-DD, look up assignee emails from sheet 'Team Directory', skip any rows where task_name is blank, create a Magnetic task for each remaining row, and write the returned task_id into column E
The rule of thumb: any cleanup the data needs and the action you want taken can both go into a single prompt — you don't have to prep the sheet first and then run the import.
Try It
Get the 7-day free trial of SheetXAI and open your project plan sheet — the one with task names, assignees, and due dates — then ask it to push everything into Magnetic before your next kick-off call. After you've seen this work, take a look at pushing opportunities into Magnetic from a pipeline sheet or head back to the Magnetic integration overview.