Briefly describe (1-2 sentences) the Bug you’re experiencing: Team members are reporting that the Asana project export to Google Sheets feature is not working. Google sheets returns the error “Could not fetch url”
Steps to reproduce: From an asana project, go to “Sync tasks to google sheet” – get the =IMPORTDATA link – paste it in a google sheet – error message appears
Browser version: Chrome Version 104.0.5112.80 (Official Build) (64-bit)
I tried to replicate, and did see a hesitation and a brief error message in the Google Sheet, but then the error resolved and the data did load. So it’s not broken, but I did see it hesitate and throw a temporary error, which it resolved. So that is new behavior.
Hm, thanks for double checking Stephanie. I’m still getting the “could not fetch URL” error a few seconds after that “Loading data,” error appears on my end. I’ve tried changing public preview settings and syncing several projects with no success.
And in case this does not help have a look here also Export Live Data from Asana into Google Sheet - #3 by lpb although that seems to be only for the project and not portfolio level.
If your Asana plan has also stayed the same and the troubleshooting does not help I recommend reaching out to Asana support as I am sure they will be able in having this resolved
Our Engineers have confirmed that there is currently a bug affecting Asana’s ability to sync with Google Sheets. They are working on this as a priority and we hope to have a resolution very soon.
Same issue, and has been an issue for over a week now, its really starting to impact our workflows, any ETA on this one @Rebecca? It’s a fundamental integration for our organisation.
Our workaround for this issue has been to export the reports manually through CSV exports but it lacks the same information as those Google exports and it’s not updated as frequently.
Hi @anon51885637, unfortunately I can’t give an ETA here but our Engineers are working on this as a priority as it does seem to be impacting quite a lot of users.
As soon as I have any updates, I’ll share them here.
Thanks for the response @Rebecca_McGrath FYI the issue randomly fixed for about 20 mins this morning. But is now once again showing “Could not fetch url” again.
Our team used to have the same issue a few days ago. The task we were working on was pretty urgent, so we decided to try using a third-party ETL platform to connect Asana to Google Sheets to export all the required data. Hope that was a one-time necessary measure and we will not face similar issues in the future.
To add some context to this issue: My org uses this functionality as the backbone for reporting, as Asana’s charts are not fully fledged out, with significant limitations.
Re-exporting manually adds a lot of overhead which we can’t afford. There is also Google Data Studio and automated charting done on top of our current Google Sheets live link, so re-exporting will likely break all of these or need manual shuffling of the data… which would be a pain.
My reporting is blocked due to this bug. I hope it’s resolved soon.