Welcome to the community!
With your current setup, Parabola will not be able to access the folders and download the CSVs files stored in your URLs.
I’m uncertain, but you may be able to access those files directly if you authenticate your Google Drive account via API. Linking you to a community post showing you how to authenticate with Google services, in addition to the Google’s reference documentation.
Let us know if you have any questions about Google’s authentication setup and if you’re able to successfully pull in your files!