Load your sheet and write three scripts: a first message and two follow-ups. Each contact gets their own message with a WhatsApp link that opens ready to send. Follow-ups come due on their own for anyone who has not replied.
Numbers with 10 digits get the country code added. Rows with an unusable number are skipped automatically.
Click to insert a column into this script:
Photos for this message (optional). Photos stay in this browser. Up to 6 per message.
WhatsApp does not let a web page attach a file, so on the message card you press Copy photo and paste it into the chat. Videos cannot be pasted this way. Add a video link under Links, or attach the file with the paperclip.
Wording variants: {Hi|Hello|Hey} picks one at random for each contact, so no two messages are identical. Keep column placeholders outside the variant braces.
Save a link once, then use its name in any script, like {demo_video}. Change it here and every message updates. Put a link on its own line and WhatsApp shows a preview card with the picture. WhatsApp cannot attach photos or videos from a link, so share them as a YouTube, Google Drive or website link.
Follow-up days count from the previous message to that person. The daily limit counts first messages and follow-ups together. Start near 20 a day and raise it slowly.
| # | Name | Business | Phone | Status | Next follow-up |
|---|
Progress is saved in this browser only. Copy the results as CSV to keep a record in your own sheet.