Using APIs to pull data through custom fields in CMS collections

Hey guys,

This could be an incredibly ambitious project to pull off on Webflow…

I’m trying to create individual stocklist pages on my site (2000 collection items to be exact) through the CMS and trying to understand opportunities and limitations around pulling dynamic data through custom fields in collections. How we will source the data is another issue, but I’m wondering if anyone has had any experience with connecting data sources like this Tesla: TSLA Stock Price Quote & News | Robinhood through to displaying in collection items?

I have had a look into connecting Zappia and Google sheets, is there any other opportunities that I’m missing?

Appreciate any feedback, thanks :pray: