How to send text messages#

MS Excel Max Integration version 2.0

To send text messages, follow these steps:

1. Getting started#

• Open the API Methods window and fill in the Parameters tab according to the instruction

• Go to the Send text messages sheet

2. Fill in the columns:#

When collapsing a table, the entered data may be reset. This is a feature of MS Excel, we recommend that when filling in data, you collapse not the table, but the browser.

Column C - Chat ID (Client number)#

The cells in this column indicate the numbers of the message recipients.

• To send to a personal number, specify chatID (phone number in international format)
• To send to a group, specify groupID.

How to quickly export contacts from an account?

To automatically export contacts into a table:
1. Open the API Methods window
2. Open the Sending Text Messages page
3. In the Export contacts cell, select the required option:
- "All contacts" - all account contacts (groups and personal chats) will be unloaded into the table
- "Personal chats" - all account personal chats will be unloaded into the table (groups will not be unloaded)
- "Groups" - all account groups will be unloaded into the table (personal chats will not be unloaded)
- "Previously had a chat" - all contacts with whom there was correspondence will be unloaded into the table
- "Saved" - all contacts saved in the account's contact book will be unloaded into the table
4. Click the Export contacts button

Column D - Chat ID (personal, group)#

Filled in to determine whether the ID in the cell on the left is personal or group.

• If personal number is specified on the left, then write personal in the cell
• If group is specified on the left, then write group in the cell

Column E - Message text#

The cells indicate text of the message being sent.

Line breaks in cells are formatted with the symbol \n

• How to format messages
• How to send emoji

Optional columns: A, B

• Column A - №

Filled in for clarity of the row serial number.

• Column B - User (Name, Email)

Filled in for identification of the specified numbers by name, email or other data.

Enable number verification if necessary#

To check if a number has a WhatsApp account, open the API Methods window and enable the Check number checkbox

The function only works to check personal phone numbers and does not check the existence of groups.

For this reason, do not enable the checkbox when sending to groups or when sending to personal numbers and groups on the same sheet.

After sending messages, you will receive the status {"existsWhatsapp":false} or {"existsWhatsapp":true}:

• false - means that the number does not have a WhatsApp account or there is an error in the number;
• true - means that the number has a WhatsApp account.

3. Start mailing#

After filling in all the required cells, open the API Methods window on the Sending Text Messages page and click the Start mailing button

After the sending starts, the G, H columns will start filling in each row.

If number verification is enabled, the F column will also be filled in.

After the sending is finished, a notification window will appear. Do not turn off the table until this window appears.

How to stop mailing#

To stop mailing, click Stop mailing on the Sending text messages page

• To clear the queue of messages to send, click Clear queue on the Sending Text Messages page.

  We recommend clicking this button before starting a mailing.

Column F - Availability of WhatsApp account

The cells indicate the presence/absence of a WhatsApp account on the number.

The function only works to check personal phone numbers and does not check the existence of groups.

For this reason, do not enable the checkbox when sending to groups or when sending to personal numbers and groups on the same sheet.

To perform a check when sending, check the checkbox in the API Methods - Sending text messages window

Column G - Message Status#

The cells indicate the message status. Possible statuses:

• Message sent - the message was successfully sent
• Message NOT sent - the message was not sent

Column H - Response body (message id)#

Contains the message ID if sent successfully and a description of the problem if there was an error.

• In case of sending: {"idMessage":"your message id"}
• In case of an error: Whatsapp account not found

Message statistics#

To check the statuses, you need to enable notifications in your console.
It may take up to 5 minutes for the new settings to apply.

If the user has disabled the notification of reading messages, you will not be able to find out whether the message has been read.

Open the API Methods window and on the Sending Text Messages page, click the Message status button

Possible statuses:
- sent - message sent
- delivered - message sent
- read - message read
- Message not found - message is in the sending queue or was sent to a non-existent account

To update the statuses, click the Refresh statistics button

You can learn more about statuses in our article "What are the statuses of messages in WhatsApp?"

How to delete sent messages#

To delete messages sent from the table:

1. Open the API Methods window
2. Open the Sending Text Messages page
3. Check the box next to the Delete Messages button
4. Click the Delete Messages button

After deletion, the "Deletion completed" window appears and the message status changes to Message deleted

How to quickly clear a sheet#

To clear the current sheet:

1. Open the API Methods window
2. Open the Sending Text Messages page
3. Check the box next to the Clear Table button
4. Click the Clear Table button

After deleting, the "Deletion completed" window appears.

How to add contacts to a group#

To add numbers to a group

1. Create a group from a device or via API using the createGroup method
2. Fill in the C - Chat ID (client number) column

1. Open the API Methods window
2. Open the Sending text messages page
3. Enter the ID of the created group in the Group ID field
4. Click the Add to group button

After the addition is complete, the "Done" window appears

The H - Response Body column will show the result of the addition:

• Why are members not being added to the group?