OAuth 2.0 Schwab API with Apps Script

Job ID: 39487154

Budget: $30 – $250 USD

I need a Google Apps Script to authenticate with the Charles Schwab API using OAuth 2.0. The authentication data should be stored in Google Sheets. The main purpose of this integration is to fetch market updates.

My overall objective is to be able to parse option chains data. However, the scope of this specific project is to implement authentication, including token management.

The deliverable can be a vanilla Google Sheet with Apps Script integration that simply allows me to enter my existing API KEY, SECRET and callback URI as properties. Testing can be the simple passing of a ticker symbol, e.g., NVDA and successfully return some option chain data from Charles Schwab.

Requirements:
- Implement OAuth 2.0 authentication
- Store authentication tokens securely in Google Sheets
- Fetch and display market updates

Ideal skills and experience:
- Experience with Google Apps Script
- Familiarity with OAuth 2.0
- Knowledge of Charles Schwab API
- Proficient in Google Sheets

Please provide details of your experience with similar projects.