I want to send WhatsApp messages to my contacts using my Google Sheets. My question is what should my scenario look like, I tried sheets with “Search Rows” but it says it has to be connected with another module.
Welcome to the Make community!
You can’t. For WhatsApp Business, you can only message people that have messaged your business within the past 30 days.
Hope this helps! Let me know if there are any further issues!
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
Can’t we use something like an iterator to iterate over a specific column and shoot messages? We can you for a particular number isn’t there a way to send the templated message to all?
According to “Select receivers” from the WhatsApp documentation:
In addition to your contacts and broadcast lists, you can send your message to contacts who have recently messaged you, or contacts that you haven’t chatted with in 30 days.
Ok it does say contacts here, so you probably just need to get the list of contacts from wherever you are storing the numbers, then connect it with “Send a Message” or “Send a Template Message” modules.
If the list of contacts are in an array, then use an iterator to split them into separate bundles.
Hope this helps! Let me know if there are any further issues!
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
I have this scenario where Google Sheets says “Prior to configuring the module, you need to connect it to the scenario flow.” Where should I connect the Google sheets, I have my data in the sheets only.
Oh, that’s a completely different issue then!
You need to drag the trigger click icon to your start module!
Currently it is on another module, and not on your Google Sheets module.
Hope this helps! Let me know if there are any further questions or issues.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
1 Like
Samliew! Is it possible to do the same thing on mod versions of whatsapp, not official, like gb whatsapp and an whatsapp?
You could use App Script, which is the native programming language for Google Sheets, to iterate through each row and do the sending.
Similarly, you can craft something similar with a Make iterator, although it would be much less flexible.
Another alternative is using a plugin like this: Use 2Chat for Google Sheets in your WhatsApp marketing campaigns