Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, first, log in to your account. If you’re new, you can sign up for free and receive 100 free tasks every month to explore the software.

Once logged in, navigate to the dashboard where you can create a new workflow. Click on the “Create Workflow” button to begin setting up your integration with Google Sheets and Gmail.

2. Creating a Workflow in Pabbly Connect

In this step, you’ll create a workflow using Pabbly Connect. Select the “Quick Builder” option to streamline the setup process. Here, you will specify the applications to connect.

  • Choose Google Sheets as your trigger application.
  • Select the trigger event: “New or Updated Spreadsheet Row”.
  • Connect this to Gmail for sending emails.

After setting these options, click on “Approve and Create” to finalize the workflow setup in Pabbly Connect. Your integration is now ready to capture new data from Google Sheets.

3. Setting Up Google Sheets with Pabbly Connect

To integrate Google Sheets with Pabbly Connect, you need to copy the webhook URL provided by Pabbly. This URL will allow Google Sheets to send data to Pabbly Connect.

In Google Sheets, navigate to “Extensions” and then “Add-ons”. From there, go to “Get Add-ons” and search for “Pabbly Connect Webhooks”. Install this add-on to establish the connection.

  • Paste the webhook URL in the initial setup of the add-on.
  • Set the trigger column to the last column where data will be filled.
  • Send a test from Google Sheets to confirm the connection.

Once the test is successful, submit the initial setup and return to Pabbly Connect to verify that the data has been received correctly.

4. Configuring Gmail Integration in Pabbly Connect

The next step is to connect your Gmail account with Pabbly Connect. Click on the “Connect” button and log into your Gmail account. Grant the necessary permissions for Pabbly Connect to send emails on your behalf.

In the Gmail setup, you will need to configure the sender name, recipient email, subject line, and email content. Map the recipient email from the data received from Google Sheets.

  • Set the sender name to your business or brand name.
  • Use dynamic mapping for the recipient email to personalize each message.
  • Choose HTML format for the email content for better presentation.

After filling in all required fields, click on “Save and Send Request” to send a test email. Check your Gmail to confirm that the email has been sent successfully through Pabbly Connect.

5. Automating Email Sending with Pabbly Connect

Once you have set up everything, you can automate the process of sending emails to your customers. Use the “Send All Data” option in the Pabbly Connect Webhooks add-on in Google Sheets to trigger emails for all rows in your spreadsheet.

This automation allows you to send personalized emails to all customers listed in your Google Sheets without manual intervention. Simply add new rows to your sheet, and Pabbly Connect will handle the rest.

With this setup, you can efficiently manage bulk email campaigns, ensuring that each email is tailored to the individual recipient. This integration not only saves time but also enhances customer engagement through personalized communication.

Conclusion

Using Pabbly Connect to integrate Google Sheets with Gmail allows you to automate the process of sending personalized bulk emails. This tutorial provides a step-by-step guide to set up this integration, making your email marketing efforts more efficient and effective.