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.

Recommended
Zapier
BlueBot’s Zapier app has a Send Text action and instant triggers for incoming texts and every change of state.
Zapier in the docs
Make
BlueBot’s Make app sends texts and starts scenarios when a text comes in or changes state.
Make in the docs
n8n
BlueBot’s n8n community node sends texts and starts workflows from BlueBot’s webhooks.
n8n in the docs

Recipes

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

01With Zapier

Starts when

Google Sheets’ New Spreadsheet Row trigger in Zapier

Keep one row per person with their first name and mobile number.
Start a Zap with Google Sheets’ New Spreadsheet Row trigger.
Add BlueBot’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

Starts when

BlueBot’s New Incoming Text trigger in Zapier

03With Make

Starts when

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

Send each row’s text with BlueBot’s Send Text module and put the row number in metadata.
Start a second scenario from BlueBot’s webhooks for message.delivered and message.failed.
Use the row number BlueBot 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