Test Fund Widget Model API

Notes on Dev setup:

Based on our research, for now we’ll be proceeding with using Google Sheets for our source data, create the API workflow, and use Squarespace with embed graphs/charts using selected filters.

We’ve successfully created our API using Deploy after several attempts as Google issued an Auth issue. Still not verified yet, but we’ve initially created the spreadsheet with our Project account, but Google created an Auth issue when we created the App Script, so we then tested using Sharing access to our Main account. Even doing so, it continued showing the Auth issue, so we checked online and verified that proceeding with Adv settings works. For now, we’ll proceed using our Main account (for testing purposes), but prefer not to for long term due to Google Storage issues.

Regarding the workflow, we’re considering the following:

Google Sheets → JSON API → External Chart.js Page → Squarespace iframe

We’ve initially thought that Squarespace could embed charts/graphs, but AI confirmed that Squarespace can’t allow Javascript to run inside the page content. Can’t run Chart.js inside the Squarespace page, and is a global injection zone, not page injection zones.

Therefore, can embed Chart.js via iframe where Squarespace+JSON.

We’ve created the API using Google Sheets using our Fund Widget Model API as our sample test data. Next is, AI mentioned we need to use an external Chart.js page, and AI suggested Netlify and Google Charts. Also mentioned Github, but we prefer a more simple dev setup.