I want to make sent status column in my pabbly sheet.

[ansh010]

I already watched your video for this but it is saying to create new sheet and I don't want to.

 

[Supreme]

Please elaborate on your question in brief so that we can understand what automation you're exactly looking forward to doing.

Thanks!

 

[ansh010]

there is a sheet where I enter data and it sends whatsapp message to that number, now I want to make a column with heading (Status) in that sheet and there will be entered the status of the whatsapp message like (delivered or failed). I also saw your video on how to do this thing but they said to create a new google sheet but I want to do it in my data sheet.

 

[ansh010]

Pls check this

 

[ansh010]

there is a sheet where I enter data and it sends whatsapp message to that number, now I want to make a column with heading (Status) in that sheet and there will be entered the status of the whatsapp message like (delivered or failed). I also saw your video on how to do this thing but they said to create a new google sheet but I want to do it in my data sheet.

Pls help me regarding this

 

[PabblyMember4]

Hey @ansh010

You can put a Lookup in the excel sheet and then search that number if the message gets delivered then you can put the Google Sheet - Update Cell Value and can update the status.

Please let me know if you have any questions or comments.

 

[ansh010]

but I can't do it in single workflow

 

[ansh010]

Because it needs to be trigger to get message notification option in whatsapp cloud api

 

[PabblyMember4]

Yes, you can do it in a single workflow. You just need to add the Status column in it and add Lookup to check the number if exists or not and then add the Update Cell value. Kindly try it and let me know if it is working.

 

[ansh010]

how would I add this step????

 

[Supreme]

Hey @ansh010

If you are looking to configure the WhatsApp Cloud API's trigger event, you can refer to the following video tutorial.

And to set up the workflow to update the status on Google Sheets-

 

[ansh010]

this is on send message not update google sheet

 

[ansh010]

and this is ok I already saw this

 

[Supreme]

Hey @ansh010

Can you tell us at what step of your workflow, you are getting stuck?

 

[ansh010]

Not a step, Just want to integrate something.

 

[Supreme]

Hey @ansh010

Can you please explain what are you trying to integrate?

 

[ansh010]

Just want to integrate that if we send WhatsApp message then it shows sent message and also highlight those no. got failed with red text colour or something else

 

[Supreme]

Hey @ansh010

Unfortunately, the requirement which you are asking for is currently not possible to implement on the platform.

 

[ansh010]

I request to add this feature, I really need this.

 

[Supreme]

Hey @ansh010

The requirement you are asking for is not possible but you may post the request on the platform here - https://pabbly.hellonext.co/b/Integration-Request

But as a workaround, you can use the Router action step whereas you can use the "Exists" filter type in the filter step inside the router step on the basis of the WhatsApp Cloud API response.