{"product_id":"n8n-job-offer-workflow-google-sheets-gmail-forms","title":"n8n Job Offer Workflow: Google Sheets + Gmail Forms","description":"\u003ch3\u003eStreamline job offer management with n8n—Google Sheets lookup, Gmail email delivery, and candidate responses in forms\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Job Offer Workflow\u003c\/strong\u003e collects proposed job offer details via an n8n form, finds the candidate in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, sends the offer letter through \u003cstrong\u003eGmail\u003c\/strong\u003e, and then captures the candidate’s \u003cstrong\u003eacceptance or rejection\u003c\/strong\u003e to update statuses back in Sheets and notify HR.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives an offer request\u003c\/strong\u003e through an n8n form containing \u003cem\u003eCandidate ID\u003c\/em\u003e and the proposed offer details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLooks up the candidate\u003c\/strong\u003e in Google Sheets by \u003cem\u003eCandidate ID\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf the candidate is \u003cstrong\u003enot found\u003c\/strong\u003e, it \u003cstrong\u003eemails HR via Gmail\u003c\/strong\u003e so the team can investigate.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks the offer as pending\u003c\/strong\u003e in the candidate’s Google Sheets row and combines the candidate record with the submitted offer details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the offer email to the candidate\u003c\/strong\u003e using Gmail, including a link to a second \u003cstrong\u003en8n form\u003c\/strong\u003e for submitting their response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords that the offer was sent\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives the candidate’s response\u003c\/strong\u003e via the second n8n form, then updates Google Sheets:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eAccepted\u003c\/strong\u003e → moves the candidate to \u003cstrong\u003eOnboarding\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eRejected\u003c\/strong\u003e → moves the candidate to \u003cstrong\u003eClosed\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies HR via Gmail\u003c\/strong\u003e with the outcome.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRecruiting teams that need a consistent process for sending offers and tracking outcomes without manual spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to connect a hiring pipeline (forms + Sheets + email) to HR notifications.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing job offer workflows across multiple roles while keeping status updates centralized.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes mentioned:\u003c\/strong\u003e \u003cem\u003eform trigger, if, set, switch, sticky note\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup required:\u003c\/strong\u003e configure Google Sheets credentials and replace \u003ccode\u003eYOUR_GOOGLE_SHEET_ID\u003c\/code\u003e; ensure the \u003cstrong\u003eCandidates\u003c\/strong\u003e sheet includes columns like \u003cem\u003eCandidate ID\u003c\/em\u003e, \u003cem\u003eOffer Status\u003c\/em\u003e, \u003cem\u003eOffer Response\u003c\/em\u003e, \u003cem\u003eCandidate Remarks\u003c\/em\u003e, \u003cem\u003eWorkflow Phase\u003c\/em\u003e, and \u003cem\u003eApplication Status\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHR notification:\u003c\/strong\u003e update the HR recipient address (e.g., \u003ccode\u003eyour-hr-email@example.com\u003c\/code\u003e) for Gmail alerts\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45872819896499,"sku":"N8N-18479","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/zq1O6CEGIzw-OlLJFCH5E_s0HbAyiY.png?v=1787216915","url":"https:\/\/buyflowscripts.com\/products\/n8n-job-offer-workflow-google-sheets-gmail-forms","provider":"N8N Commerce","version":"1.0","type":"link"}