Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

How to Send Bulk Cold Emails for Free

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Email Automation

To start automating email sending, open your browser and navigate to Pabbly Connect. Here, you can sign up for a free trial, allowing you to send up to 100 emails without any cost. After signing up, you’ll have access to the Pabbly Connect dashboard.

Once logged in, click on the “Create Workflow” button. You’ll be prompted to enter a prompt for your workflow. Type in “Google Sheets to Gmail” and click send. This initiates the setup process for your email automation.

2. Setting Up Google Sheets with Pabbly Connect

In this section, you’ll configure Google Sheets to work with Pabbly Connect. First, select Google Sheets as your application in the workflow. You will then copy the webhook URL provided by Pabbly Connect.

Go to your Google Sheets and click on Extensions > Add-ons > Get add-ons.
Search for the “Pabbly Connect Webhooks” extension and install it.
After installation, refresh your spreadsheet to see the new options.

Next, open the Pabbly Connect Webhook option in your spreadsheet. You’ll need to enter the copied webhook URL and specify the trigger column, which is where the data will be sent from Google Sheets to Pabbly Connect. After configuring, click submit to finalize the setup.

3. Connecting Gmail to Pabbly Connect

Now that Google Sheets is set up, it’s time to connect Gmail using Pabbly Connect. In your workflow, select Gmail as the next application. You will be prompted to create a new connection.

Sign in with your Google account and allow the necessary permissions for Pabbly Connect to access your Gmail. After connecting, you’ll need to configure the sender’s name and email address. This ensures that the emails are sent from your desired account.

Map the recipient’s email address from the previous step in the workflow.
Set the email subject and body, including any personalized content from Google Sheets.

Finally, click on “Save and Send Test Request” to verify that the email is sent successfully. Check your Gmail inbox to confirm receipt.

4. Sending Emails to All Leads Using Pabbly Connect

After successfully sending the first email, you might want to send emails to all leads listed in your Google Sheets. To do this, return to the Pabbly Connect Webhook option in your spreadsheet and click on “Send All Data”. This will trigger the automation to send emails to every lead.

Ensure your inbox is empty before you initiate this step to see the process clearly. Once you click “Send All Data”, emails will be sent one after the other to each recipient listed. This automation saves time and effort, allowing you to reach multiple leads quickly.

Make sure to enable the “Send on Event” option for future entries.
This will ensure emails are sent automatically whenever new data is added.

This step demonstrates the power of Pabbly Connect in automating email outreach efficiently.

5. Conclusion

In this tutorial, we explored how to automate email sending using Pabbly Connect with Google Sheets and Gmail. By following the steps outlined, you can efficiently manage email outreach to multiple leads without manual intervention.

Utilizing Pabbly Connect not only streamlines your email processes but also enhances your productivity. Start automating today and experience the benefits firsthand!