{"product_id":"n8n-workflow-sync-google-sheets-applicants-to-notion-gmail","title":"n8n Workflow: Sync Google Sheets Applicants to Notion + Gmail","description":"\u003ch3\u003eAutomatically sync Google Sheets job applicants into Notion—and email them from Gmail when their status changes\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow keeps your hiring pipeline in sync by importing new applicants from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e into a \u003cstrong\u003eNotion\u003c\/strong\u003e “Candidates Tracker” database on a schedule, then sending \u003cstrong\u003estage-based emails via Gmail\u003c\/strong\u003e using templates stored in a separate Notion database.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every hour (or manually)\u003c\/strong\u003e to read new, unprocessed applicant rows from your Google Sheets form responses sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates\u003c\/strong\u003e by looking up each applicant by email in Notion and filtering out candidates that already exist in the “Candidates Tracker” database.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Notion candidate page\u003c\/strong\u003e for each new applicant, then \u003cstrong\u003emarks the Google Sheets row as processed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects status changes\u003c\/strong\u003e by triggering when a page in the Notion “Candidates Tracker” database is updated.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses an n8n Data Table snapshot\u003c\/strong\u003e to store a prior candidate state, compares it, and continues \u003cem\u003eonly when the candidate’s \u003cstrong\u003eStatus\u003c\/strong\u003e changes\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an email based on the new status\u003c\/strong\u003e by fetching the matching template from Notion “Email Templates,” filling placeholders with candidate fields, and sending via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn a Google Forms (or Sheets-based) application flow into an always-updated Notion hiring database.\u003c\/li\u003e\n  \u003cli\u003eSend automatic rejection\/interview\/offer emails when recruiters update a candidate’s Notion \u003cstrong\u003eStatus\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eReduce manual work for SaaS operators managing high-volume applicant intake.\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 Notion, Google Sheets, Gmail (OAuth2)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003cem\u003eif, code, gmail, notion, switch, data table\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey data requirements:\u003c\/strong\u003e Notion Candidates Tracker must include \u003cstrong\u003eEmail\u003c\/strong\u003e and \u003cstrong\u003eStatus\u003c\/strong\u003e properties; provide database IDs for both Candidates Tracker and Email Templates.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223921414323,"sku":"N8N-20943","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CXVXidlFaL4jygq_j55Dx_cKArpbyZ.png?v=1791968485","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-sync-google-sheets-applicants-to-notion-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}