{"product_id":"n8n-workflow-google-sheets-accepted-jobs-calendar-events-gmail-reminders","title":"n8n Workflow: Google Sheets Accepted Jobs → Calendar Events + Gmail Reminders","description":"\u003ch3\u003eTurn accepted Google Sheets quotes into scheduled Google Calendar jobs—automatically (with Gmail reminders)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow detects \u003cstrong\u003eaccepted\u003c\/strong\u003e jobs in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, emails customers a personalized booking form link via \u003cstrong\u003eGmail\u003c\/strong\u003e, checks \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e availability, schedules the event, and sends confirmation plus next-day reminders. No manual back-and-forth—just smooth booking from quote to calendar.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEvery 15 minutes\u003c\/strong\u003e, it scans Google Sheets for rows where \u003cstrong\u003estatus = accepted\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each accepted row, it builds a \u003cstrong\u003epersonalized booking form link\u003c\/strong\u003e, emails the customer the link using \u003cstrong\u003eGmail\u003c\/strong\u003e, and updates the row status to \u003cstrong\u003ebooking_sent\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWhen the customer opens the booking form, the workflow verifies the request by checking that the \u003cstrong\u003elink and email address match a row\u003c\/strong\u003e currently in \u003cstrong\u003ebooking_sent\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIt reads \u003cstrong\u003ebusy events from Google Calendar\u003c\/strong\u003e for your configured booking window, then calculates available time slots using your \u003cstrong\u003eworking days\u003c\/strong\u003e, \u003cstrong\u003ebusiness hours\u003c\/strong\u003e, \u003cstrong\u003ejob length\u003c\/strong\u003e, and \u003cstrong\u003eminimum notice\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf no slots are available, it emails the \u003cstrong\u003eowner\u003c\/strong\u003e via Gmail and shows a “\u003cstrong\u003eNo free times\u003c\/strong\u003e” completion page to the customer.\u003c\/li\u003e\n  \u003cli\u003eIf slots are available, it shows a second form for time selection, then re-checks Google Calendar and re-reads the Google Sheets row to ensure the slot is still free and not already scheduled.\u003c\/li\u003e\n  \u003cli\u003eWhen a slot is confirmed free, it creates the \u003cstrong\u003ejob event in Google Calendar\u003c\/strong\u003e, updates the sheet to \u003cstrong\u003escheduled\u003c\/strong\u003e (including \u003cstrong\u003eevent ID\u003c\/strong\u003e and \u003cstrong\u003estart time\u003c\/strong\u003e), sends a confirmation email via Gmail, and shows a booking confirmation page.\u003c\/li\u003e\n  \u003cli\u003eEvery morning at \u003cstrong\u003e8:00\u003c\/strong\u003e, it processes \u003cstrong\u003escheduled\u003c\/strong\u003e jobs from Google Sheets (for confirmations\/reminders).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eService businesses that receive quotes in Google Sheets and want customers to instantly pick an available time.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators automating booking flows with Google Calendar availability and status tracking in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003en8n users who need reliable scheduling logic that prevents double-booking by re-checking both Calendar and Sheets before creating events.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuilt with n8n nodes including: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eform\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (status transitions: accepted → booking_sent → scheduled), Google Calendar (busy events + event creation), Gmail (booking link email, confirmations, and owner notifications).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232444764339,"sku":"N8N-21026","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/iwgo_P7rttCpXfzdWMyj_jw7tu48B.png?v=1792142590","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-accepted-jobs-calendar-events-gmail-reminders","provider":"N8N Commerce","version":"1.0","type":"link"}