Track data deletion requests from Gmail with Jira, BigQuery, and Slack

Quick Overview This workflow monitors a Gmail inbox for potential privacy/data deletion requests, classifies each email, creates the appropriate Jira issue, logs a minimal audit record to BigQuery, and alerts the team in Slack, with an optional Gmail confirmation draft for human review.

How it works Triggers when a new email matching deletion-related keywords arrives in Gmail (or runs manually for testing). Loads shared configuration values like Jira project details, BigQuery destination, SLA window, Slack channel, and confidence threshold. Cleans the email text, extracts the requester address, classifies the request type (deletion/access/correction), and calculates an SLA due date with a confidence score. Creates a Jira task for the privacy team when the classification is confident, or creates a separate Jira task labeled for manual review when it is not. Inserts an audit row into Google BigQuery with metadata such as request type, confidence, received time, due date, and whether a Jira issue was created. Posts a Slack message to the configured channel about the routed request or the need for manual review. Creates a draft confirmation email in Gmail for the requester after a routed request.

Setup Connect Gmail credentials for the inbox to monitor and ensure the Gmail trigger query matches the keywords you use for privacy requests. Add Jira credentials (or an Atlassian API token via HTTP auth) and set your Jira base URL, project key, and issue type in the workflow variables. Add Google Cloud/BigQuery credentials for the BigQuery API and create the target project, dataset, and table referenced in the workflow variables. Add Slack credentials for the Slack Web API and set the target channel ID in the workflow variables. Update the workflow variables for your SLA days, minimum confidence threshold, and manual-review label, and replace the Gmail draft node with a proper base64url-encoded MIME template if you want to keep the confirmation draft step.