How to Send Mail to Multiple Users Using Microsoft Office 365 – Google Sheets to Microsoft 365 with Pabbly Connect

Learn how to send mail to multiple users using Microsoft Office 365 and Google Sheets through Pabbly Connect in this detailed tutorial. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Set Up the Integration

To send mail to multiple users using Microsoft Office 365, you first need to access Pabbly Connect. Start by visiting the Pabbly Connect website and signing in or signing up for a new account. New users receive 100 free tasks upon account creation, allowing you to explore the features of this powerful automation tool.

Once logged in, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button, and name your workflow appropriately, such as ‘Send Mails to Multiple Users Using Microsoft Office 365’. This sets the stage for integrating Google Sheets with Microsoft Office 365 through Pabbly Connect.

2. Setting Up Google Sheets as the Trigger Application

In this step, you will set Google Sheets as the trigger application within Pabbly Connect. Select Google Sheets and choose the trigger event as ‘New or Updated Spreadsheet Row’. This means that every time a new row is added to your Google Sheet, it will trigger the workflow to send emails.

• Click on ‘Copy Webhook URL’ to get the URL needed for connecting Google Sheets to Pabbly Connect.
• Go to your Google Sheets, and from the Extensions menu, select Add-ons, then Get add-ons.
• Search for ‘Pabbly Connect Webhooks’ and install it.

After installation, refresh your Google Sheets page. Next, navigate back to Extensions, select ‘Pabbly Connect Webhooks’, and choose ‘Initial Setup’. Paste the copied webhook URL and set the trigger column to the last column where data will be added, such as column C. Finally, click on ‘Send Test’ to ensure the connection is successful.

3. Configuring Microsoft Office 365 as the Action Application

Now that Google Sheets is set up, it’s time to configure Microsoft Office 365 as the action application in Pabbly Connect. Choose Microsoft Office 365 and select the action event as ‘Send Mail to Multiple Users’. This will allow you to send emails to multiple recipients automatically.

To connect Microsoft Office 365, click on ‘Connect’ and grant the necessary permissions. Once connected, you will need to fill in the email details. Enter the subject of the email, such as ‘New Lead Received’, and set the content type to plain text. In the body of the email, include relevant information from your Google Sheets, such as the name, email address, and contact number.

• Map the fields from Google Sheets to the email body in Pabbly Connect.
• Include multiple email addresses in the ‘To’ field, separating them with commas.
• Optionally, add CC or BCC recipients if needed.

After configuring all the necessary fields, click on ‘Save and Send Test Request’ to test the email functionality. Check your email inbox to confirm that the emails have been sent successfully.

4. Testing the Integration with New Data

After setting up the integration, it’s crucial to test if everything works as intended. Go back to your Google Sheets and add a new row with test data, including a name, email address, and contact number. This new entry should automatically trigger the workflow in Pabbly Connect.

Refresh your email inbox to see if the new email has arrived. You should see an email containing the details of the new lead. This confirms that the integration between Google Sheets and Microsoft Office 365 through Pabbly Connect is functioning correctly.

In case you don’t receive the email, review the configurations in both Google Sheets and Pabbly Connect. Ensure that the webhook URL is correctly set, and the trigger column is correctly defined. Additionally, verify that the email addresses entered are valid.

5. Conclusion: Streamlining Email Automation with Pabbly Connect

In this tutorial, we explored how to send mail to multiple users using Microsoft Office 365 and Google Sheets through Pabbly Connect. By setting up a trigger in Google Sheets and an action in Microsoft Office 365, you can automate the email sending process efficiently.

Utilizing Pabbly Connect simplifies the integration process, allowing you to focus on your core tasks while automating repetitive email notifications. This integration not only saves time but also ensures that important information reaches multiple users promptly.

For more tutorials and integration ideas, keep exploring the capabilities of Pabbly Connect to enhance your workflow automation.