Hi! I’m trying to connect Google Sheets to Asana.
- When a new spreadsheet row is added → add task to Asana
- When a spreadsheet row/cell is updated → update Asana task
In both Google Sheets and Asana I have matching columns / custom fields with dropdown menus.
I tried converting everything to plain text, and it works, but I need the dropdown options for advance filtering and dashboards.
Do you have any guidance to achieve this? Zapier Tables? I have the GID for each custom field in Asana.