Extract meeting details with GPT-4.1-mini and evaluate accuracy in Google Sheets

Who's it for

Developers building AI-powered workflows who want to ensure their agents work reliably. If you need to validate AI outputs, test agent behavior systematically, or build maintainable automation, this template shows you how.

What it does

This subworkflow extracts structured meeting details (title, date, time, location, links, attendees) from natural language messages using an AI agent. It demonstrates production-ready patterns:

- Structured output validation: JSON schema enforcement prevents malformed responses - Error handling: Graceful failures with full execution traceability - Automated evaluation: Test agent accuracy against expected outputs using Google Sheets - Dual execution modes: Normal extraction + evaluation/testing mode

The AI resolves relative time ("tomorrow", "next Friday") using timezone context and handles incomplete data gracefully.

How to set it up

1. Connect OpenAI API credential to the AI agent node 2. Copy the test data sheet: https://docs.google.com/spreadsheets/d/1U89nPsasM2WNv1D7gEYINhDwylyxYw7BOdi8ipFC0M/edit?usp=sharing 3. Update Google Sheet IDs in loadevaldata and recordevaloutput nodes 4. Test normal mode: Execute workflow "from trigger" 5. Test evaluation mode: Execute workflow "from loadevaldata"