Very well presented with clear explanations at each stage. I have looked at a few eother videos describinng how to read/write to a Google sheet, but this is by far the best one I encountered.
Is there a way you can authenticate without sharing the service control email to the spreadsheet? I am working with a company domain and I can't add external addresses
Share the sheet with the client, give him a copy of the code and provide him with a step by step manual of how to use the API and use the python script.
@@AryanIrani123 Thanks, but that is not free? What I want is to read data from an excel sheet of google sheets, I don't need to write about it. Until a few weeks ago it worked for me, I "published" the excel sheet, then through a link that ended in .json, I read that sheet from my server, but now it doesn't work