How to Send Emails Using Pabbly Email Marketing for New Leads in Google Sheets

Learn how to seamlessly send emails using Pabbly Email Marketing for new leads added in Google Sheets, integrated effortlessly with Pabbly Email Marketing. Discover proven email marketing strategies that increase open rates and click-throughs while maintaining deliverability and list health.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Email Marketing for Automation

To send emails using Pabbly Email Marketing, start by accessing the Pabbly dashboard. This platform allows you to automate the emailing process for new leads added in Google Sheets. If you are new, sign up and get 100 free tasks to test the automation.

Once logged in, click on the ‘Create Workflow’ button. You will be prompted to name your workflow. For instance, you can name it ‘Send Individual Email Using Pabbly Email Marketing for New Leads in Google Sheets’ and then click on ‘Create’ to proceed.

2. Integrating Google Sheets with Pabbly Email Marketing

Next, you will set up the integration between Google Sheets and Pabbly Email Marketing. Your trigger application will be Google Sheets, specifically the event for new or updated spreadsheet rows. This means that every time a new lead is added, it will trigger the email sending process.

• Go to Google Sheets and create a sheet named ‘New Leads’ with columns for Name, Email Address, and Contact Number.
• In Pabbly Connect, copy the webhook URL provided after selecting Google Sheets as your trigger.
• In Google Sheets, go to Extensions > Add-ons > Get Add-ons and find the Pabbly Connect Webhooks add-on to install.

After installation, refresh your Google Sheets page and set up the webhook URL in the add-on. Make sure to specify the trigger column where data is added, which is typically the last column with data. Once set, you can test the connection by sending a test lead from Google Sheets.

3. Configuring Pabbly Email Marketing Action

After setting up Google Sheets, the next step is to configure the action in Pabbly Email Marketing. Select Pabbly Email Marketing as your action application and choose the ‘Send Individual Email’ event. This step is crucial as it defines what action to take once a new lead is detected.

When prompted to connect your Pabbly Email Marketing account, you will need an API token. To get this token, log into your Pabbly Email Marketing account, navigate to Integrations, and copy the Developer API token. Paste this token back into Pabbly Connect to establish the connection.

Once connected, you will need to specify the email template and delivery server. Select the desired email template from your Pabbly Email Marketing account, and set the sender’s email address, mapping it to the new lead’s email address from Google Sheets. This ensures that each email is sent to the correct recipient.

4. Testing the Integration of Pabbly Email Marketing

With the integration set up, it’s important to test it to ensure everything works correctly. In Pabbly Email Marketing, after configuring the email settings, click on ‘Save and Send Test Request’. This action will trigger the email sending process based on the test data provided.

Check the recipient’s inbox to confirm that the email has been received successfully. If the test is successful, you can proceed to add new leads in your Google Sheets. Each time a new lead is added, the system should automatically send an email using Pabbly Email Marketing.

To check the real-time functionality, add a new lead to your Google Sheets. For example, enter a name, email, and contact number. Upon hitting enter, you should see an email sent to the new lead’s email address, confirming the integration is working as intended.

5. Conclusion

In this tutorial, we explored how to use Pabbly Email Marketing to send emails automatically for new leads added in Google Sheets. By integrating Google Sheets with Pabbly Connect, you can streamline your email marketing efforts effectively. This automation not only saves time but also ensures that every new lead receives timely communication.

Utilizing Pabbly Connect enhances your ability to manage leads and automate tasks efficiently, making your email marketing strategy more effective and responsive.