How to Add Unsubscribed SendGrid Subscriber in MySQL Using Pabbly Connect

Learn how to use Pabbly Connect to integrate SendGrid and MySQL, automatically adding unsubscribed contacts to your MySQL database. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for SendGrid and MySQL Integration

To start integrating SendGrid and MySQL, we first need to access Pabbly Connect. This platform allows us to automate workflows by connecting different applications seamlessly. Begin by visiting Pabbly’s website and logging into your account or signing up for a new one.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. This is where you will define the trigger and action for your integration.

2. Creating the Workflow in Pabbly Connect

In the workflow creation window, you need to name your workflow. For this integration, we will name it ‘Add Unsubscribed SendGrid Subscriber in MySQL’. Next, select the folder where you want to save this workflow.

• Click on the ‘Create’ button to proceed.
• Choose ‘SendGrid’ as the trigger application.
• Select ‘Webhook’ as the trigger event.

After setting the trigger, you will be prompted to connect SendGrid with Pabbly Connect. This requires copying the provided webhook URL and setting it up in your SendGrid account.

3. Configuring the SendGrid Webhook

To configure the webhook in SendGrid, log into your SendGrid account and navigate to the settings. Under the Mail Settings, find the Webhook settings. Here, click on ‘Create New Webhook’ and enter a friendly name for your webhook.

• Paste the webhook URL from Pabbly Connect into the Post URL field.
• Select ‘Unsubscribed’ as the action to be posted.
• Test the integration to ensure the connection is successful.

After saving the webhook, return to Pabbly Connect to verify that you have received the test response from SendGrid, confirming that the integration is working correctly.

4. Setting Up MySQL Action in Pabbly Connect

Now that we have the SendGrid trigger set up, the next step is to configure the action in Pabbly Connect to insert the unsubscribed contact details into MySQL. Select ‘MySQL’ as the action application.

Choose ‘Insert Rows’ as the action event. You will need to connect your MySQL database with Pabbly Connect. If you have an existing connection, select it; otherwise, create a new one by entering your database credentials.

5. Mapping Data to MySQL Database

After connecting MySQL, you will need to map the data fields from SendGrid to your MySQL database. Start by selecting the appropriate table where the data will be stored, such as ‘new_contact’.

Map the ID, email, and date fields from the SendGrid response to the corresponding columns in your MySQL table. After mapping, click on ‘Save and Send Test Request’ to verify the integration.

Once the test is successful, you can check your MySQL database to confirm that the unsubscribed contact details have been added automatically. This completes the integration process using Pabbly Connect to manage unsubscribed contacts from SendGrid.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding unsubscribed SendGrid contacts to a MySQL database. By following these steps, you can efficiently manage your subscriber data and ensure accurate records in your database.