Getting Started: Send personalized mass Slack direct messages

Send mass Slack messages allows you to send personalized direct messages (DMs) in bulk in Slack. Let's see how to get started. Install the add on from here

There are three steps required

Step1 : Create a Slack Bot

Step2: Set up the Add-on

Step3: Send Personalized Mass Slack messages

Step1 : Create a Slack Bot

1. Visit api.slack.com and Select "Your apps" -> "Manage your apps"

2. Select "Create New App"

3. Select "From Scratch"

4. Enter an App Name and Workspace

5. You will see the app details. Select "Permissions"

6. Go down to the section called "Scopes". Select "Add an oAuth scope"

7. Add the following scopes to the bot.

1. chat:write

2. im:write

3. mpim:read

4. users.profile:read

5. users:read

6. users:read.email

8. Select "Install to workspace"

9. Select "Allow"

10. You will see the bot in the slack window, in the apps section

11 On the oAuth screen, you will also see a Bot User Auth Token. We will need this token to use in the add on.

Step 2: Set up the Add On

1. Install the add on from Google marketplace

2. Open any Google Sheet file. Select the arrow to expand the side panel on the right

3. You will see the "Send mass Slack messages" add on

3. Click the icon. For the first time, you will see the "Authorize Access" button

4. Choose the account.

5. The add on will ask for below permissions. Please select allow.

6. Select "Refresh" on the add on.

7. Select "Set up Slack accounts" section

8. Enter a unique name for the bot and the "Bot User Auth Token" from step here and save

9. Go back to the home page of the add on. You are all set to send mass slack messages

Step 3: Send Personalized mass Slack messages

1 Set up the sheet with

1. Email ID of the user to send to

2. Message to be sent

2. To send custom messages by user, follow the below steps

1. Enter the custom field column header (First row name) starting with "{{" and end with "}}" in the message

2. Please use exact column header name

3. Do not include any spaces between the column names and the brackets (i.e. {{ and }})

In the below example, column header is "Name" and the message is written as "Hi {{Name}}, Welcome to iNeuron.digital"

2. Select "Send Slack messages"

3. Create the fields to be used

1. Slack Bot Name - Choose the Bot Name from here

2. Email ID to send Slack DM - Choose Email ID of the user; The add on will find the slack account for that user

3. Message : Message column to be sent

4. Select "Start"

5. You will see a pop up with "Sending Slack messages now". It will automatically disappear once the messages are sent.

Please do not close the window / Google Sheet at this point in time.

6. You will see the message sent to the user from the bot. The field "Name" is replaced by the value in the column - Alex

7. If you are a free plan user, you will see an additional watermark. This watermark will be deleted if you join the paid plans

8. Once successfully complete, you will see the status on the Google sheet updated