Hi @Matt_Billiodeaux! Welcome to the community and thanks for reaching out. 
I think the implementation that you've shared here is very close to functional and just needs a couple of tweaks.
The root of your issue is likely the way that you are interpolating textInput2.value into the URL of the getGDriveCSV query. Specifically, the base URL is meant to be static and doesn't support interpolation. It should probably look something more like the following, where the dynamic portion of the URL is defined separately.
Other than that, there are certain Retool tricks you could make better use of. Using a textInput component to dynamically pass data into a query is clever, but Retool supports this natively using the additionalScope option. There's a great topic on the subject here and I definitely recommend utilizing this approach.
I hope that helps! Let me know if you have any additional questions.