There are multiple threads regarding how to convert a google sheet to CSV. A customer provided a solution which in my opinion works the best for this.
@Jordan_VanMaanen Thanks!
Of note - The Google Sheet needs to be public if you’re going that route; otherwise it’s unable to be downloaded. Or somehow have your HTTP request authenticated.
I also discovered that you can get that same link via the Google Drive module which has an Exports Links collection returned with various outputs, CSV being one - But also, you need to be authenticated.
I settled on this solution which uses the Make an API Call module of Google Drive to download the file as a CSV.