Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Bulk Email Automation

To begin sending bulk emails using Pabbly Connect, first open your browser and navigate to pabbl.com/connect. If you are a new user, click on the “Sign Up for Free” button located at the top right corner of the page. This gives you access to 100 free tasks every month, allowing you to explore the capabilities of Pabbly Connect.

Once you’ve signed up, you can start creating workflows. If you’re an existing user, simply log in to your account and access your workflow dashboard. Here, you can set up a new automation to send bulk emails through Gmail using data from Google Sheets.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, click on the “Add New Workflow” button to create a new automation. This is where you will define the trigger and actions for your email sending process. The trigger will be set to Google Sheets, specifically selecting the “New or Updated Spreadsheet Row” option.

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

Once you’ve set the trigger, copy the webhook URL provided by Pabbly Connect and head over to your Google Sheets to set up the integration. This step is crucial as it allows data to flow from Google Sheets into your Pabbly workflow.

3. Setting Up Google Sheets with Pabbly Connect

To configure Google Sheets, open the sheet containing your email leads. Navigate to the “Extensions” menu, select “Add-ons”, and then click on “Get add-ons”. Search for “Pabbly Connect Webhooks” and install the extension if you haven’t already done so.

After installation, refresh your Google Sheets. You should now see the “Pabbly Connect Webhooks” option. Click on it, then select “Initial Setup”. Paste the copied webhook URL and specify the trigger column, which is the column that will initiate the workflow when updated.

  • Paste the webhook URL.
  • Enter the trigger column (e.g., Column D).
  • Click “Submit” to save your settings.

Once configured, you will see a message indicating the setup was successful. This means your Google Sheets is now connected to Pabbly Connect and ready to send data.

4. Sending Emails via Gmail with Pabbly Connect

With your Google Sheets set up, return to Pabbly Connect to add an action step. Click on “Add New Action Step” and select Gmail as the action application. Choose the action event as “Send Email” and click on “Connect” to link your Gmail account.

If this is your first time connecting Gmail, you will need to sign in and grant the necessary permissions. Once connected, you can customize the email settings, including the sender’s name and email address. For the recipient’s email address, map it from the previous step to ensure each email is sent to the correct contact.

  • Map the recipient email from Google Sheets.
  • Enter your email subject and content.
  • Use dynamic mapping to personalize your emails.

After filling in the required fields, click on “Save and Send Test Request”. You should receive a confirmation that the email was sent successfully, demonstrating that Pabbly Connect has successfully facilitated the email sending process.

5. Sending Bulk Emails Using Pabbly Connect

To send bulk emails to all contacts listed in your Google Sheets, simply return to the “Pabbly Connect Webhooks” option in your Google Sheets. Click on “Send All Data” to trigger the workflow for each contact in your sheet.

Once you click this option, Pabbly Connect will process each row and send emails to all recipients listed. You can monitor the progress by refreshing your Gmail inbox to see the emails arriving in real-time.

  • Click “Send All Data” in Google Sheets.
  • Refresh your Gmail to check for incoming emails.
  • Watch as emails are sent to all contacts.

This process showcases the power of automation with Pabbly Connect, allowing you to send bulk emails efficiently and effectively.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to send bulk emails through Gmail using data from Google Sheets. This integration not only simplifies the process but also enhances efficiency, allowing for personalized communication with multiple recipients.