WhatsApp enquiries to Google Sheets with n8n, step by step
Stop copying customer messages by hand. A six-step n8n build that logs each WhatsApp enquiry to a sheet and alerts you.
What the page covers
- What you need before you start
- Receiving the message and cleaning the fields
- The sheet columns to keep and how to avoid duplicates
- An error workflow, and a privacy note
Frequently asked questions
- Can I do this with the normal WhatsApp Business app?
- Not directly. The free WhatsApp Business app does not send incoming messages to other tools. For automation you need the WhatsApp Business Platform (the Cloud API) from Meta, usually through a verified business account. Check Meta's current rules before moving a number you already use in the app, because a number is normally tied to one or the other.
- Is this free?
- The pieces are cheap but not all free. Google Sheets is free, and n8n can be self-hosted at the cost of a small server, or used as a paid cloud service. Meta charges for some WhatsApp conversations and messages, and its pricing changes, so read the current pricing page for your country before you commit.
- Do I need to know how to code?
- Not for the basic flow in this guide: a trigger, a few field mappings and a spreadsheet. You do need to be comfortable with Meta's developer dashboard and a spreadsheet. If you would rather not set it up yourself, I build and maintain these as part of my automation plans.
Akshay Mahajan — full-stack & AI web developer, Surat, Gujarat, India. akshaymad0608@gmail.com · +91 76008 85080