Learn how to send automated emails to disqualified candidates using Pabbly Connect. Follow this step-by-step tutorial to set up MySQL to Gmail integration effortlessly. 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 Automation

To automate emails to disqualified candidates, the first step is to access Pabbly Connect. Start by typing Pabbly.com in your browser. Here, you can navigate to the products section and select Pabbly Connect.

If you are a new user, click on the ‘Sign Up for Free’ button to create an account within minutes. Existing users can simply sign in. Once logged in, click on the ‘+ Create Workflow’ button to initiate your automation process.


2. Creating a Workflow in Pabbly Connect

After accessing your dashboard in Pabbly Connect, the next step is to create a workflow. Name your workflow, for instance, ‘Send Automated Emails to Disqualified Candidates,’ and click on the ‘Create’ button to proceed.

  • Select MySQL as the trigger application.
  • Choose ‘New Row in Table’ as the trigger event.
  • Connect your MySQL database by entering the required credentials.

Once you have set up the trigger, Pabbly Connect will monitor your MySQL database for new entries, specifically focusing on candidates marked as disqualified.


3. Integrating MySQL with Gmail via Pabbly Connect

Following the creation of your workflow, the next step is to integrate MySQL with Gmail through Pabbly Connect. This integration allows automatic email notifications to disqualified candidates.

After establishing your MySQL connection, select the relevant table that contains candidate data. Ensure you set a unique identifier for the candidates, such as ‘Candidate ID’, to accurately track entries.

  • Fill in the database username, password, host, and port.
  • Choose the table where candidate details are stored.
  • Select the unique column to track updates.

Once configured, Pabbly Connect will pull data from MySQL, allowing you to send emails based on the candidate’s status.


4. Sending Automated Emails to Disqualified Candidates

To send emails to disqualified candidates, navigate to the action step in Pabbly Connect and select Gmail as the application. Choose ‘Send Email’ as the action event.

Connect your Gmail account by clicking on ‘Add New Connection’ and follow the prompts to authorize access. Once connected, you will need to fill out the email details, including the recipient’s address, subject, and message body.

Map the recipient’s email address from the MySQL data. Draft a personalized email content thanking the candidate for their application. Test the email sending process to ensure functionality.

After sending a test email, check the recipient’s inbox to confirm that the email was received successfully. This ensures that your integration is working as intended.


5. Filtering Candidates for Email Notifications

To ensure that only disqualified candidates receive emails, set up a filter in Pabbly Connect. This filter will check the candidate’s status and only proceed if it matches ‘disqualified’.

In the action step, choose the filter application and set the condition to check if the status equals ‘disqualified’. This ensures that your workflow runs only for the intended candidates.

After applying the filter, you can test the workflow to confirm that it captures the correct candidates. If the filter criteria are met, Pabbly Connect will allow the email sending process to continue.


Conclusion

In this tutorial, we explored how to automate emails to disqualified candidates using Pabbly Connect. By integrating MySQL with Gmail, you can efficiently manage your candidate communications. This process not only saves time but also ensures that your disqualified candidates receive timely notifications.

Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.