What can I do with Custom Field Data, Time fields, and Google Sheets?

[Matt5]

We have a Project “Production Calendar” that is using the “Estimated Time” and “Actual Time” fields provided by Asana to track Estimated and Actual time for each task.

I am hoping there’s a way to have Asana automatically add data to a Google Sheet when the task is marked complete.

Task Name for Column A, and Estimated/Actual time in the following columns.

I’m aware that Zapier MIGHT be able to do this but I’ve had enough spotty success with Zapier that I’m not particularly interested in this.

We are on Business level and also using Flowsana, if this helps.

Also note that I am aware that Dashboard can do a lot of handy graphs, but GSheets has way, way handier graphs.

[Arthur_BEGOU]

Hi @Matt5 and thanks for your question,

Apparently, the feature exists, but could maybe be activated by support after request.

@lpb

You should try requesting “Sync to Google Sheets” be activated for your projects by contacting Asana Support at support@asana.com. I had to request it initially (and it’s still available for me):

Also, please don’t hesitate to search on the multiple existing articles on that topic
https://forum.asana.com/search?q=google%20sheet

Hope that could help

[Arthur_BEGOU]

Hi @lpb

Would you advise merging this topic with Export Live Data from Asana into Google Sheet ?

Thanks

[lpb]

Hi @Arthur_BEGOU,

I think Matt is asking for a GSheets row to be added when an Asana task is marked complete, whereas Sync to GSheets is different–it syncs all tasks in the project.

I think zapier.com, make.com, and the like are the primary solutions.

Thanks,

Larry

[Arthur_BEGOU]

Sorry @Matt5

Indeed, Larry is right, my suggestion doesn’t imply the automation part of your request.

Bests

Arthur