{"product_id":"whatsapp-twilio-appointment-confirmations-with-google-sheets","title":"WhatsApp (Twilio) Appointment Confirmations with Google Sheets","description":"\u003ch3\u003eSend WhatsApp appointment reminders and automatically handle replies in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow uses \u003cstrong\u003eTwilio WhatsApp\u003c\/strong\u003e and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to send daily appointment confirmation reminders for tomorrow’s bookings—and then processes inbound WhatsApp replies to confirm or cancel appointments, updating status directly in your spreadsheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 9:00 AM\u003c\/strong\u003e via an n8n schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your Google Sheet\u003c\/strong\u003e (the \u003cem\u003e“Citas”\u003c\/em\u003e sheet) and selects only appointments scheduled for \u003cstrong\u003etomorrow\u003c\/strong\u003e that are \u003cstrong\u003enot\u003c\/strong\u003e marked as \u003cstrong\u003e“Cancelada”\u003c\/strong\u003e and have an empty \u003cstrong\u003e“RecordatorioEnviado”\u003c\/strong\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a WhatsApp reminder\u003c\/strong\u003e to each customer using the \u003cstrong\u003eTwilio Messages API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTracks delivery results\u003c\/strong\u003e: if Twilio returns success, it updates the matching row to set \u003cstrong\u003e“RecordatorioEnviado”\u003c\/strong\u003e. If not, it appends the error details to an \u003cem\u003e“Errores”\u003c\/em\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inbound WhatsApp replies\u003c\/strong\u003e via a \u003cstrong\u003eTwilio webhook\u003c\/strong\u003e and normalizes sender phone number and message text.\u003c\/li\u003e\n  \u003cli\u003eIf the reply matches a \u003cstrong\u003econfirmation or cancellation keyword\u003c\/strong\u003e, the workflow updates the appointment \u003cstrong\u003e“Estado”\u003c\/strong\u003e in Google Sheets and replies to the customer via Twilio. For \u003cstrong\u003ecancellations\u003c\/strong\u003e, it also sends a WhatsApp alert to the business number.\u003c\/li\u003e\n  \u003cli\u003eIf the reply is not recognized, it asks the customer to respond with \u003cstrong\u003eSI\u003c\/strong\u003e or \u003cstrong\u003eNO\u003c\/strong\u003e, and returns \u003cstrong\u003e“OK”\u003c\/strong\u003e to the webhook request.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily automated \u003cstrong\u003eWhatsApp appointment confirmations\u003c\/strong\u003e without manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eAutomated \u003cstrong\u003estatus updates\u003c\/strong\u003e in Google Sheets when customers reply “confirm” or “cancel”.\u003c\/li\u003e\n  \u003cli\u003eOperational visibility via an \u003cstrong\u003e“Errores”\u003c\/strong\u003e log when Twilio message sending fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth credential, Spreadsheet ID configuration, uses the \u003cem\u003e“Citas”\u003c\/em\u003e sheet columns (Nombre, Telefono, Fecha (YYYY-MM-DD), Hora, Estado, RecordatorioEnviad*), and writes errors to \u003cem\u003e“Errores”\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwilio WhatsApp\u003c\/strong\u003e: outbound reminders through Twilio Messages API; inbound replies handled by a \u003cstrong\u003ewebhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow nodes\u003c\/strong\u003e: schedule, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003e*Note:\u003c\/em\u003e the setup description references the column name \u003cstrong\u003e“RecordatorioEnviad”\u003c\/strong\u003e; ensure your sheet columns match your configuration.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46008713478323,"sku":"N8N-19510","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ru4sdcQTrU5chTIV2GvM7_yemaMyFF.png?v=1789203859","url":"https:\/\/buyflowscripts.com\/products\/whatsapp-twilio-appointment-confirmations-with-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}