When the script completes your deployment details will be logged to your terminal.
The ID is available in the URL of the sheet, the URL looks like this: We also need the sheet ID so that we can access it from the API. Click the Share button and enter the client_email from the JSON file you downloaded earlier. We need to give access to our service account to this sheet so we can use it through the API. You should enter your number in e.164 format prefixed with an apostrophe ' so that Sheets doesn't try to treat it as a formula. Create a sheet with the headings "Number", "Name" and "House":įill in your own details under the headings. Your Google Sheet will store the numbers of everyone in the group along with their name and some other identifying information (like their house number so everyone knows who is who). We'll need this JSON file soon, so keep it handy. Name the service account and grant it a Project Role of Editor.Create credentials for a Web Server to access Application Data.Search for and enable the Google Drive API To programmatically access Google Sheets, you’ll need to create a service account and credentials in the Google API Console. Setting up a service account for the Google Sheets API A Twilio number that can send and receive SMS messages.A Twilio account (if you don't have one, sign up for a new Twilio account here and receive $10 credit when you upgrade).If you want to build a community SMS group with Google Sheets and Twilio you will need the following:
#Typo in the group chat code
If you want to skip straight to the end, check out the code and setup instructions in the community SMS broadcast repository on GitHub. When you send an SMS to the number it will forward that message on to everyone else in the group. We will create a Google Sheet that lists the people in our group and a phone number that can be used to contact all of them by SMS.
#Typo in the group chat how to
In this post we'll see how to use Google Sheets, Twilio Functions, and Programmable SMS to administer a community SMS broadcast group. Doing this with a regular group message could get messy as it's a pain to add or remove people from a group message. One way to support a local community is to set up a message group so that neighbours can easily offer or ask for help. Under the strange circumstances of the coronavirus we have seen some wonderful stories of communities getting together virtually to support each other.
0 kommentar(er)
