LIGHTSPEED RETAIL TO GOOGLE SHEETS
Lightspeed Retail to Google Sheets, then WhatsApp.
How to add a Google Sheets row for each new Lightspeed Retail record, so ConvoHut can start a WhatsApp journey from it. This takes Zapier, Make or a webhook.
7-day free trial · about 15 minutes to connect your number · Meta bills message charges to you directly (you add a card in Meta)
Illustrative example. Names and details are made up.
STORES & PAYMENTS
The options.
Trigger, then Google Sheets “Create Spreadsheet Row”
Triggers you can use:
- New sale (Lightspeed X-Series example in Lightspeed’s help)
Make, webhooks and more
- Lightspeed API
- Check which Lightspeed product you use. The Zapier example is for X-Series.
THE SHEET
The columns to send.
Send one row per record, with the column names in row 1. Phone is the only required column and must include the country code.
- Name
- Phone
- Store
- Item
- Consent: that the person agreed to WhatsApp messages
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Phone | Store | Item |
| 2 | Sarah | +61 412 000 184 | Brunswick | Linen throw |
| 3 | Tom | +61 433 000 912 | Richmond | Coffee grinder |
| 4 | Ana | +64 21 000 457 | Online | Walking shoes |
Row 1 holds the column names. The highlighted row is the newest: adding it starts the journey. Example data only.
BUILD
Then, in ConvoHut.
- 01
Open Automations, then Create Automation, and choose New Sheet Row as the trigger.
- 02
Pick the spreadsheet and tab, and map Phone and Name.
- 03
Add your approved template, a wait for reply, and a notify step.
- 04
Pass the compliance review for your markets, then Activate Now. Test with your own number first.
RECIPES
Recipes that work with Lightspeed Retail.
Checked against Lightspeed Retail’s, Zapier’s and Google’s documentation in September 2026. Features, plan requirements and trigger names change; check the current documentation when you set it up. ConvoHut isn’t affiliated with Lightspeed Retail.
LIVE NOW · 7-DAY FREE TRIAL
More sales from every conversation.
WhatsApp marketing, sales and support from your own number. 7-day free trial, free onboarding and Meta verification help.
- Meta Tech Provider
- Hosted on AWS
- Australian company
- Your number stays yours
