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. …

[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 por…

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 Port…

[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 le…

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: …

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	13390	4 July 2020
Google sheet & Asana reporting App Integrations	14	12629	6 April 2021
I built an add-on for scheduled Google Sheets exports from Asana Third-party Apps	2	85	29 July 2026
import specific section and some custom fields from all projects to Google Sheets App Integrations	5	1403	27 October 2021
Export all projects to the Google Spreadsheet App Integrations productivity , projects	2	3887	7 April 2021

Project level reporting to gsheets?

Related topics