Logo

Send Twitter DMs using Google Sheets

This tutorial will show you how to send Twitter DMs from Google Sheets with Sheet Mind.

Step 0: Link a Twitter Account

You need to link a Twitter Account to be able to send Twitter DMs via Google Sheets. See tutorial.

Step 1: Prepare your Google Sheet

Make an Google Sheet using the first row as the heading to make it easier to use.

View Sample Google Sheet

Prepare your Google Sheet

Step 2: Choose the communication mode as Twitter DM and data source as Google Sheet

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

Choose the communication mode as Twitter DM and data source as Google Sheet

Step 3: Link your Google Sheet

Link the Google Sheet created in Step 1.

Link your Google Sheet

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 Google 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 Google Sheet 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