{"product_id":"n8n-workflow-openai-interview-study-guides-google-sheets-gmail","title":"n8n Workflow: OpenAI Interview Study Guides → Google Sheets + Gmail","description":"\u003ch3\u003eTurn interview questions into structured OpenAI study guides—automatically added to Google Sheets and emailed via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives input\u003c\/b\u003e from an authenticated n8n form submission: interview question, target role, and an optional draft answer.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLoads configured settings\u003c\/b\u003e (Google Sheets spreadsheet + worksheet, recipient email, and the selected OpenAI model) and validates required fields and input length.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates a structured study guide\u003c\/b\u003e by calling the OpenAI Chat Completions API and requesting a \u003cb\u003eJSON-only\u003c\/b\u003e response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eParses and validates the OpenAI JSON output\u003c\/b\u003e, then prepares a Google Sheets row including a \u003cb\u003ereview date three days later\u003c\/b\u003e and email-ready text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends the record\u003c\/b\u003e to your specified Google Sheets worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends an email\u003c\/b\u003e to the configured recipient with the study guide summary using Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eUse interview study guides for technical hiring by turning each question into a repeatable review format.\u003c\/li\u003e\n  \u003cli\u003eSupport coaching: collect a candidate’s draft answer, generate reference guidance, and email feedback summaries.\u003c\/li\u003e\n  \u003cli\u003eRun an internal SaaS\/operator workflow to keep a central Google Sheets library of question\/topic\/difficulty and key concepts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations \/ nodes:\u003c\/b\u003e form trigger, set, code, http request, gmail, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI:\u003c\/b\u003e OpenAI Chat Completions API with a JSON-only response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGoogle Sheets setup:\u003c\/b\u003e configure OAuth credentials, set spreadsheet ID + worksheet name, and create the first row with exact headers: \u003ci\u003ecreated_at, question, target_role, draft_answer, topic, difficulty, reference_answer, key_concepts, common_mistakes\u003c\/i\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSecurity:\u003c\/b\u003e configure the n8n form’s Basic Auth so only trusted users submit questions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIdeal 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072075911347,"sku":"N8N-19806","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/p7cDywUQYUffDrpaNHFTP_frlPBdm2.png?v=1790067860","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-openai-interview-study-guides-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}