Categorize and Track Company Emails with OpenRouter AI and Google Sheets

How it works

• Watches inbox for new emails via IMAP.
• Fetches existing categories and requests from Google Sheets.
• Uses AI to analyze subject and body, then assigns a category and request type.
• Checks if the same category/request already exists in the sheet.
• If found, increments the request count for that row.
• If new, adds a fresh row with category, request, and count set to 1.

Set up steps

• Connect IMAP email account for inbox access.
• Connect Google Sheets account and link to the target sheet.
• Connect AI service account (OpenRouter).
• Import workflow into automation platform and map credentials.
• Test once with a sample email to verify classification and sheet update.
• Estimated setup time: ~15–20 minutes with accounts ready.