How to Add Leads from 99acres to Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate 99acres with Google Sheets using Pabbly Connect for automating lead management. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To add leads from 99acres to Google Sheets, you first need to set up Pabbly Connect. Start by signing into your Pabbly Connect account or create one if you are a new user. Upon signing in, you will have access to your dashboard where you can create a new workflow.

Click on the ‘Create Workflow’ button on the right-hand side of the dashboard. Name your workflow, such as ‘ADD leads from 99acres to Google Sheets’ and select the appropriate folder for better organization. Once completed, click on the ‘Create’ button to proceed.

2. Configuring the Trigger Application in Pabbly Connect

In this step, you will configure the trigger application in Pabbly Connect. Select 99acres as your trigger application. The trigger event you need to choose is ‘New Leads’. This event will activate the workflow whenever a new lead is captured from 99acres.

• Select ’99acres’ as the trigger application.
• Choose the trigger event ‘New Leads’.
• Copy the provided webhook URL for integration.

Since 99acres does not allow direct URL configuration in its user interface, you must send this webhook URL to your account manager at 99acres. Once they configure it, you can capture the webhook response in Pabbly Connect.

3. Setting Up Google Sheets as Action Application

Next, you will set up Google Sheets as the action application in Pabbly Connect. In the action window, search for Google Sheets and select it. The action event you need to select is ‘Add a New Row’. This action will add the lead details into your Google Sheets automatically.

To establish a connection between Google Sheets and Pabbly Connect, click on ‘Connect’. If you have an existing connection, you can use it; otherwise, you will need to sign in with your Google account. After signing in, allow access for a secure connection. Once the authorization is successful, you can proceed to select your spreadsheet.

4. Mapping Lead Details to Google Sheets

In this section, you will map the lead details from 99acres to Google Sheets using Pabbly Connect. After selecting your spreadsheet, choose the specific sheet where the data will be added. You will typically select ‘Sheet1’.

Now, you will map the fields from the webhook response to the corresponding columns in Google Sheets. Mapping ensures that each time a new lead is received, the correct information is inserted into the right columns. For instance, map the first name, last name, email, contact number, location, and area accordingly.

• Map the first name to the corresponding field.
• Map the last name from the received data.
• Continue mapping email, contact number, location, and area.

Once all fields are mapped, click on ‘Save and Send Test Request’ to verify that the integration works correctly. If successful, you will see the lead information added to your Google Sheets.

5. Verifying the Success of the Integration

Finally, you will verify that the integration between 99acres and Google Sheets through Pabbly Connect is successful. Check your Google Sheets to see if the lead details have been added correctly. You should find the first name, last name, email address, contact number, location, and area populated in the respective columns.

Once confirmed, you can be assured that every new lead from 99acres will automatically populate in your Google Sheets. This seamless integration saves time and ensures that you have all your leads organized efficiently.

If you have any questions about using Pabbly Connect for this or other integrations, feel free to reach out for support or visit the Pabbly forums for more assistance.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to add leads from 99acres to Google Sheets. By following the steps outlined, you can automate your lead management efficiently and effectively.