Code Works in Command Prompt/Pycharm doesnt work when i run it via Tm1 process in Arc

[SamilOzmen]

Hello
I have a python code which reads then writes data from the Google spreadsheet.Code reads data from sheet 1 and sheet 2 and writes it in a different spreadsheet The code works fine in pycharm and command prompt but when i run it with command prompt  via a process in Arc it just works for the first sheet and does nothing after that. doesnt work for second sheet and so on.But it works fine and finishes the code if i try to run it just for the sheet 1 or just for the sheet 2. I dont know how to debug the error cause it works in pycharm.I don't know what to do.Pls HELP :(

the function which reads and writes data

i use the function in another code does the first call and does nothing after
( if i use pycharm or command prompt it works fine ends without an error )

how i run the code in process

Thank you all for the help :)