Watch Step By Step Video Tutorial Below





Accessing Pabbly Connect for Integration

To integrate Teleforms with Google Sheets, start by accessing Pabbly Connect. Visit the Pabbly website by typing pabby.com in your browser. Once there, you can sign in or create a new account.

If you are an existing user, click on the “Sign In” option at the top right. New users can click “Sign Up for Free” to get started with 100 free tasks monthly. After logging in, navigate to the Pabbly Connect dashboard to create your integration workflow.

Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the “Create Workflow” button. You’ll be prompted to select between the new beta workflow builder and the classic version. Choose the new beta for a modern experience.

Name your workflow, for example, “Automatically Send Teleform Responses to Google Sheets,” and select the appropriate folder for organization. Then, click on “Create” to proceed with setting up your trigger application.

Setting Up Teleforms as the Trigger Application

In this step, you will configure Pabbly Connect to use Teleforms as your trigger application. Select Teleforms and choose the “New Response” trigger event. Click on “Connect” to establish the connection.

A webhook URL will be generated, acting as a bridge between Teleforms and Pabbly Connect. Copy this URL and go to your Teleforms account. Navigate to your desired form, access the integration settings, and paste the webhook URL. Save the changes to complete the setup.

  • Open your Teleforms account and select the form.
  • Navigate to integration settings and find the webhook option.
  • Paste the copied webhook URL and save the changes.

Now, Pabbly Connect will wait for a response from Teleforms, signaling that the connection is ready for testing.

Testing the Connection with a Form Submission

To ensure everything is set up correctly, perform a test submission using the Teleforms link. Fill out the form with dummy details and submit it. This will trigger the webhook and send the data to Pabbly Connect.

After submission, return to Pabbly Connect to check if the response has been captured. You should see the details from your test submission reflected in the workflow, confirming that the integration is functioning properly.

Adding Google Sheets as the Action Application

Now that your trigger is set up, it’s time to add Google Sheets as the action application in Pabbly Connect. Click on “Add New Action Step” and select Google Sheets. Choose the “Add New Row” action event and click on “Connect”.

Sign in to your Google account and grant the necessary permissions. Once connected, select the spreadsheet you created for Teleform submissions. You will see the fields from your spreadsheet appear, allowing you to map the data from Teleforms.

  • Select the spreadsheet named “Teleform Submissions”.
  • Map the fields from Teleforms to the corresponding columns in Google Sheets.
  • Hit “Save” and send test request to verify the integration.

After successfully mapping the fields, you will see the lead details automatically populated in your Google Sheets, confirming that the integration through Pabbly Connect is complete.

Conclusion

In this tutorial, we demonstrated how to integrate Teleforms with Google Sheets using Pabbly Connect. By following these steps, you can automate your form submissions and ensure all data is captured efficiently in your Google Sheets.

This integration not only streamlines your workflow but also saves time and reduces manual data entry errors. Start utilizing Pabbly Connect today to enhance your automation capabilities!