Python Forum

Hi folks.

I'm not entirely sure it's even possible, but I'm hoping some genius could explain to me how to make Python (PyCharm) create entirely new google sheets within an allocated folder in google drive. Now, I don't mean a new sheet withing an existing file, I mean an actual new file. Is it possible?...

In a nutshell, I'm in the beginning process of creating a custom app for job site measures/quotes (for my business) and require the final submit button to generate a new spreadsheet that contains customer/order details. I don't want all of my customers details + their orders in 1 file.
I'm a somewhat noob to programming, but the app itself shouldn't be too difficult with the help of the web.

Thanks for reading and I appreciate any advice given.


Dan

Look at API for Sheet and Drive there are Python examples.
Example Create a Spreadsheet, Download a Google Document.
There are also service that do this Google Drive and Google Sheets Integration if want to pay for this.

Also, if you use Google's Colab your (notebook style) program is stored in the Google Drive. Creating a spreadsheet is then relatively easy (think Pandas), and on the Welcome screen it has links to help work with Github, do machine learning in Tensorflow 2, good resources. It's free and because you are using Google's hosted runtime (switchable to local runtime) you can even run it on a Chromebook.

Link to colab

Legends. Thanks heaps for the advice lads