{"product_id":"whatsapp-event-quotes-with-groq-google-calendar-sheets-n8n","title":"WhatsApp Event Quotes with Groq + Google Calendar + Sheets (n8n)","description":"\u003ch3\u003eInstant WhatsApp event quotes—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns incoming WhatsApp event questions into a structured quote: it extracts your event details with \u003cstrong\u003eGroq\u003c\/strong\u003e, checks \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e availability, pulls pricing from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and replies to the customer with either a confirmed quote or a date-conflict message—while logging results in \u003cstrong\u003eSupabase\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on new WhatsApp messages\u003c\/strong\u003e received via the WhatsApp Business Cloud API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Groq to extract key details\u003c\/strong\u003e (event date, event type, and guest count) from the WhatsApp text in a structured format.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks Google Calendar\u003c\/strong\u003e for any events on the requested date and aggregates matches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your pricing logic from Google Sheets\u003c\/strong\u003e by pulling rows from a \u003cstrong\u003e“Pricing”\u003c\/strong\u003e tab (columns: \u003cem\u003eevent_type\u003c\/em\u003e, \u003cem\u003emax_guests\u003c\/em\u003e, \u003cem\u003eprice\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects the correct tier\u003c\/strong\u003e by matching event type and the guest limit, then calculates the deposit amount.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the WhatsApp response\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eIf the date is free: sends a WhatsApp quote.\u003c\/li\u003e\n      \u003cli\u003eIf the date is already booked: sends a WhatsApp message requesting an alternate date.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs the outcome to Supabase\u003c\/strong\u003e (quoted vs. date conflict) for tracking and reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eA customer texts an event date and guest count—your workflow immediately returns pricing and a deposit.\u003c\/li\u003e\n  \u003cli\u003eA requested date is unavailable—your workflow automatically asks for an alternate date.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing multiple inquiry types can keep pricing updates centralized in Google Sheets without redeploying.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp\u003c\/strong\u003e: WhatsApp Business Cloud API trigger + send message actions (requires phone number ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI extraction\u003c\/strong\u003e: \u003cstrong\u003eGroq\u003c\/strong\u003e credential for extracting event date\/type\/guest count.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalendar checks\u003c\/strong\u003e: \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e OAuth + target calendar ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePricing\u003c\/strong\u003e: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth reading from the \u003cstrong\u003ePricing\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e to combine calendar + pricing decisions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogging\u003c\/strong\u003e: \u003cstrong\u003eSupabase\u003c\/strong\u003e to insert the inquiry outcome.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45732234166451,"sku":"N8N-17500","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XFkqaj7E6er8lepnpiyeh_LhMe9RBN.png?v=1785143155","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-event-quotes-with-groq-google-calendar-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}