Categorize and Track Company Emails with OpenRouter AI and Google Sheets

Description

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.