Syncing a project custom field data with Google Sheet data

English Forum Use Cases
1

Hi everyone,

As a project manager, I’ve created 3 project fields on Asana to track total budget allocated to each project, actual budget spent so far and remaining budget (Total Budget-Budget Spent so far). However, rather than updating “the actual budget spent” column manually for each project, I’ve been looking for an automatic way (sync) to pull this data from our Google Sheet budget file to this Asana project column so as the budget spent data is updated in our Google sheet (this changes monthly), Asana column will be also automatically updated for those specific projects.

Is there anyone has experienced this issue and found a solution?

Thank you in advance!

2

Hi @Duygu_Uygun , welcome to the forum :wave:

Have you tried the Google Sheets & Asana native sync integration?

1 Like
3

Hi @Richard_Sather,

Thank you, also for your message!

I have reviewed this article, indeed. However this article only is about pulling data from Asana to Google Sheet and creating custom reports on Google sheet. My case is other way around which is pulling data from Google Sheets into Asana. Please let me know if this native integration also works for this.

Thank you

4

Hi @Duygu_Uygun ,

My understanding and experience is that there is a 2-way sync but the project needs to be setup in Asana and then synced to a new Google Sheet which can then be formatted and styled as you like. Yhen any changes you make in that Google sheet will be reflected back to the project in Asana.

You cannot setup a sync starting from an existing Google Sheet. You would need to import the project in Asana using the CSV importer and then aync to a new Google sheet, deprecating the existing Google sheet thst you started with.

5

Hi Richard,

I understand, it is good news. I will try out to see if it works.

Thanks again for your reply.

1 Like