JSONDecodeError: Expecting value: line 2 column 1 (char 1)

[Rodolfo_PENA]

Hello guys,

I’m trying to connect Streamlit to a public Google Sheet, but I get the following error:

JSONDecodeError: Expecting value: line 2 column 1 (char 1)

I’ve followed each step but it doesn’t work.

Any idea?

Than you in advance

Ro

[andfanilo]

Hello @Rodolfo_PENA , welcome to the community

@Rodolfo_PENA

I’ve followed each step but it doesn’t work.

Could you elaborate which guide you tried to follow for this and on which step you are getting the error ? Are you perhaps following the official one ?

@Rodolfo_PENA

JSONDecodeError: Expecting value: line 2 column 1 (char 1)

Are you able to locate and print the JSON string to check if is malformed (I guess that would be the JSON key file) ? Maybe saving it or passing this JSON through Python Object and String has corrupted some of it’s quotes/separators.

Hope to hear from you soon!
Fanilo