How to Format your file for SMS Broadcast

How to Get Your List Ready for Sending Text Messages: 🌟 Before We Start: Make sure your list is in a file that ends with ā€œ.csvā€ (when downloading it from Google Sheets, Excel or any other location).

1. Make a List:

  • Open your list file.
  • Write names for each column at the very top. These names tell us what each column is for (like phone numbers, first names, etc.).
  • One of these names should be sms_number for phone numbers because we need them to send texts!

2. Phone Numbers:

  • This column MUST be called sms_number or it won’t send any messages.
  • Write phone numbers with a ā€œ+ā€ sign and your country code first (like +1 for the USA). So, if a phone number isĀ 603-555-1212Ā in the USA, you’ll write it asĀ +16035551212.

3. Name Your Columns Wisely:

  • You can have any names for your columns, but some special names like ā€˜first_name’, ā€˜last_name’, ā€˜email’, and ā€˜sms_number’ tell our system exactly what to do with them.
  • Don’t use the name ā€˜_botcoid’ – it’s our secret code!

4. Upload Your List:

  • Once your list looks good, save it.
  • In our SMS Broadcast feature, there will be a place to upload this list. Just click, find your file, and upload!

šŸš€Ā Ready, Set, Go! Now, you’re all set to send your messages to everyone on your list.

When writing your message don’t forget to use your newly created attributes to personalize the SMS Broadcast:

šŸ’”
Hi ${first_name}. Please fill out this survey: ${survey_url}. Thank you!

šŸŽĀ Bonus: A Simple Example! Imagine you have a list like this:

  • Column 1 named ā€˜first_name’ for first names
  • Column 2 named ā€˜last_name’ for last names
  • Column 3 named ā€˜email’ for email addresses
  • Column 4 named ā€˜sms_number’ for phone numbers

Remember, phone numbers should look like this:Ā +16035551212 This way, everything is neat and easy for us to understand who we’re sending your messages to!