0 Send Reminder Text To People On Schedule Shared by One Life Christian Church, One Life Christian Church 4 years ago 9.0 Communications Beginner This is how I setup an automatic text to go out whenever a reminder email was sent out. This mainly uses Zapier so it's important to setup a zapier account first. Step 1: Setup a Zapier accountthey offer a free “starter” plan for nonprofits allowing you to do more complex ZAPShttps://zapier.com/non-profits/Step 2: Create a unique email address for schedulesI used our free office 365 account and made an email: schedule@*ourwebsite*.comStep 3: Edit the “system email” titled “scheduled reminder email”Add your newly created email as the CcPlace stars (**) on either side of text you want to isolate. I did it like this: **{{ attendance.Occurrence.OccurrenceDate | Date:'dddd, MMMM d, yyyy' }}** **{{ attendance.Occurrence.Group.Name }}**Step 4: Create an excel sheet on office 365 (or you can probably also do this with Google Sheets) Create 3 columnsEmailCellphoneFirst NameStep 5. Create a ZAP with zapierTrigger: I used my NEW EMAIL with Office 365 as my trigger but I’m sure you can use GMAIL if desiredI have it process all emails to my /inbox. Filter: Only continue if…(body preview) (text- contains) (scheduling reminder)ACTION: Formatter by ZapierI used the “text” optionTransform: Split TextInput: Body Preview (which shows the text of the email)Separator: **This is from the previous step to isolate the text that I want to be able to pullSegmented Index: AllMy example above led to 5 different items. I mainly want to use Item 2 & Item 4. But this may be different if you have a different setup.SEARCH: ExcelFind RowOptions:Folder: Root (or wherever you saved the online sheet)Spreadsheet: *Name of file*Worksheet: *Sheet that has the columns setup*Lookup Column: EmailLookup Value: Step 1 Trigger “To Recipients email”ACTION: TwilioSend SMSTemplateFrom Number: *Number you want to send from* I might eventually create another excel file that I search for the “group” for and find the group leader and pull their info over to this sectionTo Number: From step 3 Cellphone Message: Hey (Step 3 First Name), just a reminder you’re serving in (step 2 Item 4) on (step 2 Item 2). Login to *shortlink for their schedule toolbox* for more info. Thanks!I hope someone might find this helpful. I'm sure there is a better more technical way to do this. But with my limited knowledge this is the way I got it to work.