Categorize and Track Company Emails with OpenRouter AI and Google Sheets

About

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.