community-sms-broadcast | broadcast SMS messages to people | SMS library

We need to do a few things to use this app, including preparing credentials to make the spreadsheet accessible from the Twilio Function.
Create a new Google Spreadsheet
Give it the column headings "Number", "Name", and "House" in that order
Enter your community member phone numbers, names and house numbers (or other identifying detail you want to include)
In the Google developer console, create a new project.
Click Enable API. Search for and enable the Google Drive API
Create Credentials for a Web Server to access Application Data
Name the service account and grant it a Project Role of Editor
Download the JSON file of credentials and open it up
Find the "client_email" key in the JSON file and get the email address. Back in your spreadsheet click the Share button and paste the client_email into the share field to give that email address access to the spreadsheet. We'll need these credentials again, so keep them safe
You can deploy the Twilio Function for this application two ways, using the Twilio Serverless Toolkit or the Twilio Functions UI. You will need Node.js installed to perform this method. Now you should be ready to deploy.
In your Twilio console buy a new phone number with SMS capabilities
Clone this repo git clone https://github.com/philnash/community-sms-broadcast.git
Change into the directory and install the dependencies cd community-sms-broadcast npm install
Copy the .env.example file to .env cp .env.example .env
Fill in the .env file with your Twilio Account Sid and Auth Token (available in your Twilio Console)
Open your Google Spreadsheet and look at the URL bar, it should look like https://docs.google.com/spreadsheets/d/{GOOGLE_SPREADSHEET_KEY}/edit#gid=0. Take the string that represents your GOOGLE_SPREADSHEET_KEY and enter that into .env
Take the Google credentials JSON file you downloaded earlier and move it into the assets directory. Call it assets/credentials.private.json.
[optional] Open functions/community-sms-broadcast.protected.js and update the message assigned to notOnTheListMessage (this will be sent to anyone who sends a message to the number that is not on the spreadsheet)
Deploy the project to Twilio Functions npm run deploy
This will give you a URL where your function is hosted
Copy the URL and enter it as the Messaging webhook for the phone number you bought earlier and save the number
Open the Twilio Functions admin console
Create a new blank Function
Name the Function "Community SMS Broadcast"
Give the Function a path, like /community-sms-broadcast
Check the Access Control checkbox
Replace the code with the contents of functions/community-sms-broadcast.protected.js from this repo
[optional] In the code, update the message assigned to notOnTheListMessage (this will be sent to anyone who sends a message to the number that is not on the spreadsheet)
Save the Function
Open the Twilio Functions Configuration console
Check the box that says Enable ACCOUNT_SID and AUTH_TOKEN
Take the Google credentials JSON file you downloaded earlier and upload it as a private asset called credentials.json.
Open your Google Spreadsheet and look at the URL bar, it should look like https://docs.google.com/spreadsheets/d/{GOOGLE_SPREADSHEET_KEY}/edit#gid=0. Take the string that represents your GOOGLE_SPREADSHEET_KEY and enter that as an environment variable called GOOGLE_SPREADSHEET_KEY
In dependencies, enter google-spreadsheet with the version 3.0.10
Save the configuration
Open your function again and find the full URL and path
Copy the URL and enter it as the Messaging webhook for the phone number you bought earlier and save the number