WhatsApp Orders to Google Sheet, Zero Typing (n8n + ChatGPT)
Every WhatsApp order lands in a Google Sheet. ChatGPT cleans the text. The customer gets a confirmation. You type nothing.
What you will build:
An Orders sheet
WhatsApp Business Cloud trigger in n8n
ChatGPT JSON extract (with a skip flag)
Append row + auto reply
Sheet headers (copy exactly):
Time, From, Customer, Item, Qty, Notes, Status
Tools:
WhatsApp Business Cloud
n8n
ChatGPT / OpenAI
Google Sheets
Chapters:
0:00 The 40-order problem
0:15 The result
0:26 What you will build
0:45 Orders sheet
1:03 WhatsApp Cloud credentials
1:32 On messages + text only
1:54 ChatGPT extracts the order
2:23 Append the row
2:53 Auto confirmation
3:13 The reply loop
3:32 Next system
Subscribe for 2 systems a week.
Next: salon no-show reminders on autopilot.
OwnerOps - get 6 hours back every week.
#n8n #whatsappstatus #chatgpt #automation #smallbusiness