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

Workflow overview

Why this workflow matters

Helpful for business development and pipeline building. Relevant for managed services and support workflows.

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 Triggers every minute when a new email arrives in Gmail. Extracts the sender, subject, body text, message ID, and thread ID from the email. Sends the email details to OpenAI GPT-4o to classify the message as URGENT or NOT_URGENT. 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. Appends a row to Google Sheets for each email, marking the urgency and whether a draft was created. Setup Connect a Gmail OAuth2 credential and adjust any trigger filters (such as labels) to control which emails are processed. Add an OpenAI API credential with access to the gpt-4o model for both the classification and reply-drafting steps. 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

Best fit

Need another direction?