How to Add Unsubscribed SendGrid Subscriber in MySQL Using Pabbly Connect

Learn how to integrate SendGrid with MySQL using Pabbly Connect to automatically add unsubscribed contacts to your database. Step-by-step tutorial included. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start adding unsubscribed SendGrid contacts into MySQL, you first need to access Pabbly Connect. This powerful integration platform allows you to automate workflows between different applications seamlessly.

Visit the Pabbly website and either sign in or create a free account. Once logged in, you will be directed to the dashboard where you can access various applications. Look for the option to create a new workflow.

2. Creating a New Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a new workflow. Click on the ‘Create Workflow’ button to initiate this process. You will be prompted to name your workflow.

• Name your workflow to reflect its purpose, such as ‘Add Unsubscribed SendGrid Subscriber in MySQL’.
• Select a folder to save your workflow, for example, the ‘Home’ folder.

Once you have set up your workflow name and folder, you will see two sections: Trigger and Action. The Trigger will initiate the workflow, while the Action will execute the desired outcome.

3. Setting Up the Trigger with SendGrid

The first step in your workflow is to set up the Trigger. Select SendGrid as your trigger application within Pabbly Connect. The trigger event you need to choose is ‘Webhook’. This will allow you to receive notifications when a contact unsubscribes.

After selecting the trigger, you will be provided with a Webhook URL. Copy this URL, as it will be used to connect SendGrid to Pabbly Connect. Go to your SendGrid account, navigate to Settings, and locate the Mail Settings section.

• In Mail Settings, find Webhook Settings and click on ‘Create New Webhook’.
• Paste the copied Webhook URL into the Post URL field and select ‘Unsubscribed’ as the action to be posted.

Test the integration to ensure that the connection works properly. Once confirmed, save the settings in SendGrid and return to Pabbly Connect to verify that the trigger is set up correctly.

4. Setting Up the Action with MySQL

Now that your trigger is configured, it’s time to set up the Action with MySQL using Pabbly Connect. Choose MySQL as your action application and select ‘Insert Row’ as the action event. This action will add the unsubscribed contact details to your MySQL database.

To connect MySQL to Pabbly Connect, click on ‘Add New Connection’. You will need to provide the necessary database credentials. If you have previously connected MySQL, you can select the existing connection instead.

Select the appropriate table in your MySQL database where the unsubscribed contacts will be stored. Map the fields such as ID, Email, and Date from the SendGrid response to the corresponding columns in your MySQL table.

After mapping the fields, click on ‘Save and Send Test Request’. If successful, you will receive a confirmation that the details have been added to your MySQL database.

5. Testing the Integration

With both the Trigger and Action set up in Pabbly Connect, it’s crucial to test the integration. Unsubscribe a contact in SendGrid to trigger the workflow. This action should send the unsubscribe details to Pabbly Connect and subsequently insert them into your MySQL database.

Return to your MySQL database to verify that the unsubscribed contact’s details have been recorded correctly. You should see the ID, email address, and unsubscribe date reflected in your database.

This process confirms that your integration is functioning as intended. You can now automate the addition of unsubscribed contacts from SendGrid to MySQL effortlessly using Pabbly Connect.

Conclusion

Using Pabbly Connect, you can efficiently integrate SendGrid with MySQL to automatically add unsubscribed contacts to your database. This step-by-step guide outlines the necessary actions for seamless automation.