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
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.