Logo

Send Twitter DMs using an Excel file

This tutorial will show you how to send Twitter DMs from an excel file with Sheet Mind.

Step 0: Link a Twitter Account

You need to link a Twitter Account to be able to send Twitter DMs via an Excel file. See tutorial.

Step 1: Prepare your excel file

Make an excel sheet using the first row as the heading to make it easier to use.

Download Sample File

Prepare your excel file

Step 2: Choose the communication mode as Twitter DM and data source as Upload file

In this stage, select Twitter DM as the communication mode and data source as Upload file and then proceed to the next step.

Choose the communication mode as Twitter DM and data source as Excel

Step 3: Upload the excel file

Upload the file created in Step 1. Acceptable file formats are .xls, .xlsx, .xlsm, .xlsb.

Upload the excel file

Following the file selection, you should see the file details as seen in the figure below. If everything appears to be in order, click upload, then next once the file has been properly uploaded.

See file details

Step 4: Choose a template for the Twitter DM

This is where you set the format of the personalised message that will be delivered to your recipients.

The required fields are From Twitter User, To Twitter User and Body. In each of the fields, you can choose a place holder value. For example, using the {{ Twitter Handle }} in the To Twitter User field will replace the values from the data in the excel sheet.

You can add a placeholder in two ways:

  1. By clicking on the sticky buttons, each of whom represents a valid column header.
  2. Adding the header name enclosed in double curly braces manually. For example: {{ Twitter Handle }}

Step 5: Preview the sample Twitter DMs

You'll be able to check how the data from the excel file you supplied in Step 3 replaces the header variables in this step. Please double-check all of the samples to ensure that the format is what you want to use.

Preview the sample Twitter DMs

Step 6: Schedule the send

You can schedule the send for a specific date and time in the future or send it right away at this stage.

Schedule the send

Step 7: Send

This is the last step in the process. If everything appears to be in order, you can submit the work and monitor its progress. Take a seat and unwind!

Send