A service designed to seamlessly integrate your Asana tasks with Airtable, eliminating the need for manual copying. This service streamlines the synchronization of task data between the two platforms.
Built on the Node.js framework, this integration orchestrates a seamless connection between Asana and Airtable. The core function revolves around automatic data transfer: whenever a new task is generated in Asana, it is seamlessly copied to Airtable. The newly created Asana task is mirrored as a fresh entry within the "Task-Saver" table in Airtable. This table is meticulously structured to include essential columns:
- Task ID
- Name
- Assignee
- Due Date
- Description
This seamless coordination hinges on the activation of webhooks. The service promptly responds to specific webhook actions triggered by Asana, including added, changed, and deleted Additionally, the service is fortified to manage intricate scenarios like task editing, and even instances where data is deleted in Airtable. For instance, if a change action is detected in Airtable after a data deletion, the service intelligently reinserts the data into the table.
These functionalities collectively ensure a smooth and dependable integration between Asana and Airtable, empowering you to maintain accurate and up-to-date task records effortlessly.
- Copies the Asana task to Airtable
- Adds the task to Airtable
- Edits the task in Airtable
- Deletes the task in Airtable
This project uses:
Before installation, you need to have installed/knowledge of the following:
- clone the main branch to your local machine
git clone https://github.com/JasonDsouza212/Asana-and-Airtable-integration.git
- change the present working directory
cd Asana-and-Airtable-integration
- Set the .env file with the value in the backend folder
- ASANA_ACCESS_TOKEN= Add the Asana Access token here
- WEBHOOK_SECRET=Your MongoDB URL
- AIRTABLE_ACCESS_TOKEN= Add the Airtable Access token here
- AIRTABLE_BASEID= Add the Airtables BASEID
- AIRTABLE_TABLEID= Add the Airtables Table ID
- URL= Add this app's hosted url, if you are testing that con be set to localhost:3000 / use ngrok to make the url publiclaly available and add that url
- Open CMD in your current directory and install npm packages using command:
npm install
- Run it locally using
npm start
-
Esatblish the webhook in Asana first inorder to sync the Airtable with Asana
-
Now the app is ready to take the webhook actions