Send Promotional Emails to All Leads in One Click Using Pabbly Connect

Learn how to send promotional emails to all leads in one click using Pabbly Connect. Follow this detailed tutorial for seamless integration with Google Sheets and Gmail.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Email Automation

To send promotional emails to all your leads, the first step is to access Pabbly Connect. If you are an existing user, log in directly to your Pabbly Connect account and navigate to the workflow builder.

If you are a new user, go to the Pabbly Connect landing page URL provided in the description box, and click on the ‘Sign up for free’ option in the top right corner. You will receive hundreds of tasks free every month to explore the capabilities of Pabbly Connect.

2. Setting Up Google Sheets for Lead Management

Once you are in Pabbly Connect, the next step is to set up Google Sheets as your lead database. Click on the ‘Add Trigger’ button and search for Google Sheets. Select it and choose the event ‘New or Updated Spreadsheet Row’. Then click on ‘Connect’.

• Copy the generated webhook URL.
• Go to your Google Sheets, click on Extensions, then Add-ons, and select ‘Get Add-ons’.
• Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, refresh your Google Sheets to see the Pabbly Connect Webhooks option. Go to Extensions, select ‘Pabbly Connect Webhooks’, and click on ‘Initial Setup’. Paste the copied webhook URL and set your trigger column (for example, column D). Click ‘Submit’ to finish the setup.

3. Capturing the Webhook Response in Pabbly Connect

After configuring the trigger in Google Sheets, the next step is to capture the webhook response in Pabbly Connect. Click on the ‘Send Test’ button to send test data from Google Sheets to Pabbly Connect.

Once you see a confirmation that the test data was sent successfully, return to your workflow in Pabbly Connect. You should see the captured response reflected in the workflow. This indicates that the connection between Google Sheets and Pabbly Connect is successfully established.

4. Sending Promotional Emails via Gmail

Next, we will set up Gmail to send promotional emails. In your workflow, click on ‘Add New Action Step’ and search for Gmail. Select it and choose the event ‘Send Email’. Click on ‘Connect’. using Pabbly Connect

• If you have an existing connection, select it; otherwise, create a new connection by signing in with Google.
• Enter the sender’s name and select the sender’s email from the drop-down.
• Map the recipient’s email address dynamically from the previous step.

Fill in the email subject and body. Use HTML content for personalization by mapping the lead’s name dynamically. After completing these fields, click ‘Save and Send Test Request’ to send a test email. Check your Gmail to confirm the email was received successfully.

5. Sending Emails to All Leads in One Click

To send promotional emails to all leads in your Google Sheets, go back to your Google Sheets and click on ‘Pabbly Connect Webhooks’ in the Extensions menu. Select ‘Send All Data’. This action will trigger Pabbly Connect to send emails to each lead listed in your Google Sheets.

As emails are sent, you will see them arrive in your Gmail inbox, each personalized with the respective lead’s name. This automation allows you to send multiple promotional emails with just one click, showcasing the efficiency of Pabbly Connect.

In summary, by using Pabbly Connect, you can automate the process of sending promotional emails to all your leads efficiently. This integration simplifies email marketing and enhances your outreach efforts.

Conclusion

In this tutorial, we explored how to send promotional emails to all leads in one click using Pabbly Connect. By integrating Google Sheets and Gmail, you can streamline your email marketing process and enhance communication with your leads effectively.