I have created a zap to create asana tasks from new rows in Excel. When running the test my custom fields in Asana remain blank however I have made sure they are selected when I customized the task. All fields in excel have been changed to either a TEXT or NUMBER format to match the same format as the custom field.
Note: some custom fields have a drop down with the correct selection displayed in the Excel cell.
Best answer by steph.nView original
@emmawhite - Have you tried turning on the Zap and then waiting after new input is put into your spreadsheet? Also, I wanted to direct you to this guide to address common issues with your Google Sheets integration: https://zapier.com/help/doc/common-problems-google-sheets-zapier
Please let us know if the issues mentioned in the guide were helpful or not. We’re happy to help further!