{% extends "withnav_template.html" %} {% from "components/page-header.html" import page_header %} {% from "components/page-footer.html" import page_footer %} {% from "components/file-upload.html" import file_upload %} {% from "components/table.html" import list_table, text_field, index_field, index_field_heading %} {% from "components/components/back-link/macro.njk" import usaBackLink %} {% block service_page_title %} Upload your bulk-sending spreadsheet {% endblock %} {% block backLink %} {{ usaBackLink({ "href": url_for('main.send_one_off_step', service_id=current_service.id, template_id=template.id, step_index=0), "html": "Back to select recipients" }) }} {% endblock %} {% set phone_numbers = [ { "svg_src": "#check_circle", "card_heading": "Label column A (the first column) as Phone number", }, { "svg_src": "#check_circle", "card_heading": "Double check it's the only column with Phone number as its label", }, { "svg_src": "#check_circle", "card_heading": "Make sure no duplicate phone numbers are listed in Column A", } ] %} {% set additional_data = [ { "svg_src": "#check_circle", "card_heading": "Match column labels one-to-one to the message template placeholders", }, { "svg_src": "#check_circle", "card_heading": "Label each additional personalized placeholder separately", }, { "svg_src": "#check_circle", "card_heading": "Separate each word in a column label with a space or dash, but no commas", }, { "svg_src": "#check_circle", "card_heading": "Fill in each personalized placeholder with the appropriate data or information", }, { "svg_src": "#check_circle", "card_heading": "Fill in each conditional placeholder column with a Yes (Y) or No (N) to “answer” whether the recipient meets its criteria", } ] %} {% block maincolumn_content %} {{ page_header('Upload your bulk-sending spreadsheet')}}
Organize phone numbers and information in a single spreadsheet and upload when you have multiple messages to send. Column headers in the spreadsheet will place the data in the right spots within the template that's selected.
Each template saved in Notify is given an example CSV formatted spreadsheet like this. It's the most reliable file format for uploading your contact list. Use this example to populate your template with the right data items. Start by downloading this example for your message template. Then save it as a CSV file for bulk messaging.
Template: {{ template.name }}
{{ template|string }} {% endblock %}