Update tasks based on Google Sheets?

Hi there,

I want to fill in a value in a custom field in Asana when it is updated in a Google Sheet. It looks like I should be able to do this using Make. I was able to set up a scenario that sends all new tasks in my Asana project into the Google Sheet but I can’t figure out how to send data from the sheet to Asana. Has anyone done something similar, either using Make or natively in Asana? The Asana project I’m working with often has dozens of tasks where the custom field needs to be updated at once, so it would be much more efficient to make this update by pasting a value into a spreadsheet rather than interacting with each individual task in Asana. Thanks for any help you can provide.

I also asked about this functionality (worded differently) here: Dynamic Updates between Asana fields and Google Sheet cells

I didn’t really get any concrete answers. Have you learned anything since then?

Hi, this is possible using zzBots. With zzBots you are able to sync new and updated Google Sheets to Asana.

Here is a link: https://www.zzbots.com/store/google-sheets-asana-1-way-sync

If you are interested or need help setting up, just chat with us on our website.