Triage your Gmail inbox and log high-priority emails to Google Sheets

Description

Quick overview Three importable workflows that sort your inbox into a Google Sheet, chase failed Stripe payments for you, and follow up new leads once so they do not go cold. No AI credits or paid extras. How it works Runs every 5 minutes and triggers on new unread Gmail messages while excluding Promotions and Social categories. Applies keyword-based rules to classify each email into Money, Customer, Urgent, Admin, Bulk, or Other, and sets a priority plus a short preview. Appends the categorized email details (received date, sender, subject, category, priority, preview, message ID, and status) to an “Inbox” sheet in Google Sheets. Checks whether the email priority is High. Sends an alert email via Gmail to your address with the sender, preview, and a link back to the Google Sheets log when the message is urgent. Setup Connect your Gmail account for both the Gmail trigger (reading unread emails) and the Gmail action (sending alert emails). Connect Google Sheets credentials and replace the spreadsheet URL/ID so the workflow can append rows to your target document. Create an “Inbox” sheet tab with headers: received, from, subject, category, priority, preview, message_id, status. Replace the alert recipient placeholder with your own email address in the Gmail send step. (Optional) Edit the keyword lists in the rules code to match your business categories and terminology. Additional info Honest limits: I use keyword rules, not AI. Each lead gets one follow-up only. Google Sheets is the log. Try Stripe test mode first. Support: jessedu29200@gmail.com. An n8n automation workflow template by Jessy Mariau.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• gmail
• code

Capabilities

• 3 nodes

Information