Permalink
Find file
b7c23ae Jul 17, 2014
@jpf @devinrader
70 lines (37 sloc) 2.61 KB

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.