Extract TV ad slots from Gmail attachments to Google Sheets using GPT-4o Vision

Automatically extract TV advertising slot information from emails using AI-powered document analysis. This workflow processes emails from Japanese TV stations, classifies them by type, and extracts structured data from various attachment formats.

Who is this for

Media buyers, advertising agencies, and TV commercial coordinators who receive ad slot proposals from multiple TV stations via email and need to consolidate the information into a structured database.

What this workflow does

1. Monitors Gmail every 30 minutes for emails from 66 Japanese TV station domains
2. Classifies emails into three types: New slots (新規), Cancellations (休止), Time changes (時間移動)
3. Processes attachments intelligently based on file type and email classification
4. Extracts structured data: broadcast date, time slot, station name, program, price
5. Saves to Google Sheets with full metadata and email type classification
6. Labels processed emails in Gmail for tracking

Setup requirements

• Gmail OAuth2 credentials
• OpenAI API key (GPT-4 Vision)
• Google Sheets OAuth2 credentials
• AWS S3 bucket for temporary image storage
• ConvertAPI account for PPTX/PDF conversion

How to customize

Edit the domain list and classification keywords in the code nodes to adapt for your specific use case.