an SMS bot built with Google sheets and Twilio
🤖 sms-bot.info is a how-to guide to making an SMS bot with Google Sheets and Twilio. You write the messages your bot will send in a Google sheet, which is also where people's responses are saved.
The project is built using Google Apps Script. It creates:
It's meant to be used with this template spreadsheet.
The document at sms-bot.info gives detailed instructions on how to set up the project - it's written such that the user doesn't have to write code (though they do have to copy and paste some code). It's recommended that you follow the document even if you are a developer, though instead of copying and pasting the code you may want to clone this repo and use Google's clasp to develop locally.
To use clasp
to develop locally, first download it:
npm install -g @google/clasp
And then enable the Google Apps Script API: https://script.google.com/home/usersettings
Make a copy of this template spreadsheet.
Clone this repo and `cd into the folder:
git clone [email protected]:nicolehe/sms-bot.git
cd sms-bot
Login to clasp
:
clasp login
Then create a project called "sms-bot" (or whatever you want):
clasp create sms-bot
Select "sheets" when it asks which script.
Push this code into your new Apps Script project, then open it in your browser.
clasp push
clasp open
To get your web app URL, it's recommended that you deploy from the browser the first time at least. Follow (the relevant instructions in sms-bot.info)
After that you can deploy with clasp
from your command line - make sure you use the deployment ID.
clasp deploy -i <id>
You do still have to manually run the add-on as a test from the project page if you change any of the sidebar code. Follow the relevant instructions in sms-bot.info.
This project is licensed under the MIT License - see the LICENSE file for details