Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start integrating Google Sheets with Salesforce, first access Pabbly Connect. You can do this by visiting the Pabbly Connect website and signing in or signing up for a free account. Once logged in, you will be on the Pabbly Connect dashboard, ready to create your workflow.

For new users, Pabbly Connect offers 100 free tasks, allowing you to test its features without any cost. This is a great opportunity to explore how Pabbly Connect facilitates automation between various applications, including Google Sheets and Salesforce.

2. Creating a Workflow in Pabbly Connect

Once you are on the Pabbly Connect dashboard, click on the “Create Workflow” button. From there, select the option to create using AI. This feature allows you to automate the process of adding contacts from Google Sheets to Salesforce.

  • Click on “Create Workflow”.
  • Select the AI option to automate your setup.
  • Input your request: “Add contacts in Salesforce from Google Sheets”.

After entering your request, approve and create the workflow. Pabbly Connect will automatically set up the necessary connections for you. This simplifies the integration process significantly, allowing you to focus on your business.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets to Pabbly Connect, you will need to copy the webhook URL provided by Pabbly Connect. This URL is essential for sending data from Google Sheets to Salesforce.

Open your Google Sheets and go to Extensions > Add-ons > Get Add-ons. Search for “Pabbly Connect Webhooks” and install it. After installation, refresh your Google Sheets to ensure the add-on is active.

  • Navigate to Extensions > Pabbly Webhooks.
  • Select “Initial Setup” and paste the webhook URL.
  • Set the trigger column to the one that contains final data, such as phone numbers.

After configuring the initial setup, test the connection by sending test data. This will verify that the data is being sent correctly from Google Sheets to Pabbly Connect.

4. Mapping Data to Salesforce Using Pabbly Connect

Now that Google Sheets is connected to Pabbly Connect, the next step is to map the data to Salesforce. Click on the action step and select Salesforce as your application. You will need to connect to your Salesforce account by granting the necessary permissions.

During the mapping process, ensure to input the first name, last name, email address, and phone number. Since the name is combined, use the text formatter by Pabbly to split the name into first and last names. This will require you to specify a space as the separator.

  • Select Salesforce as the action application.
  • Map the data for first name, last name, email, and phone number.
  • Use the text formatter to separate first and last names.

After mapping all necessary fields, send a test request to ensure that the data is correctly added to Salesforce. This confirms that Pabbly Connect is working effectively to automate your workflow.

5. Bulk Uploading Contacts to Salesforce from Google Sheets

With the initial setup complete, you can now bulk upload contacts from Google Sheets to Salesforce. To do this, go back to the Extensions menu in Google Sheets and select the option to send all data.

This action will forward all the data in your Google Sheets to Pabbly Connect, which will then create the contacts in Salesforce automatically. This process saves time and reduces the risk of data entry errors.

  • Navigate to Extensions > Pabbly Webhooks.
  • Select “Send All Data” to upload contacts.
  • Confirm that contacts are created in Salesforce.

This bulk upload feature effectively demonstrates how Pabbly Connect can streamline your business processes, allowing you to focus on growth rather than manual data entry.

Conclusion

In this tutorial, we explored how to integrate Google Sheets with Salesforce using Pabbly Connect. This process not only automates the addition of contacts but also minimizes errors, making your workflow more efficient. With easy setup and bulk upload capabilities, Pabbly Connect is an invaluable tool for businesses looking to streamline their operations.