Create a automatic Whatsapp robot

Hello to everyone!

I’m creating a robot to send automatic messages.

I’m doubt about, how to extract the phone number of Excel, to put in the link (Open WhatsApp). Someone can help me?

Hi! Welcome to community,

Try like this:

  1. Read the excel using Read range activity → Output as-> dt_out
  2. Take one for each row activity pass the - dt_out
  3. Inside the for each row take one Assign activity → create a string variable like this
PhoneNumber = CurrentRow("Phone_Number").ToString.Trim


Where phone_number is your column name

Then use this variable to get the phone numbers one by one

Try this and let me know