How to Send Emails from Google Sheets Using SMTP by Pabbly

Learn how to send emails from Google Sheets using SMTP by Pabbly Connect. Follow this detailed tutorial for seamless integration and automation. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Email Automation

To send emails from Google Sheets using SMTP by Pabbly, first, access Pabbly Connect. This platform allows you to automate workflows easily. Start by visiting the Pabbly Connect website and sign in to your account.

If you are a new user, you can sign up for free and get 100 tasks every month. Once logged in, navigate to the dashboard where you can see all available apps. Click on ‘Access Now’ under the Pabbly Connect option to begin the setup.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ button located at the top right corner. A dialog box will appear asking for a workflow name and folder selection.

• Name your workflow: How to send emails from Google Sheets using SMTP by Pabbly.
• Select a folder for saving the workflow, for example, ‘SMTP Automations’.
• Click on ‘Create’ to finalize the workflow creation.

Once created, you will see two windows: Trigger and Action. The trigger is essential as it defines when the action will occur, which is when data is added to Google Sheets.

3. Setting Up Google Sheets Trigger in Pabbly Connect

To set up the trigger in Pabbly Connect, click on the arrow in the Trigger application section. Select ‘Google Sheets’ as your trigger application. Then choose the event as ‘New or Updated Spreadsheet Row’.

Pabbly Connect will provide you with a webhook URL. Copy this URL, as it will be used to connect Google Sheets with Pabbly Connect. Open your Google Sheets, click on ‘Extensions’, then ‘Add-ons’, and select ‘Get Add-ons’ to install the Pabbly Connect Webhooks add-on if you haven’t done so yet.

• Search for ‘Pabbly Connect Webhooks’ and install it.
• After installation, go back to ‘Extensions’, select ‘Pabbly Connect Webhooks’, and click on ‘Initial Setup’.
• Paste the webhook URL and set the trigger column (e.g., column D).

Click on the Submit button to complete the setup. Ensure to enable the ‘Send on Event’ option to allow data to be sent to Pabbly Connect whenever new data is entered.

4. Configuring SMTP Action in Pabbly Connect

Now it’s time to set up the action step in Pabbly Connect. Click on the Action application section and select ‘SMTP by Pabbly’. Choose the action event as ‘Send Email’. Click on Connect to establish a connection with the SMTP service.

A new window will prompt you to add a new connection. Fill in the required details such as hostname, username, password, encryption type, and port. After entering the details, click on the Save button to connect SMTP by Pabbly with Pabbly Connect.

Fill in the ‘From Name’ and ‘From Email’ fields. Map the ‘To Email’ field with the email address from Google Sheets. Set the email subject and body as required.

Once all details are filled in, click on the ‘Save and Send Test Request’ button. This will send a test email to verify the setup is working correctly.

5. Testing the Integration of Google Sheets and SMTP

To test the integration, return to your Google Sheets and enter a new customer’s details. For instance, fill in the first name, last name, email, and phone number. After entering the details, check your Gmail account to see if you received the email.

If everything is set up correctly, you should receive an email with the content specified in your Pabbly Connect workflow. This confirms that the integration between Google Sheets and SMTP by Pabbly is successful.

Repeat this process for additional entries in your Google Sheets to ensure consistent functionality. Each time you add a new row, an email should be sent automatically, demonstrating the seamless automation enabled by Pabbly Connect.

Conclusion

This guide summarizes the key points and helps you understand the essential features and benefits of using this tool.

In conclusion, using Pabbly Connect to send emails from Google Sheets via SMTP is a powerful way to automate your email marketing efforts. This integration saves time and ensures your customers receive timely communication, enhancing their experience and boosting your business efficiency.