Automate Diwali Wishes with Pabbly Connect and SMTP Integration

Learn how to automate sending Diwali wishes using Pabbly Connect with Google Sheets and SMTP. Step-by-step guide for festive email automation. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Diwali Wishes Automation

To automate sending Diwali wishes, start by accessing Pabbly Connect. This platform allows seamless integration between Google Sheets and SMTP for sending personalized emails.

Visit the Pabbly Connect website by typing the URL into your browser. If you’re a new user, click on ‘Sign up for free’ to create an account. Existing users can click ‘Sign in’ to access their accounts. Upon signing up, you will receive 100 free tasks every month to explore automation capabilities.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, navigate to the dashboard and click on ‘Create Workflow’. This initiates the setup process for your automation.

• Name your workflow, for example, ‘Send Diwali Wishes to Customers’.
• Select the appropriate folder for organization.
• Click ‘Create’ to proceed.

Now you will see a blank workflow interface with two main sections: Trigger and Action. The Trigger is the event that starts the workflow, while the Action is the response to that trigger.

3. Setting Up Trigger and Action in Pabbly Connect

In the Trigger section, select Google Sheets as your application. The trigger event will be ‘New or Updated Spreadsheet Row’, which captures new customer data added to your Google Sheet. using Pabbly Connect

• You will receive a webhook URL from Pabbly Connect.
• Copy this URL and follow the setup instructions provided.
• Go to your Google Sheet and install the Pabbly Connect Webhooks add-on.

Once installed, paste the webhook URL into the add-on settings and specify the trigger column. This column will determine when data is sent to Pabbly Connect.

4. Email Automation Using SMTP in Pabbly Connect

After setting up the trigger, now configure the Action step using SMTP by Pabbly. This service allows you to send emails directly from your application. using Pabbly Connect

Choose ‘Send Email’ as the action event and connect to your SMTP account. Enter the necessary details such as:

From Name: Your e-commerce store name. From Email: The email address used for sending. To: Map the customer’s email from the Google Sheets response.

Finally, customize the email subject and body, ensuring the body is in HTML format for better presentation of your Diwali wishes and discount offers.

5. Testing and Launching the Workflow

Once all configurations are complete, it’s time to test your workflow. Click ‘Save and Send Test Request’ to check if emails are being sent correctly through Pabbly Connect.

After a successful test, you can automate sending Diwali wishes to all customers in your Google Sheet. Make sure to click on ‘Send All Data’ in the Pabbly Connect add-on to initiate sending emails to all customers in your list.

This automation streamlines your email marketing for the festive season, ensuring that all customers receive personalized Diwali wishes without manual effort.

Conclusion

This tutorial demonstrates how to use Pabbly Connect to automate sending Diwali wishes via email using Google Sheets and SMTP. Enjoy the benefits of this seamless integration for your festive email campaigns.