Integrate Formsite Entries to Google Sheets Using Pabbly Connect

Learn how to integrate Formsite entries into Google Sheets seamlessly using Pabbly Connect. Step-by-step guide for easy automation. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin the integration process of Formsite entries into Google Sheets, you first need to access Pabbly Connect. Start by navigating to the Pabbly Connect website by typing ‘Pabbly.com/connect’ in your browser.

Once on the landing page, you will see options to either sign in or sign up. If you are a new user, click on the ‘Sign Up’ button to create an account, which will only take a couple of minutes. After signing up, you will receive 100 free tasks to get started.

2. Creating a Workflow in Pabbly Connect

After logging into your Pabbly Connect account, you will be directed to the dashboard. To create a new workflow, click on the ‘Create Workflow’ button on the right side. You will be prompted to name your workflow, which should describe the integration, such as ‘Add Formsite Form Entries to Google Sheets’. using Pabbly Connect

• Click on ‘Create’ to proceed to the next step.
• Choose ‘Formsite’ as your trigger application.
• Select ‘New Forms Result’ as the trigger event.

After selecting the trigger, Pabbly Connect will provide you with a webhook URL. This URL will connect Pabbly Connect with Formsite to capture form submissions.

3. Setting Up Formsite with Pabbly Connect

Next, log into your Formsite account to set up the integration with Pabbly Connect. Navigate to the ‘Support’ section and then click on ‘Form Settings’. Here, you will find the ‘Integrations’ option on the left side. using Pabbly Connect

Click on ‘Server Post’ and then click ‘Edit’. Paste the webhook URL you copied from Pabbly Connect into the provided field. Ensure that the message format is set to JSON before saving the changes. This step allows Formsite to send data to Pabbly Connect whenever a new form is submitted.

4. Testing the Integration

With the webhook URL in place, it’s time to test the integration. Go back to Pabbly Connect and it will prompt you to do a test submission. Fill out the Formsite form with test data, such as a name, email address, and contact number, then submit the form. using Pabbly Connect

Return to Pabbly Connect to check if the API response is received. You should see the submitted data including the name, email, and contact number. This confirms that Pabbly Connect has successfully received the data from Formsite.

5. Adding Formsite Entries to Google Sheets

Now that the data is captured, the next step is to integrate Google Sheets. In Pabbly Connect, select Google Sheets as your action application. Choose ‘Add New Row’ as the action event, which will allow you to add the new form entries to your Google Sheets. using Pabbly Connect

• Click on ‘Connect’ to link your Google Sheets account.
• Authorize Pabbly Connect to access your Google Sheets.
• Select the spreadsheet and the specific sheet where you want the data to be added.

Map the fields from the Formsite submission to the corresponding columns in your Google Sheet. Once the mapping is done, click ‘Save and Send Test Request’ to verify that the integration works. Check your Google Sheet to confirm that the new entry has been added successfully.

Conclusion

By following these steps, you can efficiently integrate Formsite form entries into Google Sheets using Pabbly Connect. This automation simplifies data management and ensures that your form submissions are recorded in real-time, enhancing your workflow efficiency.