How to Add New Jotform Submissions in Airtable Using Pabbly Connect

Learn how to integrate Jotform and Airtable using Pabbly Connect. This step-by-step tutorial covers every detail of the integration process. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Jotform and Airtable Integration

To begin integrating Jotform and Airtable, you must first access Pabbly Connect. Open your browser and type in the URL Pabbly.com/connect. This will take you to the Pabbly Connect landing page.

On the landing page, you will see two options: ‘Sign In’ and ‘Sign Up for Free.’ If you are a new user, click on ‘Sign Up for Free’ to create an account. After signing up, you will receive 100 free tasks to start your automation journey. If you already have an account, simply sign in.

2. Creating a New Workflow in Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard where you will find the ‘Create Workflow’ button on the right side. Click on it to begin setting up your integration.

• Click on ‘Create Workflow’.
• Name your workflow, for example, ‘Jotform Submissions to Airtable’.
• Click on ‘Create’ to proceed.

After naming your workflow, you will be directed to a new window displaying two main events: Trigger and Action. Select ‘Jotform’ as your trigger application and then choose ‘New Response’ as the trigger event. This setup allows Pabbly Connect to listen for new submissions from Jotform.

3. Setting Up the Jotform Integration in Pabbly Connect

After selecting Jotform as your trigger, Pabbly Connect will provide you with a webhook URL. This URL acts as a bridge between Jotform and Pabbly Connect. Copy this webhook URL, as you will need it to complete the integration in Jotform.

Next, log into your Jotform account and navigate to the form you want to integrate. Click on the ‘Settings’ tab, then select ‘Integrations’. Search for ‘Webhook’ and click on it. You will see an option to add a webhook; paste the copied URL into the designated field and click on ‘Complete Integration’. This establishes the connection between Jotform and Pabbly Connect.

4. Testing the Jotform Submission and Connecting to Airtable

Now that the integration is set up, it’s time to test it. In Pabbly Connect, click on ‘Waiting for Webhook Response’. Then, go back to Jotform and fill out your form for a test submission. For example, enter a name like ‘Test Lead’, last name ‘New’, email address, phone number, and department.

• Fill in the form with test data.
• Click on ‘Submit’.
• Return to Pabbly Connect to see the data received.

Once the submission is made, Pabbly Connect will capture the response. You will see all the details you entered in the previous step. Now, select ‘Airtable’ as your action application and choose ‘Create Record’ as the action event.

5. Completing the Airtable Setup in Pabbly Connect

To connect Airtable with Pabbly Connect, click on ‘Connect’ and then select ‘Add New Connection’. You will be prompted to enter your API key from Airtable. To find your API key, go to your Airtable account settings and copy it.

Paste the API key into Pabbly Connect and click on ‘Save’. Once connected, you will need to map the data from Jotform to Airtable. Choose your base ID and select the table where the data should be recorded. For example, select the table named ‘Jotform Submissions’ and map the fields such as first name, last name, email, phone number, and department to their corresponding fields in Airtable.

Finally, click on ‘Save and Send Test Request’. You should receive a successful response indicating that the data has been added to your Airtable account. You can verify this by checking your Airtable table to see the new record.

Conclusion

By following this tutorial, you have successfully integrated Jotform and Airtable using Pabbly Connect. This integration allows new submissions from Jotform to automatically create records in Airtable, streamlining your workflow. With Pabbly Connect, automating tasks between applications becomes effortless and efficient.