Automate Email Sending from Google Sheets Using Pabbly Connect and Elastic Email

Learn how to automate email sending from Google Sheets using Pabbly Connect and Elastic Email with this step-by-step tutorial. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Email Automation

To start automating email sending from Google Sheets, first access Pabbly Connect. You can reach the platform by typing the URL Pabbly.com/connect in your browser. Once on the homepage, you will see options to sign in or sign up for free.

If you’re a new user, click on the ‘Sign Up for Free’ button to create your account. After signing up, you will receive 100 free tasks every month to explore the software. Existing users can click on ‘Sign In’ to access their dashboard directly.

2. Creating a Workflow in Pabbly Connect

After signing in, navigate to the dashboard of Pabbly Connect. Here, you can find all your existing workflows. To create a new workflow, click on the ‘Create Workflow’ button located in the top right corner.

• Provide a name for your workflow, such as ‘Send Automated Email from Google Sheets using Elastic Email’.
• Select the folder where you want to save your workflow.
• Click on the ‘Create’ button to proceed.

Once created, you will see two windows for trigger and action. The trigger is the event that starts the automation, while the action is what happens as a result of the trigger. In this case, we will select Google Sheets as the trigger application and Elastic Email as the action application.

3. Setting Up Google Sheets as a Trigger in Pabbly Connect

To set up Google Sheets in Pabbly Connect, select it as your trigger application. The trigger event you need to choose is ‘New or Updated Spreadsheet Row’. This event will activate the workflow whenever a new row is added to your Google Sheets.

After selecting the trigger event, Pabbly Connect will provide a webhook URL. Copy this URL to connect your Google Sheets with Pabbly Connect. Go to your Google Sheets, click on ‘Extensions’, and then select ‘Add-ons’ to find the Pabbly Connect Webhooks add-on. Install it if you haven’t already.

• Paste the copied webhook URL in the add-on settings.
• Specify the trigger column that will send data to Pabbly Connect.
• Click on ‘Send Test’ to verify the connection.

After successfully sending the test data, you will see the response in Pabbly Connect, confirming that the connection is established.

4. Configuring Elastic Email as an Action in Pabbly Connect

Next, you need to configure Elastic Email in Pabbly Connect as your action application. Select Elastic Email and choose the action event ‘Send Transactional Email’. Click on ‘Connect Now’ to create a new connection with your Elastic Email account.

To establish this connection, you will need to enter your Elastic Email API key. Go to your Elastic Email account, navigate to ‘Settings’, and select ‘Manage API Keys’. Create a new API key with full access and copy it.

Paste the API key in Pabbly Connect. Map the email address, subject line, and content from the Google Sheets response. Click on ‘Save and Send Test Request’ to send a test email.

Once the test email is sent, check your inbox to confirm that the email has been received successfully. This indicates that your integration is working correctly.

5. Conclusion: Automate Your Email Process with Pabbly Connect

In this tutorial, we have successfully demonstrated how to automate email sending from Google Sheets using Pabbly Connect and Elastic Email. By setting up triggers and actions, you can streamline your email marketing efforts without any coding skills.

This integration allows you to send personalized emails to your customers automatically whenever new data is added to your Google Sheets. With Pabbly Connect, you can easily manage such automations and enhance your business’s efficiency.

Now you can explore more integrations using Pabbly Connect to connect various applications and automate your workflows effectively.