Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To begin integrating Outlook with Google Sheets, you must access Pabbly Connect. Open a new tab and visit pabby.com/connect to reach the Pabbly Connect landing page.

If you are new to Pabbly Connect, you can sign up for a free account. This account provides you with 100 free tasks to test out the integration features. After signing up, log in to your account to access the dashboard.

2. Creating a New Workflow in Pabbly Connect

Once you are logged into Pabbly Connect, navigate to the “Create Workflow” option. Select “Create Using Quick Builder” to begin setting up your integration.

In the workflow setup, specify your request. For this integration, type “Microsoft Office 365 to Google Sheets”. This request will guide Pabbly Connect in setting up the necessary connections.

  • Select the event for receiving new emails in Outlook.
  • Approve the workflow creation.
  • Open the created workflow to build connections.

After creating your workflow, you will see the entire setup in front of you. Proceed to build the necessary connections between Outlook and Google Sheets.

3. Connecting Microsoft Outlook to Pabbly Connect

To connect your Outlook account, open the connection step in Pabbly Connect. Click on the “Add New Connection” option and select the “Connect with Microsoft 365” button.

A new window will prompt you to grant access to your Outlook account. Click the “Accept” button to allow Pabbly Connect to access your email data securely.

  • Confirm the connection by clicking “Save and Send Test Request”.
  • Wait for a webhook response to ensure the connection is successful.
  • Send a test email to your Outlook account to verify the integration.

Once the connection is established, you can proceed to set up the Google Sheets integration.

4. Adding Google Sheets to Your Pabbly Connect Workflow

After successfully connecting Outlook, the next step is to integrate Google Sheets using Pabbly Connect. Click on the action button and select the “Connect” option.

Choose “Add New Connection” and click on the “Sign in with Google” button. Select the Google account linked to your Google Sheets.

  • Grant access to Pabbly Connect to manage your Google Sheets.
  • Select the specific spreadsheet and sheet where you want to store email details.
  • Map the data fields from the Outlook email to the corresponding columns in Google Sheets.

By mapping the email fields such as sender’s email address, subject, and body, you ensure that each new email is recorded accurately in your Google Sheets.

5. Testing and Finalizing Your Integration

After mapping the data fields, click on the “Save and Send Test Request” button in Pabbly Connect. This action will send a test record to your Google Sheets.

Verify that the email details have been added correctly in your designated spreadsheet. If successful, you will see the email address, subject, and content reflected in your Google Sheets.

  • Ensure that all details are correctly populated in the spreadsheet.
  • Confirm that future emails will automatically populate in Google Sheets.

With the integration successfully set up, any new emails received in your Outlook account will now be automatically logged in your Google Sheets, streamlining your email management process.

Conclusion

Integrating Outlook with Google Sheets using Pabbly Connect automates email management by ensuring all incoming emails are logged systematically. This setup saves time and improves efficiency in handling email inquiries.