Redirect you incoming SMS to Google Spreadsheet
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
test
views
.editorconfig
.gitignore
.travis.yml
CODE_OF_CONDUCT.md
CONTRIBUTING.md
Dockerfile
ISSUE_TEMPLATE.md
LICENSE
PULLREQUEST.md
PULL_REQUEST_TEMPLATE.md
Procfile
README.md
app.json
docker-compose.yml
index.js
models.js
package.json
routes.js
yarn.lock

README.md

Bandwidth Sheet

A demo app which allow to redirect incoming SMSes to specific phone number to Google Spreadsheet

Deploy

Build

Requirements:

  • Node 7.5+ and MongoDb 3.0+ OR Docker 1.10+ and Docker Compose
  • External https access (via port forwarding like ngrok, VPS, etc)

Install

If you use Node directly install dependencies by

# Install dependencies (Node-way only)
npm install

# or via yarn
yarn install

Run the app by

# Node-way (Mongo should be ran before this step, set DATABASE_URL  with valid url to your mongo db instance)
npm start

# Docker-way
PORT=3000 docker-compose up -d # web app will be available on port 3000

Configure port forwarding to open external access if need (like ngrok http 3000).

Open this web app in browser and follow instructions to configure.

Authorization

Open url which you'll see on last page of configuration (like https://your-host/google/authorize?sid=XXXXX). Allow access to your google spreedsheets.

As result you will see a phone number which will can be used for incoming SMSes. In you Google Drive you can find new spreadsheet SMSes of YOUR_PHONE_NUMBER. All incoming SMSes will be stored there. You can rename this file if need.

Using app

Send SMS to assigned on previous step number. Your SMS will be shown in spreadsheet.