Integrate Typeform with Google Sheets Using Pabbly Connect

Learn how to add or update rows in Google Sheets from new Typeform responses using Pabbly Connect. This step-by-step guide covers everything you need to know.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin the integration process, you need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect in your browser. Once on the landing page, you will see options to sign in or sign up for free. Existing users should click on ‘Sign In’, while new users can create an account in under two minutes.

After signing in, navigate to the dashboard where you will find various applications offered by Pabbly. Click on ‘Access Now’ for Pabbly Connect. This is the platform that will facilitate the integration between Typeform and Google Sheets.

2. Creating a New Workflow in Pabbly Connect

Once in Pabbly Connect, click on the ‘Create Workflow’ button. A dialog box will prompt you to name your workflow. For this tutorial, name it ‘Add or Update Row in Google Sheets from New Form Response’. Click ‘Create’ to proceed.

In the next window, you’ll see two main modules: Trigger and Action. The trigger application will be Typeform, and the action application will be Google Sheets. This setup allows you to automate the process of adding or updating rows based on new form responses.

• Select Typeform as the trigger application.
• Choose ‘New Entry’ as the trigger event.
• Connect your Typeform account by clicking ‘Connect’ and following the authorization steps.

After setting up the trigger, you will be ready to capture new responses from your Typeform.

3. Setting Up Typeform for New Responses

Next, you need to configure Typeform to collect responses. Go to your Typeform account and select the form you want to use. For this tutorial, we will use an ‘Appointment Form’ which includes fields like First Name, Last Name, Phone Number, and Email Address.

After confirming your form fields, return to Pabbly Connect. Enter the form name in the provided field and click ‘Save & Send Test Request’. This action will prompt you to submit a test response through Typeform.

• Publish your Typeform to get the link.
• Fill out the form with sample data.
• Submit the form to capture the response in Pabbly Connect.

Now, you will see the API response in Pabbly Connect, which confirms that the integration is working correctly.

4. Setting Up Google Sheets to Receive Data

After confirming the data from Typeform, the next step is to set up Google Sheets in Pabbly Connect. Select Google Sheets as your action application and choose the action event ‘Lookup Spreadsheet Row’. This will allow you to check if the response already exists in your Google Sheet.

Connect your Google Sheets account by clicking on ‘Connect’ and following the authorization process. Enter the name of the spreadsheet where you want to store the data, and select the appropriate sheet. The lookup column will be the email address, which is used to identify existing entries.

Input the spreadsheet name as ‘New Leads’. Set the lookup column to the email address. Map the lookup value to the email address from the Typeform response.

After setting this up, you will be able to determine whether to update an existing row or add a new one based on the email address.

5. Updating or Adding a Row in Google Sheets

Now that you have set up the lookup, you need to create conditions for updating or adding rows in Google Sheets. Use the router feature in Pabbly Connect to create conditions based on whether the email exists in the spreadsheet.

Create two routes: one for updating the contact if the email exists and another for adding a new contact if it does not. For the update route, select Google Sheets as the action application and choose ‘Update Row’ as the action event.

Map the row index from the lookup step. Map the first name, last name, email, and contact number from the Typeform response. For the add route, set up the action to add a new row with the same mapped fields.

After completing these steps, your integration will be fully functional, allowing you to automatically update or add rows in Google Sheets based on new Typeform responses.

Conclusion

In this tutorial, we explored how to integrate Typeform with Google Sheets using Pabbly Connect. By following the steps outlined, you can easily add or update rows in Google Sheets from new form responses. This integration streamlines your data management and enhances your workflow efficiency.