Go to Google Sheets
Add Data in Sheet according to below format. Col A,B,C and D has the name, Country Code, Mobile Number and Massage respectively.
Click here to see, Sample sheet
Go to File> share and set permission to anyone with the link can Edit
Copy sheet id & Sheet Name:
Ex. if Url is: https://docs.google.com/spreadsheets/d/17bPvojDQY9vvN-1TpDO13j8T16toVuM3207kjz_sdSM/edit#gid=0
Then Id of that sheet is 17bPvojDQY9vvN-1TpDO13j8T16toVuM3207kjz_sdSM
Sheet name is at the bottom of the spreadsheet. (Ex. Sheet1, Sheet2 etc)
Come back to WhatsSheet App, and
Go to BULK WHATSAPP FROM GOOGLE SHEET DATA
Paste Google sheet Id and sheet Name and Click LOAD DATA FROM SHEET
Now, all Your sheet data is loaded in to the sheet. You can start sending.
Open WhatsSheet App, and
Go to BULK WHATSAPP FROM SAVED CONTACT
Allow permission to read your contacts (if asked)
Click LOAD SAVED CONTACT
Enter Default Country code without + (Only require if it is not available in your saved contact's number)
Now, all Your sheet data is loaded in to the sheet. You can start sending.
Tips:
If you want to send each massage with name of the person. Then simply write {name} in massage. When you press the send then this will be replaced by the name of that contact.
Ex. If in massage you write
Hello {name} and current contact name is John than this massage will become
Hello John in WhatsApp.
Open WhatsSheet App, and
Go to SEND WHATSAPP TO UNSAVED NUMBER
Country code without +
Enter Number and Massage and press SEND