This guide shows you how to import project tasks from Asana into Airtable using the Data Fetcher extension. You'll learn to connect Asana to Airtable, import task data including custom fields, and set up automatic syncing for ongoing project management.
Data Fetcher also works with other Asana data like projects, teams, and users, as well as other project management and no-code applications.
Add Data Fetcher
1. Install Data Fetcher from the Airtable extension marketplace.
2. Create your free account by entering your name, email address, and password, then click Sign up for free. Alternatively, sign up using your Google account.
3. Already have an account? Sign in using the link at the bottom left of the screen.
How to Connect Airtable to Asana
Create Your Integration Request
1. On the Data Fetcher extension home screen, click Create your first request.
2. For Application, select Custom to create a custom API request for the Asana Airtable integration.
3. Rename the request to "Import Asana Tasks" to keep your integrations organized.
4. In the URL field, enter the Asana API endpoint for getting tasks from a project:
https://app.asana.com/api/1.0/projects/{project_id}/tasks5. Replace {project_id} with your actual Asana project ID. You can find this ID in your Asana project URL when viewing the project in your browser.
6. Click Add + under Parameters to add request parameters.
7. Add the first parameter:
- Parameter:
opt_fields - Value:
name,custom_fields.display_value,custom_fields.name
8. Click Add + again to add a second parameter:
- Parameter:
limit - Value:
5
The opt_fields parameter tells Asana to return task names and custom field data. The limit parameter controls how many tasks are imported per request - we will increase it later when setting up pagination.
Configure Asana Authorization
1. Click the Authorization tab in Data Fetcher.
2. Set Type to OAuth.
3. Click + New to create a new authorization connection.
4. Click Asana from the list of available OAuth providers.
5. A new window will open, taking you to Asana's authorization page. Click Allow to authorize Data Fetcher to access your Asana data.
Configure Data Transformation Settings
1. Scroll to the bottom and click Advanced Settings.
2. Under Data Transformation, ensure Single Record is selected.
3. Turn off Combine nested object keys.
This ensures Asana's custom fields are imported as separate fields rather than combined into one comma-separated field.
Map Your Data Fields
1. Click Save & Run to execute the request.
Data Fetcher will connect to Asana and the Response Field Mapping screen will open.
2. Click Deselect All to clear all field selections.
3. Select and map the following fields by clicking them:
- Gid → New field called "Id"
- Custom fields 1 display value → New field called "Priority"
- Custom fields 2 display value → Existing field "Status"
- Name → Existing field "Name"
- Next page offset → New field called "Next page offset"
You can use Show selected first to see all your selected fields.
4. Once you've mapped these fields, click Save & Run.
Configure Advanced Settings for Syncing
Configure Data Syncing
1. Navigate to Advanced Settings in Data Fetcher.
2. Select the "Id" field to ensure records stay synchronized between Asana and Airtable.
This prevents duplicate records when tasks are updated or reordered in Asana.
Set Up Pagination
1. In Advanced Settings, find Update Based on Field(s).
2. Under Pagination, turn on Cursor pagination.
4. Set Cursor parameter to offset.
3. Set Cursor field to "Next page offset" (the field you mapped earlier).
4. For the Page size parameter, enter limit.
5. For Page size, enter 100.
6. Enable Fetch all pages.
7. Click Save & Run. Now that we've set up pagination, all the project tasks from Asana will be imported.
Set Up Automatic Asana to Airtable Sync
Upgrade Your Account
To keep your Asana tasks automatically updated in Airtable, you can schedule the integration to run at regular intervals.
1. In Data Fetcher, scroll to Schedule and click Upgrade.
2. Choose a plan from the different options depending on your needs and enter your payment details.
Set Up Automatic Asana to Airtable Sync
1. Under Schedule, click + Authorize.
2. A window will now open, allowing you to authorize the Airtable bases you want Data Fetcher to have access to. If you select + Add all resources this should avoid any issues with unauthorized bases in the future.
3. Click Grant access.
4. Schedule this request will now be switched on in Data Fetcher. Select a schedule for your Asana Airtable integration based on intervals of "Minutes", "Hours", "Days" or "Months".
5. Click Save, and any updated Asana tasks will automatically import into your Airtable base on your chosen schedule.
