Triage Gmail emails, draft AI replies, and log to Google Sheets with GPT-4o

Quick overview Automatically triage your Gmail inbox using OpenAI GPT-4o. Each new email is classified as Urgent or Not Urgent. Urgent emails get an AI-drafted reply saved to Gmail Drafts. All emails are logged to Google Sheets for tracking.

How it works 1. Triggers every minute when a new email arrives in Gmail. 2. Extracts the sender, subject, body text, message ID, and thread ID from the email. 3. Sends the email details to OpenAI GPT-4o to classify the message as URGENT or NOTURGENT. 4. If the email is urgent, OpenAI GPT-4o generates a concise reply and the workflow saves it as a Gmail draft in the original thread. 5. Appends a row to Google Sheets for each email, marking the urgency and whether a draft was created.

Setup 1. Connect a Gmail OAuth2 credential and adjust any trigger filters (such as labels) to control which emails are processed. 2. Add an OpenAI API credential with access to the gpt-4o model for both the classification and reply-drafting steps. 3. Connect a Google Sheets OAuth2 credential, set the target spreadsheet ID and sheet name, and create the columns Timestamp, Sender, Subject, Urgency, and Draft Created.

Requirements - Gmail account connected via OAuth2 - OpenAI API key with GPT-4o access - Google account with Google Sheets OAuth2 connected - A Google Sheet with headers: Timestamp | Sender | Subject | Urgency | Draft Created

Customization - Change the Gmail Trigger to watch a specific label (e.g. "Clients" or "Support") instead of the full inbox to narrow the scope - Edit the urgency classification prompt in the Classify Email Urgency node to add a MEDIUM priority tier and add a third IF branch - Modify the reply tone in the Draft Urgent Reply node prompt — change "professional" to "friendly", "concise", or "formal" - Add a Slack or Telegram node after the IF node to send yourself an instant notification when an urgent email is detected - Replace the Google Sheets log with Notion, Airtable, or a CRM of your choice