WhatsApp Catalogue Automation: Update Products From a Spreadsheet
WhatsApp catalogue automation sounds like a big project. It isn't. If your products live in a spreadsheet already, and for most small sellers they do, you can stop editing the catalogue by hand and let the sheet drive it.
Pick one source of truth
The mistake I see most is two places holding the truth. Prices in the sheet, different prices in the catalogue, and a customer quoting the wrong one on chat. Choose the spreadsheet. The catalogue becomes a read only mirror. If someone edits it directly, that edit gets overwritten on the next sync, and everyone should know that upfront.
The shape of the sheet
Keep it boring. One row per product, with these columns:
- ID: a stable code that never changes, even if the name does
- Title and description: plain text, no formatting tricks
- Price and currency: one format, every row
- Availability: in stock or out of stock
- Image link: a public URL to the product photo
The stable ID matters most. It is how the automation knows whether a row is a new product or an update to an existing one.
Two ways to wire it
The simple route is a scheduled feed. Your catalogue lives in Meta's Commerce Manager, and it can pull from a spreadsheet or file link on a schedule. No code. For many shops this is enough.
The more flexible route is a small script or workflow that reads the sheet, compares it to what is live, and pushes only the changes through Meta's catalogue API. This is the version I prefer once you have more than a handful of products, because you control when it runs and what happens when something looks wrong.
What running our own automations taught me
At Esipick we run agents and automations internally, and the lesson repeats every time: the sync is easy, the safety is the work. An automation that writes to something customers see needs a gate. For catalogue updates that means a diff before anything goes live. If a price column suddenly shows zero for half the rows, I want the run to stop and tell me, not publish it politely.
I also keep a log of what changed and when. When a customer says the price was different yesterday, you can answer in seconds instead of guessing. Honestly, that log has saved us more time than the automation itself.
Where to start
- Clean the sheet first and give every product a stable ID
- Run a manual sync on five products and check them on a real phone
- Add the diff check and the stop condition
- Only then put it on a schedule
Good WhatsApp catalogue automation should feel invisible. Nobody on your team thinks about the catalogue, because updating the sheet is the whole job. I think that is where small business tooling is heading: fewer dashboards to maintain, and one plain file that everything else quietly follows.


