Asana

Asana is project management software that helps teams share and work and collaborate on projects

Sync Asana data to Sourcetable

Build reports once. Connect to Asana and start modeling from live data.

Popular Use Cases

Asana connector Sourcetable connector
Create reports using Asana data
Asana + Sourcetable
 connector Sourcetable connector
Create a burn chart of all active Asana tasks
+ Sourcetable
 connector GitHub connector
Get a combined list of Asana tasks and Github issues
+ GitHub
Asana connector Sourcetable connector
Search all active Asana tasks, by type
Asana + Sourcetable
Asana connector Sourcetable connector
Automate Asana reporting using Sourcetable
Asana + Sourcetable
Here's a sample of the Asana data that will be available in your Sourcetable spreadsheets:
ATTACHMENT

Any file attached to a ticket whether it is uploaded from the device of belongs to google drive or dropbox is called an attachment

ORGANIZATION

Organisation is the company using the Asana, it contains the name and id of organisation

PROJECT

A list of tasks that can be prioritized and shared among the users of an organisation depending upon their user permissions

PROJECT_TASK

Contains the association of project with a task

SECTION

A division of project that groups the tasks together. A section can be in a list view or a column in a board

STORY

Any activity performed by a user like creating tasks, assigning tasks etc are called stories

TAG

Tags acts a label which can be applied to a task

TAG_FOLLOWER

Contains the association of a tag and a user

TASK

A base object on which multiple operations are performed, tasks are usually present in the middle pane based on sort parmeters

TASK_FOLLOWER

Contains the association of a task and a user

TASK_SECTION

Contains the association of task and a section

TASK_TAG

Contains the assocation of a task and a tag

TEAM

A group of people associated with a project within an organisation

USER

A user is the account created in Asana that can be access to various operations to add, manipulaet tasks and other operations

WORKSPACE

A highest level of organiztional unit in Asana is called workspace in which projects and tasks are associated