Google sheet with formula

[saurabh12in]

hi there, When i am trying to send whatsapp message from google sheet, where i have lookup values from other sheets, it is not taking any data and sending blank messages.
each of these variable is a lookup value from other sheet. can anyone help ?

Dear Parent,

Please note that the fee for your ward data > 1: No Data Admission #data > 0: No Data for Rs data > 4: No Data is due.
Please pay the same by clicking the link data > 6: No Data. you may download the invoice by clicking data > 7: No Data
Please use netbanking for minimum processing fee.

 

[Supreme]

Hey @saurabh12in

This " data>x: No Data " means you need to map these fields again.

Because of the changes in your workflow the mapped values get elope.

Also for better understanding, please refer to our tutorial video on -

" How to Send SMS from Google Sheets Contacts in Real-Time | Automated Text Message Google Sheets" -