The Scenario
The team restructure went through last Friday. A team lead now needs to add five members as followers to every one of 60 Asana tasks that shifted into the new team's scope. The task GIDs are already in a Google Sheet — column A has the GIDs, columns B through F have the team member emails.
It's Monday morning. He has a 9 AM stand-up and would like this done before it.
The bad version:
- Open Asana, find task 1, click the followers field, type the first email, wait for the lookup to resolve, add it, repeat for four more emails on the same task.
- Move to task 2 and do it again.
- 60 tasks, 5 followers each, 300 individual add operations — clicking through a UI that doesn't let you batch anything.
There's no version of this that takes less than an hour if you're doing it manually. And a restructure that's supposed to unblock the team shouldn't start with a morning of busywork for the team lead.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the task GIDs and follower emails from your sheet and sends bulk follower additions to Asana — no clicking through the task list.
For each task GID in column A of this sheet, add the users whose emails are listed in columns B through F as followers to that Asana task.
What You Get
- Followers added to all 60 tasks in one operation
- Column G receives "Done" for each successful row, or the specific error (invalid GID, user not in workspace, etc.) for any failures
- Users who are already followers on a task are handled gracefully — no duplicate errors
What If the Data Is Not Quite Ready
The follower emails are comma-separated in a single column instead of spread across columns B-F
For each task GID in column A of this sheet, split the comma-separated emails in column B and add each one as a follower to the Asana task. Write "Done" in column C for successes and the error for any failures.
Some task GIDs in column A are stale and no longer exist
For each task GID in column A of this sheet, attempt to add the users in columns B through F as followers. If the task GID is not found or has been deleted, write "Task not found" in column G and continue. For successful rows, write "Done".
You also need to add these same users as project members, not just task followers
Read the Excel table 'ProjectAccess' — column A has project GIDs and column B has comma-separated user emails. For each row, add those users as members to the corresponding Asana project. Write "Done" in column C for successes.
Add followers to tasks, add members to their parent projects, and write a summary count in one pass
For each task GID in column A of this sheet, add followers from columns B through F. For each task's parent project, also add the same users as project members. Write "Done" in column G for each task row. At the end, write a summary to cell H1 showing the total number of tasks updated and the total number of follower additions made.
One prompt covers the task followers, the project membership, and the confirmation summary.
Try It
Get the 7-day free trial of SheetXAI and open your restructure sheet with task GIDs and team emails — ask SheetXAI to add all the followers at once before stand-up. You can also see how to bulk-update task fields after a restructure, or return to the Asana hub for the full workflow list.