Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Sync Website Leads to Google Sheets in Real Time

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin automating your website lead capture, you first need to access Pabbly Connect. Simply navigate to the Pabbly Connect website by entering the URL pabbly.com/connect in your browser.

Once on the homepage, you will see options to sign in or sign up. If you are a new user, create an account for free. This account allows you to explore Pabbly Connect with 100 free tasks every month, perfect for testing the integration process.

2. Creating a Webhook Trigger in Pabbly Connect

After signing into Pabbly Connect, the next step is to create a workflow. Start by selecting “Webhook by Pabbly” as your trigger application. This will allow your website form to communicate with Pabbly Connect.

Choose the app event as “Catch Webhook”.
Copy the provided Webhook URL.
Integrate this Webhook URL into your website form’s code.

This Webhook URL is crucial as it will capture the data submitted through your website form and send it to Pabbly Connect for processing.

3. Setting Up Your Website Form for Integration

Next, you need to modify the code of your website form to include the Webhook URL from Pabbly Connect. Locate the part of the code where it mentions “fetch” and replace the existing URL with the new Webhook URL.

Once you save these changes, your website form is now set to send data to Pabbly Connect. To verify this, fill out the form with test data, such as a name, email, and phone number, and submit it. Pabbly Connect will then capture this data via the Webhook.

4. Adding Captured Data to Google Sheets

Now that Pabbly Connect has captured the data, the next step is to send this information to Google Sheets. In your Pabbly Connect workflow, select “Google Sheets” as the action application.

Choose the app event as “Add New Row”.
Connect your Google account to Pabbly Connect.
Select the spreadsheet where you want to store the data.

Utilizing the mapping feature in Pabbly Connect, you can dynamically insert the captured data into the appropriate fields in your Google Sheet, ensuring that each new lead is recorded automatically.

5. Testing and Verifying Your Integration

After setting up the action step in Pabbly Connect, it’s time to test the integration. Click on the “Save and Send Test Request” button to send a test entry to your selected Google Sheet.

Once the test is complete, check your Google Sheet to confirm that the new lead data appears correctly. This automation ensures that every time someone submits your website form, their information is instantly added to your Google Sheet without manual effort.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of capturing website leads and sending them to Google Sheets. This integration saves time and enhances efficiency for managing leads.