If you’re looking for automatic syncing of tasks from an Asana project into a Google Sheet, Velocity has a feature called Data Links that makes this fairly straightforward:
You could:
- Create a Data Link (you’ll choose which task columns you want, and you can filter by a specific project)
- The Data Link will generate a CSV URL, which will always have up-to-date task data. You can sync that CSV automatically into a Google Sheet using IMPORTDATA, which will refresh the data in the sheet automatically
(Disclosure: I’m a cofounder of Velocity.)