Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To automate your CRM using Pabbly Connect, start by visiting the Pabbly Connect website. If you are a new user, navigate to pabbl.com/connect and click on “Sign Up for Free” in the top right corner. This will give you access to 100 tasks free every month, allowing you to explore the platform.

After signing up, log in to your account. Existing users can directly access their workflow builder. The workflow builder is where you will set up the automation process that integrates Google Sheets with your CRM using Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

In the workflow builder, click on the “Add Trigger” button to start setting up your automation. For the trigger application, select “Google Sheets” and choose the event as “New Updated Spreadsheet Row.” Then, click on “Connect” to establish the connection.

  • Choose Google Sheets as your trigger application.
  • Select the event “New Updated Spreadsheet Row”.
  • Click on “Connect” to proceed.

Next, copy the webhook URL provided by Pabbly Connect and open your Google Sheets. Go to the “Extensions” menu, select “Add-ons”, and then click on “Get Add-ons” to install the Pabbly Connect Webhooks extension. After installation, refresh your spreadsheet to see the new option.

3. Setting Up the Webhook in Google Sheets

With the Pabbly Connect Webhooks extension installed, go to the “Extensions” menu again, select “Pabbly Connect Webhooks”, and then click on “Initial Setup”. Here, paste the webhook URL you copied earlier and specify the trigger column, which should be the last column where data is added.

  • Paste the webhook URL in the setup.
  • Define the trigger column based on your data.
  • Click on “Submit” to save the setup.

Once the setup is complete, you will see a message indicating that the configuration was successful. Now, go back to your spreadsheet and click on “Send Test” to send a test data entry to Pabbly Connect. This will help you verify that the connection is working correctly.

4. Creating a Client in Your CRM

After successfully sending test data, return to your Pabbly Connect workflow and click on “Add New Action Step”. Search for your CRM application (e.g., “Weber”) and select the action event as “Create Client”. Click on “Connect” to establish this new connection.

If you have previously connected your CRM, you can select the existing connection. Otherwise, you will need to create a new connection by entering the authentication token from your CRM account. This token can be found in the automation section of your CRM settings.

5. Mapping Data Fields for Automation

Once the connection is established, you will need to map the data fields from your Google Sheets to your CRM. This involves dynamically inserting data from the previous step into the fields required by your CRM. For example, map the name, email, and phone number fields from your spreadsheet to the corresponding fields in your CRM.

  • Map the name field from Google Sheets to your CRM.
  • Insert static values for fields that do not change, like lead source.
  • Click “Save and Send Test Request” to create the client.

After sending the test request, you should receive a confirmation that the client has been successfully created in your CRM. This automation will now allow you to create new contacts automatically whenever you add new leads in your Google Sheets using Pabbly Connect.

Conclusion

By integrating Google Sheets with your CRM using Pabbly Connect, you can automate the lead management process effectively. This tutorial outlined how to set up the workflow, configure the webhook, and map data fields for seamless automation.

With this setup, every time you add a new lead in Google Sheets, a corresponding contact will be created in your CRM without any manual effort. Start using Pabbly Connect today to enhance your productivity and streamline your operations.