How to send whatsapp message through Pabbly whenever any data is updated in a Google sheet?

[mukesh_gil]

Hello,

I need such functionality that whenever any data is updated in a Google sheet, I should get a whatsapp message through pabbly or any other method (If not possible through pabbly).

How to get this solution?

I am able to send whatsapp messages through pabbly for custom data or adding new row.

 

[Pabblymember11]

Hey @mukesh_gil

How to get this solution?

You can refer to the following video tutorial on how you can send a WhatsApp message when a row gets updated.

 

[mukesh_gil]

Hello @Supreme ,
Thanks for the link but it sends messages only when a particular column is updated.
We need that,
1.) If any cell of any column in the sheet is updated then a whatsapp message should be sent.
2.) The whatsapp message should be sent of that particular cell like "the value of cell B3 has been updated".

How is this possible? Also how to generate permanent access token?

 

[Pabblymember11]

Hey @mukesh_gil

Thanks for the link but it sends messages only when a particular column is updated.
We need that,

The Update Row in Google Sheets trigger event only works when you make the changes in the trigger column manually.

 

[mukesh_gil]

Hey @mukesh_gil


The Update Row in Google Sheets trigger event only works when you make the changes in the trigger column manually.

It generates temporary access token for 24 hrs then it will stop messaging. How to generate permanent access token?

 

[Pabblymember11]

It generates temporary access token for 24 hrs then it will stop messaging. How to generate permanent access token?

If you are using the WhatsApp Cloud API action step then its token doesn't get expire in 24 hrs.

If that is happening with you, we would recommend you contact the Cloud API support team.

 

[mukesh_gil]

How can we send a whatsapp message when any cell of any column in the sheet is updated?
The method you described was just for a change in a single column.

 

[PabblyMember4]

Hey @mukesh_gil

You need to make changes in the trigger column only. If you are making changes in any column and want to send a Whatsapp message then the scenario is not possible. You need to make changes in the trigger column only to trigger the workflow and send the messages.

 

[mukesh_gil]

@Kunal Valuskar Thanks for the reply. Is there any way we can find out which cell has been updated?

 

[PabblyMember4]

Hey @mukesh_gil

Sorry, apart from the trigger column we can't tell you which column gets updated by you. Because if you update any trigger column then it will trigger the workflow and it will send data to the next action steps.