Back

Send personalized texts to contacts from a Google Sheet

Approved texts sent to every eligible contact in your sheet, with each row's status logged

SalesOps
Prompt

Open my contact sheet [sheet link] and work through [row range, e.g. rows 2 to 40]. Names are in [column A], phone numbers in [column B], and status in [column D]. Text each person from [my texting tool, e.g. Google Voice] in the browser using this approved message: [message text with placeholders, e.g. Hi {first name}, confirming your visit on {date}]. Fill the placeholders from the sheet and keep everything else word for word. Skip any row already marked sent, with a missing or invalid number, missing a placeholder value, or marked [skip rules, e.g. opted out]. Send at most [30] messages this run at a steady, human pace, and stop at any warning, limit, captcha, or error. After each row, set the status to sent with today's date, or skipped or failed with the reason. When done, give me counts of sent, skipped, and failed, and list any rows I should check.

Works withdocs.google.com