Spreadsheets and databases

Google Sheets

Text each new row, and keep a sheet of every reply.

What you can do

  • Text each person on a new row and use the row’s columns as the text’s variables.
  • Keep a sheet with one row for every reply you get.
  • Mark each row when its text is delivered or fails.

How it connects

  • Recommended

    Zapier

    DogBot’s Zapier app has a Send Text action and instant triggers for incoming texts and every change of state.

    Zapier in the docs
  • Make

    DogBot’s Make app sends texts and starts scenarios when a text comes in or changes state.

    Make in the docs

Recipes

Three recipes to start from.

Set one up as written, or change it to fit how you work. The docs have the same recipes step by step.
01With Zapier

Text each new row

Starts when

Google Sheets’ New Spreadsheet Row trigger in Zapier

  1. Keep one row per person with their first name and mobile number.
  2. Start a Zap with Google Sheets’ New Spreadsheet Row trigger.
  3. Add DogBot’s Send Text action, map the phone column to To and write the text with the name column in it.

The text it sends

Hi {{first_name}}, your {{service}} is booked for {{date}}. Reply here if you need to change it.

From your own number

02With Zapier

Log every reply in a sheet

Starts when

DogBot’s New Incoming Text trigger in Zapier

  1. Start a Zap with DogBot’s New Incoming Text trigger.
  2. Add Google Sheets’ Create Spreadsheet Row action.
  3. Map the sender’s number, the words and the time to the sheet’s columns.
03With Make

Mark each row delivered or failed

Starts when

A text is delivered or fails (DogBot’s message.delivered and message.failed webhooks)

  1. Send each row’s text with DogBot’s Send Text module and put the row number in metadata.
  2. Start a second scenario from DogBot’s webhooks for message.delivered and message.failed.
  3. Use the row number DogBot echoes back to update that row’s Status column with Google Sheets’ Update a Row.

The text it sends

Hi {{first_name}}, your tickets for {{event}} are ready. Show this text at the door.

From your own number

Try DogBot free for 7 days.

You need a card to start the trial. After 7 days it’s $29 per month plus any tax, and you can cancel from your billing page at any time.