@Lewis_Schiff yes, you’re correct. At this time we don’t have a clean way to automate: for every new line in this spreadsheet, go into asana and create a project with X template.
It’s a hack for sure. My team finds it relatively low lift to (1) create a new project using the template with all it’s interdependencies, (2) naming the project (3) adding a due date on one task (4) adding one or two KEY assignees for the project.
Then the rest is automated (updating task names, adding relative due dates, adding task assignments etc).
One caveat to this hack, we can automate so easily b/c google sheets only exports 250 lines before truncating and our templates run around 50 lines. You’d run into google export issues if your templates have more than 250 tasks.