Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect for your integration needs, first visit the Pabbly Connect landing page. Here, you can sign up for a free trial to explore its features. Once registered, log in to your Pabbly Connect dashboard.

After logging in, click on the “Create Workflow” button. This is where you will set up your integration between Google Sheets and Gmail. Type “Sheets to Gmail” in the quick builder and follow the prompts to initiate the workflow setup.

2. Creating Your Workflow in Pabbly Connect

Once you have accessed your Pabbly Connect dashboard, you can create a new workflow. This workflow will facilitate the integration between Google Sheets and Gmail. Click on the “Create Workflow” button and select the quick builder option.

  • Enter “Sheets to Gmail” as your workflow name.
  • Click on “Approve and Create” to finalize your workflow setup.

With your workflow created, you will now connect your applications. Start by selecting Google Sheets as the first application in your workflow. This will allow you to pull data from your spreadsheet to send emails through Gmail.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets, you will need the webhook URL provided by Pabbly Connect. Copy this URL and open your Google Sheets. Navigate to Extensions > Add-ons > Get Add-ons, and search for “Pabbly Connect Webhooks” to install this extension.

After installation, refresh your spreadsheet. Then, go back to Extensions, select “Pabbly Connect Webhooks,” and choose “Initial Setup.” Here, paste the webhook URL you copied earlier and specify the trigger column. For example, if your trigger column is C, enter that in the setup.

4. Setting Up Gmail Connection in Pabbly Connect

Now that Google Sheets is connected, it’s time to set up Gmail. Click on the “Connect” button in Pabbly Connect and select “Add New Connection.” You will be prompted to sign in with your Google account to allow Pabbly Connect access to your Gmail.

Once connected, you need to enter the sender’s name and email address. You will also map the recipient’s email address from your Google Sheets data. Mapping allows Pabbly Connect to dynamically change the recipient based on the data in your spreadsheet.

  • Enter the subject and body of the email.
  • Choose HTML format if you want to send styled emails.

After setting up these details, click on “Save and Send Test Request” to send a test email using the details from your spreadsheet. This ensures everything is working correctly before you send bulk emails.

5. Sending Bulk Emails Using Pabbly Connect

With your Gmail setup completed, you can now send bulk emails. To do this, go back to your Google Sheets and navigate to Extensions > Pabbly Connect Webhooks. Click on “Send All Data” to send the details of all leads in your spreadsheet to Pabbly Connect.

Additionally, if you want to ensure that new entries in your Google Sheets automatically trigger an email, enable the “Send on Event” option in the Pabbly Connect Webhooks menu. This will allow Pabbly Connect to send emails to new leads as they are added to your sheet.

Now you have successfully set up automation to send bulk emails using Pabbly Connect. This integration streamlines your communication process and saves you valuable time.

In summary, using Pabbly Connect to integrate Google Sheets with Gmail enables you to send personalized bulk emails efficiently. This tutorial guides you through each step of the process, ensuring a smooth setup for your email automation needs.