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!