Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Email Automation

To send bulk Diwali emails, start by accessing Pabbly Connect. This platform enables seamless integration between Google Sheets and Gmail, allowing you to automate your email campaigns efficiently.

Visit the Pabbly website and log in to your account. If you are new, sign up for an account. Once logged in, navigate to the Pabbly Connect dashboard where you can create a new workflow for sending bulk emails.

2. Creating a Workflow in Pabbly Connect

In Pabbly Connect, create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow something like ‘Send Bulk Diwali Emails from Google Sheets’. This will help you identify the workflow later.

  • Select the folder for your workflow.
  • Choose ‘All Automations’ as the folder.
  • Click ‘Create’ to finalize your workflow.

Your workflow is now set up, and you can start configuring the trigger and action applications. This is where Pabbly Connect shines by connecting Google Sheets as the trigger application and Gmail as the action application.

3. Setting Up the Trigger with Google Sheets

To set up the trigger, select Google Sheets as your trigger application. Choose the event ‘New or Updated Spreadsheet’ to initiate the workflow whenever there’s a new entry.

Connect your Google Sheets account with Pabbly Connect by following the prompts. You will receive a webhook URL that you need to use in your Google Sheets to establish the connection.

  • Open your Google Sheets and go to Extensions.
  • Click on Add-ons and then Get Add-ons.
  • Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, refresh your Google Sheets. Now, go to the Pabbly Connect Webhooks add-on and set up the webhook URL and trigger column. This configuration ensures that whenever data is added to the specified column, it triggers the workflow.

4. Configuring Gmail Action to Send Emails

Next, add an action step in your workflow by selecting Gmail as your action application. Choose the event ‘Send Email’ to configure the email settings for your Diwali greetings.

Connect your Gmail account to Pabbly Connect by clicking on ‘Connect’ and following the authorization steps. Once connected, you will need to provide the sender’s name and email address.

  • Enter the sender’s name, e.g., ‘Pabbly’.
  • Map the recipient’s email address from Google Sheets.
  • Draft your email subject and body for the Diwali message.

Ensure to personalize the email content by mapping the recipient’s name. This way, each email sent through Pabbly Connect feels tailored to the recipient.

5. Sending Bulk Emails with One Click

After configuring the Gmail action, you can now send bulk emails. Return to your Google Sheets, go to the Pabbly Connect Webhooks add-on, and click on ‘Send All Data’. This action triggers the sending of emails to all recipients listed in your Google Sheets.

Once you click ‘Send All Data’, check your Gmail inbox to verify that the emails have been sent successfully. Each recipient will receive a personalized Diwali greeting, demonstrating the power of automation through Pabbly Connect.

  • Open your Gmail account to see the emails.
  • Verify that each email is personalized as intended.
  • Enjoy the efficiency of sending bulk emails in just one click!

This entire process showcases how Pabbly Connect allows you to streamline email campaigns effortlessly, ensuring your Diwali greetings reach everyone with minimal effort.

Conclusion

In conclusion, using Pabbly Connect to send bulk Diwali emails from Google Sheets is an efficient way to automate your email campaigns. With just one click, you can reach all your contacts seamlessly, enhancing your communication efforts.