How to Add New Leads from Typeform to Google Sheets Using Pabbly Connect

Learn how to seamlessly add new leads from Typeform to Google Sheets using Pabbly Connect with this step-by-step tutorial. 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 Integration

To start integrating Typeform with Google Sheets, you first need to access Pabbly Connect. Open a new tab and type in the URL babbly.com/connect to reach the Pabbly Connect homepage.

Once on the homepage, you will find options to sign up or sign in. New users can register for free and get 100 tasks monthly. After signing in, click on the Access Now button to navigate to the Pabbly Connect dashboard, where you can manage your automation workflows.

2. Creating a New Workflow in Pabbly Connect

To create a new workflow, click on the Create Workflow button located in the top right corner of the dashboard. You will see two options for workflow builders: the new version and the classic version. Choose the new version for better flexibility and a drag-and-drop interface.

• Click on Select to proceed with the new workflow version.
• Enter a workflow name, such as Add New Leads from Typeform to Google Sheets.
• Select a folder for your workflow, or create a new one if needed.

After setting the name and folder, click on the Create button. Your new workflow will be created successfully, and you will be directed to the workflow builder page, where you can toggle the activation button on.

3. Setting Up Trigger and Action in Pabbly Connect

In Pabbly Connect, the workflow consists of triggers and actions. A trigger initiates the workflow when an event occurs, while an action is the task that follows. To set up the trigger, click on the plus icon and select Typeform as the trigger app.

• Choose New Entry as the app event.
• Click Connect and select Add New Connection.
• Authorize Pabbly Connect to access your Typeform account.

Once the connection is successful, select the lead form you have created in Typeform. After selecting the form, click on Save and Send Test Request to ensure that Pabbly Connect receives a webhook response from Typeform.

4. Adding Google Sheets Action in Pabbly Connect

After setting up the trigger, it’s time to add the action step. Click the plus button again and select Google Sheets as the action app. Choose Add New Row as the action event and click Connect.

Similar to the previous step, select Add New Connection to authorize Pabbly Connect to access your Google Sheets. Sign in with your Gmail account and grant the necessary permissions. Once connected, select the spreadsheet where you want the new leads to be added.

Map the fields from Typeform to Google Sheets: Name, Email, Phone Number, Dance Category, and Starting From. Ensure all fields are accurately filled to match the Typeform entries.

After mapping the fields, click on Save and Send Test Request to verify that the data is correctly added to your Google Sheets.

5. Testing and Finalizing Your Integration

Once you have set up the action step, it’s crucial to test the integration. Go back to your Typeform and fill out a test entry. After submitting the form, return to Pabbly Connect and check if the response was received successfully.

If the test is successful, you should see the new entry reflected in your Google Sheets. This confirms that the integration is working perfectly. To finalize, ensure that the Send on Events option is enabled in your Google Sheets add-ons for continuous data transfer.

Check your Google Sheets to see the new lead entry with all the details. You can now manage your leads effectively using this automation.

With this setup, every new lead from Typeform will automatically populate your Google Sheets, making it easier for you to track and manage your leads efficiently.

Conclusion

In this tutorial, we demonstrated how to seamlessly integrate Typeform with Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of adding new leads, ensuring you have easy access to all lead information in one place. Start using Pabbly Connect today to enhance your workflow!