I want to send Message to everyone in my google sheet.

[Oliver]

Hi,

Please can you guide me to how i can extract each and every telephone number out of google sheet and send a WhatsApp message with zoom link for meeting to EACH of the people in google sheet.... Some kind of an array... Not sure

Also.... I will have to delay between each one in order not to get spam blocked. But I'm sure a simple delay can sort that.

Kindly Advise, Sorry if its been asked before?

 

[Fagun Shah]

Hi,

Please can you guide me to how i can extract each and every telephone number out of google sheet and send a WhatsApp message with zoom link for meeting to EACH of the people in google sheet.... Some kind of an array... Not sure

Also.... I will have to delay between each one in order not to get spam blocked. But I'm sure a simple delay can sort that.

Kindly Advise, Sorry if its been asked before?

Are all the numbers in a single column?

 

[Oliver]

Are all the numbers in a single column?

Yes they are.

 

[Fagun Shah]

Yes they are.

View attachment 1692

I think I have created something similar before, there will be total of 2 workflow to achieve this.

In first workflow you get all the numbers/rows using Get Rows action of google sheet. Then use iterator to separate each row and go through them one-by-one. Then use counter and API to send data to 2nd workflow using API module of pabbly.

Basically we are sending webhook to pabbly's another workflow.

Then in next workflow capture that data and pass counter value in Delay module and then use your whatapp message app's action. It will send 1 message per minute. Less than 1 minute delay is not possible.

Attaching PDFs of both the Workflows, and if you get stuck PM me on FB - https://www.facebook.com/fagun.shah.7/

 

[Oliver]

I think I have created something similar before, there will be total of 2 workflow to achieve this.

In first workflow you get all the numbers/rows using Get Rows action of google sheet. Then use iterator to separate each row and go through them one-by-one. Then use counter and API to send data to 2nd workflow using API module of pabbly.

Basically we are sending webhook to pabbly's another workflow.

Then in next workflow capture that data and pass counter value in Delay module and then use your whatapp message app's action. It will send 1 message per minute. Less than 1 minute delay is not possible.

Attaching PDFs of both the Workflows, and if you get stuck PM me on FB - https://www.facebook.com/fagun.shah.7/

Thank You