Automatic Email Unsubscribe Handler: Outlook to BigQuery Integration

This n8n workflow automates the process of identifying and logging email unsubscribe requests from Microsoft Outlook into Google BigQuery. It simplifies the management of unsubscribe requests, ensuring that your marketing efforts remain compliant and your contact lists are up-to-date.

What it does

This workflow performs the following key steps:

1. Triggers on Schedule: The workflow runs periodically (e.g., every 5 minutes) to check for new emails.
2. Fetches Emails from Outlook: It connects to your Microsoft Outlook account and retrieves recent emails.
3. Filters for Unsubscribe Requests: It intelligently filters these emails to identify those containing keywords related to unsubscribe requests (e.g., "unsubscribe", "opt-out", "remove me").
4. Extracts Relevant Information: For each identified unsubscribe email, it extracts crucial details such as the sender's email address, the subject, and the received date.
5. Prepares Data for BigQuery: It transforms the extracted email data into a structured format suitable for insertion into a Google BigQuery table.
6. Logs to Google BigQuery: The processed unsubscribe requests are then inserted as new rows into a specified Google BigQuery table, creating a centralized log of all unsubscribe events.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Microsoft Outlook Account: An Outlook account with credentials configured in n8n. This will be used to fetch emails.
• Google BigQuery Account: A Google Cloud Project with BigQuery enabled and credentials configured in n8n. This will be used to store unsubscribe data.
• BigQuery Table: A BigQuery dataset and table specifically designed to store unsubscribe requests (e.g., with columns for senderEmail, subject, receivedDate).

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, click on "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON code and click "Import".
2. Configure Credentials:
   • Locate the "Microsoft Outlook" node and "Google BigQuery" node.
   • Click on each node and select or create the necessary credentials for your Microsoft Outlook and Google BigQuery accounts.
3. Customize Schedule (Optional):
   • The "Schedule Trigger" node is configured to run at a specific interval. Adjust the interval as needed (e.g., every 5 minutes, hourly).
4. Configure Outlook Email Search:
   • In the "Microsoft Outlook" node, review the "Operation" and "Parameters" to ensure it's fetching emails from the correct folder and with appropriate search criteria.
5. Refine Unsubscribe Filter:
   • The "Filter" node uses a basic condition to identify unsubscribe emails. You might want to enhance the conditions to include more keywords or use regular expressions for more robust detection.
6. Map Data for BigQuery:
   • In the "Edit Fields" node, ensure that the fields extracted from the email (e.g., from.emailAddress.address, subject, receivedDateTime) are correctly mapped to the column names of your BigQuery table.
   • In the "Google BigQuery" node, specify your BigQuery "Project ID", "Dataset ID", and "Table ID".
7. Activate the Workflow:
   • Once configured, save the workflow and activate it by toggling the "Active" switch in the top right corner.

The workflow will now automatically run on schedule, process unsubscribe requests from Outlook, and log them into your BigQuery database.