Sending SMS through Excel Uploads

The system offers a straightforward way for users to trigger personalized short messages by uploading customer data via Excel sheets. This feature is particularly beneficial for small businesses that lack access to third-party API systems. It streamlines the process, enabling users to trigger short messages at scale, thereby saving both time and effort.

Follow these steps:

1. Navigate to the menu option located on the left side of the home screen.

2. Choose Transactions and select Send SMS.

3. Please be aware that only templates that have been published are accessible in this section. Choose a template of your preference. You can also utilize the search option located on the right side of the screen to easily find your desired template.

4. Upon selecting the template, a window will appear displaying the details of the selected template and the available variables within the chosen template. Navigate to the upper right corner of the page, and click on the "Sample Format" option to download the Excel sheet for entering data corresponding to the variables embedded in the template.

5. In the "Sample Format" Excel sheet, there are predefined fields:

1. Country Code (Excluding '+'): Enter the numerical prefix that precedes the full national phone number for making international calls. Ensure not to include the plus sign ('+') in this field.
   - Example: Enter '+91' as '91'
2. Mobile Number: Input the mobile number in the format specified.
   - Example: 9999999999

Now input the customer data corresponding to the variables embedded in the template. 

6. Now come back and simply drag and drop the Excel sheet in the below area.

7. The system will trigger the SMS sending process, and we will be able to view the status once the SMS is successfully sent.

Info: Only published SMS templates are visible in the selection area. Therefore, please ensure that your SMS template is published before making a selection.

• Related Articles

• Triggering Emails Through Excel Uploads

  The system offers a straightforward way for users to trigger personalized Emails by uploading customer data via Excel sheets. This feature is particularly beneficial for small businesses that lack access to third-party API systems. It streamlines the ...

• Generating PDFs through Excel Uploads

  The system offers a straightforward way for users to generate personalized PDFs by uploading customer data via Excel sheets. This feature is particularly beneficial for small businesses that lack access to third-party API systems. It streamlines the ...

• Sending a Test Message In SMS and Phone Calls Template

  For sending a test message in SMS and Phone Calls Template, follow these steps: 1. Hover over the bottom part of the Short Messages page for the "Send Test Message" dialogue box to appear and click on it. 2. Once clicked, a model shows up where you ...

• Initiate Phone Calls through Excel Uploads

  The system offers a straightforward way for users to trigger personalized audio short messages by uploading customer data via Excel sheets. This feature is particularly beneficial for small businesses that lack access to third-party API systems. It ...

• Publishing and Approval in SMS Templates

  The system has three User roles, each with specific privileges. Administrators can solely view and manage the system configurations. Designers have the authority to create email templates and submit them for testing and approval. Publishers, on the ...