Back to Templates

Categorize and Track Company Emails with OpenRouter AI and Google Sheets

Created by

Created by: Archit Jain || architjn

Archit Jain

Last update

Last update a month ago

Share


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.