If that's how the file is structured, you could split it on "\\n\\u001c" rather than "," like I have in my example above. We need to use "\\" rather than "\" as "\" is used to escape special characters in Text Blaze.
Again, I would be fairly cautious about directly loading the sheet due to the brittleness of the approach. I also believe Google Sheets only includes a portion of large spreadsheets in the initial load and then asynchronously loads the rest of the spreadsheet to decrease initial load times. When urlload'ing the spreadsheet directly, you only have access to the initial load.
Publishing the spreadsheet to CSV and then loading that would be a much more robust approach.