One sheet with product column and i want to send it on whats app when i press button what there in that column send immediately

one sheet with product column and i want to send it on whats app when i press button what there in that column send immediately

0 15 3,144
15 REPLIES 15

LeventK
Participant V

@Shrikant_Nikam
Add a helper column to your sheet and name it like TIMESTAMP. Add an action button to this table with Data: change the value of a column and set the value as NOW. Construct a Webhook Workflow Rule with UPDATES_ONLY for this table and set the condition as:

AND(ISNOTBLANK([TIMESTAMP]),[_THISROW_BEFORE].[TIMESTAMP]<>[_THISROW_AFTER].[TIMESTAMP])

For the Endpoint URL of this workflow, use below endpoint:

<<CONCATENATE("https://api.whatsapp.com/send?phone=",[PHONE_NUMBER],"&text=",ENCODEURL([ProductColumnName]))>>

Your [PHONE_NUMBER] field should only contain the country code and the phone number. Using + sign or spaces are not allowed. Provided you have; you can enclose the [PHONE_NUMBER] with a SUBSTITUTE expression:

SUBSTITUTE(TRIM([PHONE_NUMBER]),"+","")

<<CONCATENATE(โ€œhttps://api.whatsapp.com/send?phone=",[918888017270],"&text=โ€,ENCODEURL([product]))>> this expression should paste in url column right? but it shows error

after creating PHONE_NUMBER column it not work, but i check with send email action button works

if you have a static phone number than you can hard-code it. I thought that you will read the phone numbers from your table. Consider this one instead:

<<CONCATENATE(โ€œhttps://api.whatsapp.com/send?phone=918888017270&text=โ€,ENCODEURL([product]))>>

Hi Levent,

SUBSTITUTE(TRIM([PHONE_NUMBER]),"+","")

I should put this function under in which area? Thank you

sir , this webhook is not working are you tested on any app with whats app webhook? ,now no error in my app and i made all changes what you explained but i tested with individual workflow no action is performed โ€ฆ plz help โ€ฆ

sir , forgot webhook i made simple action button and โ€œDo thisโ€ selected โ€œExternal: go to websiteโ€ and in "target url " i added the link expression "CONCATENATE(โ€œhttps://api.whatsapp.com/send?phone=918888017270&text=โ€,ENCODEURL([product])) " when i press button it automatically open whats app and respective product column so i need to appear whole product coloumn and with unit coloumn like receipt how expression should be?

@Shrikant_Nikam
I thought that you have a WhatsApp API business subscription, therefore proposed webhook method. Provided you will use the public REST API service, action button will do the trick as you have already discovered out. So whereโ€™s the problem? I havenโ€™t understood whatโ€™s your problem is actually.

In my sheet two columns named โ€œproductโ€ and โ€œunitโ€ i made expression "CONCATENATE(โ€œhttps://api.whatsapp.com/send?phone=918888017270&text=โ€,ENCODEURL([product])) " when i press button it only show respective product name ex.Milk so I want text format like attached picture

so what changes should be in expression?

You canโ€™t create a content like that, sorry

i want to send one full tab of sheet

how to send email for same as whats app with attachment

@Shrikant_Nikam
You need to set a WhatsApp business subscription first. And then you can send attachments via setting a webhook workflow to their REST API endpoint.

i used twilio webhook and problem is solved, now i can send real time pdf attachment and when button is press

โ€œSince the app is not deployed, workflow rules will deliver email only to the app ownerโ€

Does it work for you SEND MESSAGES via WHATSAPP? Or you need to do the deploy the app too?

Top Labels in this Space