A Python Flask application to take Twilio SMSes and submit them to a Google Form
Python
Pull request Compare This branch is 20 commits ahead of jpf:master.
Latest commit b7c23ae Jul 17, 2014 @devinrader README edits
Permalink
Failed to load latest commit information.
static/img Refactoring. Fixed up the readme Jun 26, 2014
templates
tests
.gitignore
Procfile
README.md README edits Jul 17, 2014
app.py Refactoring. Fixed up the readme Jun 26, 2014
formurlvalidator.py Refactoring. Fixed up the readme Jun 26, 2014
gform.py Fix parameters bug Jul 1, 2014
ptvs_virtualenv_proxy.py Cleaning out unneeded files Jun 26, 2014
requirements.txt Adding files for hosting on Heroku Jul 29, 2012
routes.py
switch.py Refactorings Jun 26, 2014
twiliosheet.pubxml Cleaning out unneeded files Jun 26, 2014
web.config Fix parameters bug Jul 1, 2014

README.md

Receiving SMS messages in a Google Spreadsheet

Use Twilio and Google Spreadsheets to build your own applications to do SMS polling / SMS voting, keyword marketing data collection, expense tracking, time tracking, and more.

No programming experience required.

Instructions:

An example spreadsheet

Get Started

  1. Create a Google Form:

    Create > Form

  2. Name the form "TwilioSheet" (or any name of your choosing) and select a nice design.

  3. Add a new Text question. Set the Question Title to "SmsSid"

    Create a Question

  4. Repeat step three, adding questions with Question Titles "To", "From" and "Body" (other parameters are available as well). This is what your Form should look like:

    Add additional questions

  5. If you see an option that reads "Require [Company Name] login to view this form.", uncheck the box for that option.

    Uncheck required login

  6. Once you are done building the form, click the "Send Form" button located in the upper right corner of the webpage:

    Click Send Form

  7. A dialog window will open. Copy the "Link to Share" URL from that window:

    Copy the Form URL

  8. Open TwilioSheet in a new window.

  9. Paste that URL you copied in step 7 into the box on TwilioSheet, then click the "Submit" button.

  10. You should get a response from the site saying "It worked!"

  11. Copy that URL:

Open another browser window. In that new window:

  1. Log in and go to the "Numbers" section of your Twilio account

  2. Click on the number you want to set up to send SMS data to your Google Spreadsheet.

  3. Paste the URL you copied above into the "SMS Request URL" box for the Twilio number you are configuring.

    Voice Request URL

  4. Click the "Save Changes" button.

  5. Send a text message that says "test" to the number you just set up.

In your Google Spreadsheet:

  1. Any text message you send to your Twilio number should show up in the Google Spreadsheet you set up after a delay of about 5-10 seconds.

  2. Start writing formulas to process the incoming text messages.