How to Automate Formsite Submissions to Google Sheets and Send SMS via ClickSend Using Pabbly Connect

Learn how to automate Formsite form submissions to Google Sheets and send SMS notifications using ClickSend with Pabbly Connect in this detailed tutorial. Learn to create powerful connections between your critical applications without requiring specialized programming knowledge or extensive technical background.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating Formsite form submissions to Google Sheets and sending SMS via ClickSend, you need to access Pabbly Connect. This integration platform allows you to connect various applications seamlessly.

Once you log into your Pabbly Connect account, click on the ‘Create Workflow’ button. You can easily sign up for a free account if you don’t have one. After logging in, give your workflow a name such as ‘Add Formsite Form Submission to Google Sheets and Send SMS Automatically’ and click on ‘Create’ to proceed.

2. Setting Up the Trigger Event for Formsite

In this step, you will set up the trigger event in Pabbly Connect to capture new form submissions from Formsite. Select Formsite as your trigger application and choose the event ‘New Form Results’.

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

After selecting the trigger event, you will receive a webhook URL. Go to your Formsite dashboard, navigate to your form settings, and find the integration option. Paste the webhook URL into the server post field, and ensure the message format is set to JSON. Save the changes to connect Formsite with Pabbly Connect.

3. Testing the Webhook Integration

Once you have set up the webhook in Formsite, it’s time to test the integration through Pabbly Connect. Make a test submission using your Formsite form to ensure that data is captured correctly.

Fill in the form with sample data, including a name, email, and phone number. After submission, check your Pabbly Connect dashboard to see if the data appears in the webhook response. This will confirm that the connection is working properly.

Each time a new form result is submitted, Pabbly Connect will instantly capture this data, triggering the subsequent actions in your workflow. This real-time data capture is essential for automating your process effectively.

4. Adding Form Data to Google Sheets

Now that you have successfully set up the trigger, the next step is to send the captured data to Google Sheets using Pabbly Connect. Select Google Sheets as your action application and choose the action event ‘Add a New Row’.

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

Once connected, select the specific spreadsheet where you want to store the form submission data. Map the fields from the Formsite submission to the corresponding columns in your Google Sheets. This mapping ensures that each new submission is recorded accurately in the designated columns.

5. Sending SMS Notifications via ClickSend

After adding the data to Google Sheets, the final step is to send an SMS to the form submitter using ClickSend, facilitated by Pabbly Connect. Select ClickSend as the action application and choose the action event ‘Send SMS’.

To connect ClickSend, you will need to provide your ClickSend username and API key. After connecting, map the phone number field from the form submission to the SMS recipient field in ClickSend. Compose your SMS message, including dynamic fields like the submitter’s name.

Click on save and send a test request to ensure the SMS is sent successfully. You should receive a confirmation response showing the message was queued for delivery. This confirms that the SMS integration is functioning as intended, completing your automation workflow using Pabbly Connect.

Conclusion

In this tutorial, we explored how to automate Formsite form submissions to Google Sheets and send SMS notifications via ClickSend using Pabbly Connect. This seamless integration enhances efficiency by automating data handling and communication processes.