GC Notify uses the spreadsheet to populate your template, sending a customized message to each recipient.
Create spreadsheet columns for custom content
You must give column headings the same name as the corresponding message variable. If you have a template, GC Notify can create the columns for you. The column headings will follow the order in which variables appear in your template.
For email messages, the first column is the email address. For text messages, the first column is the phone number.
You’ll include a row for every recipient. The recipient’s row gives their custom content for each variable.
Filter spreadsheet content to a subgroup of recipients
Include a column for the conditional content. Insert “yes” if the recipient meets the condition, and “no” if they do not.
Upload spreadsheet and preview messages
Check that all variables have populated correctly. When ready, you’ll send the customized messages. You can send up to 50,000 messages at once.