Triage your Gmail inbox and log high-priority emails to Google Sheets
Go to WorkflowDescription
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: [email protected]
This workflow was created by Jessy Mariau and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.