Integrating JetFormBuilder Submissions into Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate JetFormBuilder submissions into Google Sheets using Pabbly Connect in this detailed step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To integrate JetFormBuilder submissions into Google Sheets, the first step is accessing Pabbly Connect. Begin by visiting the Pabbly Connect website and signing into your account. If you’re new, you can sign up for free and receive 100 free tasks each month.

After logging in, you will see the Pabbly dashboard. From here, click on the ‘Access Now’ button under Pabbly Connect. This will take you to the main interface where you can create workflows that automate your processes.

Creating a Workflow in Pabbly Connect

In this section, we will create a workflow that connects JetFormBuilder and Google Sheets using Pabbly Connect. Click on the ‘Create Workflow’ button located in the top right corner of the dashboard. A dialog box will appear prompting you to name your workflow.

For this integration, name your workflow ‘Add JetFormBuilder Submission to Google Sheets’. Choose a folder to save your workflow, such as ‘JetFormBuilder Automations’. Once you have named your workflow and selected the folder, click on the ‘Create’ button to proceed.

• Click the ‘Create Workflow’ button.
• Name your workflow appropriately.
• Select a folder to save your workflow.

Now that your workflow is created, you will see two sections: ‘Trigger’ and ‘Action’. The trigger initiates the workflow, while the action specifies what happens next. Let’s set up the trigger now.

Setting Up the Trigger in Pabbly Connect

For the trigger application, select ‘JetFormBuilder’ in Pabbly Connect. This application will capture new form submissions. Choose the trigger event as ‘New Submission’. This means that every time a new submission is made, Pabbly Connect will capture the response.

Once you select the trigger application and event, Pabbly Connect will generate a webhook URL. This URL is essential as it connects JetFormBuilder to Pabbly Connect. Copy this URL as you will need it to configure your JetFormBuilder form.

• Select ‘JetFormBuilder’ as the trigger application.
• Choose ‘New Submission’ as the trigger event.
• Copy the generated webhook URL for configuration.

After copying the webhook URL, you will configure it in JetFormBuilder to ensure that submissions are sent to Pabbly Connect.

Configuring JetFormBuilder to Connect with Pabbly Connect

Open the JetFormBuilder form you created for collecting customer feedback. Click on the settings option and navigate to ‘Form Settings’. In the settings, find the ‘Webhooks’ option and click on it. Here, you will add a new webhook.

In the webhook settings, provide a name such as ‘Test Webhook’ and paste the webhook URL you copied from Pabbly Connect. Set the request method to ‘POST’ and the request format to ‘JSON’. For the request body, select ‘All Fields’ to ensure all data is sent. Finally, save your settings.

Navigate to ‘Form Settings’ in JetFormBuilder. Select ‘Webhooks’ and add a new webhook. Paste the webhook URL and configure the settings.

After saving the settings, your JetFormBuilder is now connected to Pabbly Connect, and any new submissions will be captured automatically.

Adding Submissions to Google Sheets Using Pabbly Connect

The next step is to set up the action in Pabbly Connect that will add the captured submissions to Google Sheets. For the action application, select ‘Google Sheets’ and choose the action event as ‘Add New Row’. This action will create a new row for each form submission in your specified spreadsheet.

Click on ‘Connect’ to link Google Sheets with Pabbly Connect. You will need to sign in with your Google account and allow permissions. Once connected, select the spreadsheet where you want to store the form submissions, and choose the appropriate sheet.

Select ‘Google Sheets’ as the action application. Choose ‘Add New Row’ as the action event. Connect your Google account and select the target spreadsheet.

Map the fields from the JetFormBuilder submission to the corresponding columns in Google Sheets. This mapping ensures that each submission is accurately recorded in your spreadsheet. After mapping the fields, click on ‘Save and Test’ to verify the integration.

Conclusion

In this tutorial, we detailed how to integrate JetFormBuilder submissions into Google Sheets using Pabbly Connect. By following these steps, you can automate the process of capturing customer feedback and storing it in a structured format. This integration not only saves time but also enhances operational efficiency.