The Asana tables in Sheets
Sheets reads your Asana workspace as 11 tables. Add one to a spreadsheet as a data source and its columns become names your formulas use.
Custom fields are columns too, named like the field. Portfolios, goals and time entries need one of Asana's paid plans; on a free workspace those tables are empty.
Work
TasksID, Name, Type, Completed, Status…Tasks by projectID, Task ID, Task, Project, Project ID…ProjectsID, Name, Owner, Owner ID, Team…SectionsID, Name, Project, Project ID, Tasks…TagsID, Name, Colour, Created at…
Planning
PortfoliosID, Name, Owner, Owner ID, Start date…Portfolio itemsID, Portfolio, Portfolio ID, Item, Item ID…GoalsID, Name, Owner, Owner ID, Team…Time entriesID, Date, Minutes, Hours, User…