Sending whatsapp message to Google Sheet

[Andrei_Sc]

Describe the problem/error/question

Hi guys.

Let’s say i have a Google sheet with 1k contacts and a column with there phone. I want to send a whatsapp message to each of them but with a 20s delay between each message. I’ve already configured Whapi(api used for sending), but I’m having trouble creating the full flow.

If anyone can point me in a direction I will greatly appreciate it.

Thanks.

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version: latest
• Database (default: SQLite): default
• n8n EXECUTIONS_PROCESS setting (default: own, main): none
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Ubuntu

[devn]

It should be possible to use Wait node for this. Can you please update the question and share your workflow? I can check how you can modify it to add this node.

[Andrei_Sc]

Hi. Thanks for your answer.

I will share it in the morning as i am in bed at the moment. But so far i got:

1. Read Google Sheets
2. Send message via Whapi Module
3. Check message status via Webhook
4. Update Google Sheets status column

I haven’t tested with more then 1 row, but i assume it will try and send them with no delay. I am rather new to this type of automation so idk all available modules. I understand i can put a wait=20s after Step 4, but how do i make it go to the next row after that?

Thanks!

[devn]

Sounds like you will want the use the Loop Over Items node.

The following node arrangement example should work after filling proper values.