Configuring Whatsapp Crm and Google Sheets

This post was flagged by the community and is temporarily hidden.

Hey @Marketing!

Have you been able to create a resource to connect to your Google Sheets? https://docs.retool.com/docs/google-sheets-integration

And for WhatsApp, the template just opens a custom URL based on info from the Google Sheet.

I included the app's JSON if you're interested in checking it out :slight_smile: You can import this JSON file by clicking Create new (home page) > From JSON!


Whatsapp-20CRM.json

Hello,

https://retool.com/templates/whatsapp-crm

Please refer to this Template.

When I click the Send WhatsApp button, it opens a page where I can send a message to a single contact.

How do I send it to multiple people at once?

With Regards,

Marketing Team

Using the open URL method in the template, you can only send a message to one person at once!

However, you can probably create a loop to trigger a single send query (using WhatsApp's REST API) for multiple numbers. Something like:

This loop uses Retool queries' trigger method with additionalScope passed in:

https://community.retool.com/t/how-to-use-additionalscope-in-your-queries/13343

And here's a post that walks through a query loop that also logs all the results together:

https://community.retool.com/t/how-to-run-a-rest-api-query-for-each-item-in-an-array-and-return-all-results-together/2352

Let me know if that's helpful at all! :slight_smile: