n8n Workflow: OpenAI Interview Study Guides → Google Sheets + Gmail

Turn interview questions into structured OpenAI study guides—automatically added to Google Sheets and emailed via Gmail

This n8n workflow captures your interview prompts through an n8n form, uses the OpenAI Chat Completions API to generate a JSON-only study guide plus draft feedback, then appends the results to Google Sheets and emails a plain-text summary using Gmail.

What this workflow does

• Receives input from an authenticated n8n form submission: interview question, target role, and an optional draft answer.
• Loads configured settings (Google Sheets spreadsheet + worksheet, recipient email, and the selected OpenAI model) and validates required fields and input length.
• Generates a structured study guide by calling the OpenAI Chat Completions API and requesting a JSON-only response.
• Parses and validates the OpenAI JSON output, then prepares a Google Sheets row including a review date three days later and email-ready text.
• Appends the record to your specified Google Sheets worksheet.
• Sends an email to the configured recipient with the study guide summary using Gmail.

Use cases

• Use interview study guides for technical hiring by turning each question into a repeatable review format.
• Support coaching: collect a candidate’s draft answer, generate reference guidance, and email feedback summaries.
• Run an internal SaaS/operator workflow to keep a central Google Sheets library of question/topic/difficulty and key concepts.

Technical details

• Integrations / nodes: form trigger, set, code, http request, gmail, sticky note.
• OpenAI: OpenAI Chat Completions API with a JSON-only response.
• Google Sheets setup: configure OAuth credentials, set spreadsheet ID + worksheet name, and create the first row with exact headers: created_at, question, target_role, draft_answer, topic, difficulty, reference_answer, key_concepts, common_mistakes.
• Security: configure the n8n form’s Basic Auth so only trusted users submit questions.

Ideal for n8n users, automation engineers, and SaaS operators who want a practical interview study automation workflow—OpenAI → Google Sheets → Gmail—fully documented and ready to deploy.