I'm building a custom source in python and wanted to debug the google_sheets_source using my own credentials to get a better understanding of the process. I'm using the JSON key of the service account for authorization but keep getting the error.

{"type": "CONNECTION_STATUS", "connectionStatus": {"status": "FAILED", "message": "Please use valid credentials json file. Error: Invalid control character at: line 1 column 171 (char 170)"}}

when I run the

check

command. It doesn't seem to like the

\n

s in the private key. Any advice?