Hi there - I’m trying to get a portfolio level view that contains all tasks associated to all projects contained in the portfolio into gsheets; however, when I export the portfolio to gsheets, I only get rolled up, high-level info. I want all the details of all the projects in the portfolio export. Gsheets is not an export option on the project level, this seems like a huge gap. Am I missing something? Any help would be appreciated :slight_smile:

[image] anon35877181: I’m trying to get a portfolio level view that contains all tasks associated to all projects contained in the portfolio into gsheets; however, when I export the portfolio to gsheets, I only get rolled up, high-level info. I want all the details of all the projects in the portfolio export. Gsheets is not an export option on the project level, this seems like a huge gap. Am I missing something? Any help would be appreciated Portfolios deal with projects at the project level, not the task level, so you can’t expect task-level info there. Search results view does offer Search view action menu > Export > Sync to Google Sheets but you may need to request this of Support in order to activate it for your account. (Search the forum here for more info on this.) That will allow you to do the sync at the task level. Warning: it truncates at 2000 tasks. Larry

hi, [image] anon35877181: I want all the details of all the projects in the portfolio export What kind of details?

Hi @anon35877181, welcome to the Asana Community Forum! You can currently export projects to CSV and then import this CSV file to a Google Sheets doc to create reports. [Screenshot 2020-12-17 at 10.11.10] The Portfolio export will give you a high-level overview of all projects added to your Portfolio. You can find more details in this article. I hope this helps! Let us know if you have any other questions!

[image] Larry_Berger_lpb: Search results view does offer Search view action menu > Export > Sync to Google Sheets but you may need to request this of Support in order to activate it for your account. (Search the forum here for more info on this.) That will allow you to do the sync at the task level. Warning: it truncates at 2000 tasks. That is really good to know!

Thank you! This is what I was looking for. I’m going to try this solution over the next few days and see how it goes :slight_smile: Do you know if the data is real-time/constantly refreshed?

You’re welcome, @Tanya_Saracino! Tanya_Saracino: I’m going to try this solution over the next few days and see how it goes :slight_smile: Definitely make your Asana Support request to turn on the feature now since it might take them a little time to activate it for you. Tanya_Saracino: Do you know if the data is real-time/constantly refreshed? I believe it’s refreshed hourly in the GSheet. Thanks, Larry

Hi Bastien - would you happen to know where/how I contact Asana support? I can’t find where to reach out to them. Thank you!

[image] Larry_Berger_lpb: Search results view does offer Search view action menu > Export > Sync to Google Sheets but you may need to request this of Support in order to activate it for your account. Larry, I thought we were told that this feature was discontinued?

@Phil_Seeman, I can’t recall; maybe you’re right and I forgot; if so, apologies. @Emily_Roman, are you able to let us know about this? Thanks, Larry

[image] anon35877181: Hi Bastien - would you happen to know where/how I contact Asana support? I can’t find where to reach out to them. Thank you! Sure, How to contact our Support Team ✉

@Phil_Seeman @Larry_Berger_lpb, this is a sunset feature in Asana. While still functional, syncing projects to Google Sheets is an unsupported feature, this means we cannot help with deep troubleshooting issues. For this reason, we recommend exporting to CSV and then converting the file.

Project level reporting to gsheets?

Asana Community Ask the Community

Bastien_Siebman 29 December 2020 08:05 11

Sure, How to contact our Support Team ✉

Topic		Replies	Views
How do I export a large project with custom fields and subtasks into a CSV or spreadsheet API & Developers custom-fields , projects	29	13480	4 July 2020
Google sheet & Asana reporting App Integrations	14	12665	6 April 2021
I built an add-on for scheduled Google Sheets exports from Asana Third-Party Apps	2	94	29 July 2026
import specific section and some custom fields from all projects to Google Sheets App Integrations	5	1419	27 October 2021
Export all projects to the Google Spreadsheet App Integrations productivity , projects	2	3898	7 April 2021

Project level reporting to gsheets?

Related topics