How to Send Mandrill Data to Google Sheets Automatically Using Pabbly Connect

Learn how to integrate Mandrill with Google Sheets using Pabbly Connect. Automate the process of sending Mandrill data to Google Sheets effortlessly. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Mandrill and Google Sheets Integration

To begin the integration process, you need to access Pabbly Connect. Start by logging into your Pabbly Connect account. If you don’t have an account, you can create one using the link provided in the description. Pabbly Connect allows you to automate workflows without needing coding skills.

Once logged in, navigate to your dashboard and click on the ‘Create Workflow’ button. You can name your workflow, for example, ‘Send Data from Mandrill to Google Sheets Automatically’. After naming, click on the ‘Create’ button to proceed with your workflow setup.

2. Configuring the Trigger Event in Pabbly Connect

In this section, you will set up the trigger for your workflow. The trigger is an event that starts the automation process. Click on the trigger window and select Mandrill as your trigger application. Next, choose the trigger event, which in this case is ‘Message Rejected’. This event occurs when an email sent through Mandrill is not delivered. using Pabbly Connect

• Select Mandrill from the application list.
• Choose ‘Message Rejected’ as the trigger event.
• Click on ‘Connect’ and then select ‘Add New Connection’.

After connecting, you will need to provide your Mandrill API key. You can find this in your Mandrill account settings under the API Keys section. Copy this key and paste it into Pabbly Connect to establish the connection.

3. Setting Up the Action to Send Data to Google Sheets

Now that the trigger is configured, the next step is to define the action that will occur when the trigger is activated. Click on the ‘+’ icon to add an action step and select Google Sheets as the application. Choose the action event as ‘Add New Row’. This action will allow you to send the data captured from Mandrill to a Google Sheets document automatically. using Pabbly Connect

• Select Google Sheets from the application list.
• Choose ‘Add New Row’ as the action event.
• Connect your Google Sheets account by selecting ‘Add New Connection’.

Once connected, select the specific spreadsheet you want to use. Choose the sheet name where you want the data to be added. Map the fields from the trigger data to the corresponding columns in your Google Sheets. This ensures that the data is organized correctly.

4. Testing Your Mandrill to Google Sheets Integration

After setting up the action, it’s essential to test your integration to ensure everything works as expected. Click on ‘Save and Send Test Request’ in Pabbly Connect. This will send a test email through Mandrill, which should be rejected, allowing you to capture the data in your workflow. using Pabbly Connect

Check your Google Sheets document to confirm that a new row has been added with the relevant data from the rejected email. The fields should include the sender’s email, recipient’s email, and the reason for the rejection. If the data appears as expected, your integration is functioning correctly.

5. Finalizing Your Automation with Pabbly Connect

Once you have verified that your integration works correctly, you can finalize your automation. If you plan to run email marketing campaigns through Mandrill, you can remove the test step. Your automation will now run in real-time, capturing data from rejected emails automatically and sending it to your Google Sheets. using Pabbly Connect

With Pabbly Connect, you have successfully created an automated workflow that saves time and organizes your data efficiently. Remember, this setup only needs to be done once. From now on, whenever an email is rejected, the information will be sent to your Google Sheets without any manual effort.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the process of sending Mandrill data to Google Sheets. This integration allows for seamless data management and saves valuable time, ensuring you can focus on your core business activities.