Asana’s own Google Sheets export is limited to Advanced and Enterprise plans, caps out around a few hundred rows, and has no way to refresh on a schedule.
I built a Google Sheets add-on that works around all three of those limits. Connect with a personal access token, pick a project or a whole portfolio, and export it into a sheet with your custom fields intact. Set the refresh to hourly, daily, or weekly and the sheet stays current without anyone re-running anything by hand. It works on every Asana plan tier, and there’s no row cap beyond what Sheets itself can hold.
I’m the developer. Free plan covers one saved export with manual refresh. Pro is US$10/month, with a US$100/year option.
This sounds great! I haven’t tried it (yet) but have made a note.
Can you include a screenshot on the website? I couldn’t find any answer to my question:
Do you just do one kind of live export, where the sheet rows correspond to task rows? So when you export a portfolio, you’re still getting the above, just for all projects’ tasks merged into the one sheet?
That would be in contrast to what Asana has (or had, maybe)
Live sync a portfolio gives you sheet rows that correspond to projects, not tasks
Live sync a project gives you sheet rows that correspond to the project’s tasks
Yes, portfolio export produces one row per task, merged into a single sheet across every project in the portfolio, same as a project export just looped.
Good catch though, there wasn’t a column showing which project a row came from, so I’ve just added one, called “Project.” It’s live now.
And on the other point: a task that sits in two projects of the same portfolio currently gets written twice, once per project, not deduplicated.