AI-Powered Email Summarizer & Responder with Sheets Log

Workflow Steps

Gmail Trigger (New Email)

• Starts when a new email arrives in your Gmail inbox.
• Captures sender, subject, and body content.

AI Summarisation (OpenAI)

• Summarises the email into concise key points.
• Extracts main requests, tone, and important action items.

AI Reply Drafting (OpenAI)

• Generates a short, polite, professional draft reply.
• Ensures the reply maintains context and clear communication.

Log Interaction (Google Sheets)

• Appends email details, AI-generated summary, and reply into a Google Sheet.
• Stores timestamp, sender, subject, summary, and reply status.

Telegram Notification (Telegram Bot)

• Sends the email summary + suggested reply to the user via Telegram.
• Asks for approval (“Yes” to continue).

Approval Check (If Node + Telegram Trigger)

• If approved → move forward to draft creation.
• If rejected → stop workflow, log as “Not approved”.

Create Draft Reply (Gmail)

• Generates a Gmail draft with the AI-generated response.
• Prepares the email for the user’s final review before sending.

Data Sources & Tools

• Gmail → Captures incoming emails & creates draft replies.
• OpenAI GPT → Summarises emails & drafts professional replies.
• Google Sheets → Stores all logs of emails, summaries, and responses.
• Telegram Bot → Sends notifications & captures user approvals.
• n8n If Node → Ensures only approved replies move forward.

Key Benefits

• Saves time by automatically summarising long emails.
• Ensures professional, consistent responses with AI assistance.
• Provides a human approval step before replies are drafted.