Quickly insert transactions in your budget spreadsheet by creating a Trello card.

Check out the YouTube playlist for a complete walkthrough on building this project.

1. Create a new Firebase project called budget.
2. pip3 install --upgrade google-api-python-client oauth2client
3. Follow quickstart guide step 1 to enable the Google Sheets API and download credentials for your Firebase budget project .
4. Copy the credentials.json file in project directory and run the following to generate token.json:

   python3 createtoken.py

1. Install Node.js & npm
2. npm install firebase-functions@latest firebase-admin@latest --save
3. sudo npm install -g firebase-tools

1. Run firebase login to authenticate the firebase tool.
2. Make sure that your Firebase project name & ID are correctly configured in .firebaserc:

   {
       "projects": {
           "budget": "<project-ID>"
       }
   }

• Run npm install from the functions directory.

Set the following fields in webhook.sh & run it to create a Trello webhook:

• APIToken
• APIKey
• CallbackURL
• ModelID

./webhook.sh

• Create a new collection called config in your Cloud Firestore and create a document called auth in it.
• Set your username, password & trello secret in your environment configuration:

  # set admin username & password
  firebase functions:config:set admin.username="utku" admin.password="ilikebananas"
  
  # set trello secret
  firebase functions:config:set trello.secret="<YOUR_TRELLO_SECRET>"

• Also create an .runtimeconfig.json file inside functions directory and set the same username & password in it as well:

  {
      "admin": {
          "username": "utku",
          "password": "ilikebananas"
      }
  }

• Finally make sure to set LOCAL_PORT correctly in post.py while serving functions locally.

Serve functions locally without deploying functions to cloud:

# default port is 5000
sudo firebase serve --only functions --port=5123

Deploy functions to cloud:

firebase deploy --only functions

# set spreadsheet ID by URL
python3 post.py local setSheet <SPREADSHEET_URL>

# set auth token
python3 post.py local setToken token.json

# make a transaction request
python3 post.py local transaction trello.json

# set spreadsheet ID by URL
python3 post.py remote setSheet <SPREADSHEET_URL>

# set auth token
python3 post.py remote setToken token.json

# make a transaction request
python3 post.py remote transaction trello.json

• Trello Webhooks Guide
• Trello Webhooks Reference
• Firebase Cloud Functions Guide
• Environment Configuration
• Google Spreadsheets API
• Express API