Automate Diwali Wishes with Pabbly Connect and SMTP Integration

Learn how to send automated Diwali wishes using Pabbly Connect and SMTP. Follow our step-by-step guide to integrate Google Sheets for seamless email delivery. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To automate sending Diwali wishes, start by accessing Pabbly Connect. This platform allows you to connect various applications easily. Visit the Pabbly Connect homepage by typing the URL into your browser.

Once on the homepage, you will see options to sign in or sign up. If you are a new user, click on ‘Sign Up for Free’ to create an account. Existing users can simply log in. After signing in, you will be directed to the Pabbly Connect dashboard where you can manage your workflows.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button. A dialog box will prompt you to name your workflow; enter ‘Send Diwali Wishes to Customers via Email Automatically’.

• Select a folder for your workflow, such as ‘Automations for Customer Management’.
• Click ‘Create’ to proceed to the workflow setup.

You will now see a blank canvas with two sections: Trigger and Action. This is where you will set up how data flows from Google Sheets to SMTP.

3. Setting Up Google Sheets as Trigger

The first step in your workflow is to set Google Sheets as the trigger application in Pabbly Connect. Select Google Sheets from the trigger application options. Then, choose the trigger event as ‘New or Updated Spreadsheet Row’. This means the workflow will activate when a new row is added to your spreadsheet.

After selecting the trigger event, you will receive a webhook URL. This URL is essential for transferring data from Google Sheets to Pabbly Connect. Copy this URL, as you will need it to set up the connection in your Google Sheets.

• Navigate to your Google Sheets and go to Extensions > Add-ons > Get Add-ons.
• Search for the ‘Pabbly Connect Webhooks’ add-on and install it.

Once installed, refresh your spreadsheet to access the Pabbly Connect Webhooks option under Extensions. This setup will enable automatic data transfer whenever a new customer is added.

4. Configuring SMTP Action for Email Delivery

With Google Sheets set up as the trigger, the next step is to configure SMTP as the action in Pabbly Connect. Select SMTP from the action application options. Choose the ‘Send Email’ action event. This allows you to send personalized emails to customers based on the data from Google Sheets.

To establish the SMTP connection, you can either add a new connection or select an existing one. If creating a new connection, enter the required SMTP details such as hostname, username, password, encryption type, and port. This information is typically provided when you set up your SMTP account.

Fill in the ‘From Name’ and ‘From Email’ fields with your e-commerce store’s name and the email address you will send from. Map the ‘To’ field to the customer’s email address from the Google Sheets data.

Finally, enter the subject and body of your email, ensuring the body is formatted in HTML to present your Diwali wishes and discount offers attractively.

5. Testing and Launching Your Workflow

Once you have configured the SMTP action in Pabbly Connect, it’s time to test the workflow. Click on ‘Save and Send Test Request’ to verify that the email is sent correctly to the mapped customer email address. Check the inbox to confirm receipt of the email.

If the test is successful and the email appears as intended, your workflow is ready to go live. To send emails to all customers, ensure that the webhook is set to send data whenever a new row is added in your Google Sheets.

Go back to Google Sheets, navigate to Extensions > Pabbly Connect Webhooks, and click ‘Send All Data’. This will trigger the sending of emails to all customers listed in your spreadsheet.

By following these steps, you can effectively automate sending Diwali wishes and discount offers to your customers, enhancing their festive experience while boosting your sales.

Conclusion

Using Pabbly Connect to automate sending Diwali wishes is a straightforward process that saves time and enhances customer engagement. By integrating Google Sheets and SMTP, you can efficiently manage your email campaigns without any coding skills.