How to Send Paperform Submissions Data to Google Sheets Using Pabbly Connect

Learn how to integrate Paperform submissions with Google Sheets using Pabbly Connect. Step-by-step guide for seamless data transfer. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To send Paperform submissions data to Google Sheets, you need to access Pabbly Connect. Start by visiting the Pabbly website and navigate to the Pabbly Connect section. If you are a first-time user, click on the ‘Sign Up for Free’ option to create an account.

Once you have an account, sign in and access the Pabbly Connect dashboard. Here, you can create a new workflow to automate the process of sending submissions from Paperform to Google Sheets. To create a workflow, click on the plus sign and select ‘Create Workflow’.

2. Creating a Workflow in Pabbly Connect

In this step, you will set up a workflow named ‘Send Paperform Submissions Data to Google Sheets’. This name can be customized as per your requirement. After naming your workflow, click on ‘Create’. Now, you will see a trigger window and an action window.

• Choose Paperform as the application in the trigger window.
• Select ‘New Form Submission’ as the trigger event.
• Copy the provided webhook URL for use in Paperform.

After completing these steps, you will be ready to link Paperform with Pabbly Connect. This connection will allow you to capture form submissions automatically.

3. Setting Up Paperform for Integration

Now, head over to your Paperform account. Locate the form you want to connect and click on ‘Edit’. In the form settings, find the ‘After Submission’ option and select ‘Webhooks’. Here, paste the webhook URL you copied from Pabbly Connect.

Click on ‘Add Webhook’ to complete the setup. This step ensures that every time a form is submitted, the data will be sent to Pabbly Connect. To test this integration, you will need to submit a test entry through your Paperform.

4. Testing the Integration with Pabbly Connect

To test the integration, fill out the Paperform with a sample submission. For example, input the first name as ‘Adam’, last name as ‘Smith’, email as ‘[email protected]’, and a phone number. After submitting the form, return to Pabbly Connect to see if the data has been captured successfully.

In the Pabbly Connect dashboard, you should see the details of your submission appear in the response section. This indicates that the connection between Paperform and Google Sheets is functioning correctly. Next, you will set up the action to send this data to Google Sheets.

• Choose Google Sheets as the application in the action window.
• Select ‘Add New Row’ as the action event.
• Connect your Google Sheets account to Pabbly Connect.

Once connected, you can map the fields from the Paperform submission to the corresponding columns in your Google Sheets.

5. Finalizing the Integration with Google Sheets

After mapping the fields, click on ‘Save and Send Test Request’. This action will send the data from Paperform to your specified Google Sheets document. Check your Google Sheets to confirm that the new row has been added with the details from the form submission.

To ensure everything is working seamlessly, conduct additional test submissions through Paperform. Each submission should automatically populate a new row in your Google Sheets, confirming that the integration via Pabbly Connect is functioning correctly.

Once you confirm that the integration works as intended, save your workflow in Pabbly Connect to keep your automation active.

Conclusion

In this tutorial, we explored how to send Paperform submissions data to Google Sheets using Pabbly Connect. By following the outlined steps, you can automate the process of capturing form submissions and storing them in Google Sheets efficiently. This integration allows for seamless data management and enhances productivity for your business.