Categorize and Track Company Emails with OpenRouter AI and Google Sheets

This workflow monitors your company email inbox via IMAP for new messages. Upon receiving an email, it fetches existing categories and requests from a Google Sheets document. An OpenRouter AI agent then analyzes the email's subject and body to assign a relevant category (e.g., sales inquiry, support request) and request type.

Next, it searches the sheet for matching category-request combinations. If a match is found, it increments the request count in that row; if not, it appends a new row with the category, request type, and an initial count of 1. This enables effortless tracking of email patterns without manual intervention.

Benefits include time savings on email sorting, actionable insights into customer requests via Sheets dashboards, and scalability for sales/CRM teams. Ideal use cases: sales proposal tracking, lead qualification, customer support categorization, or marketing campaign response analysis. Setup takes 15-20 minutes with pre-connected accounts.