Python Forum
PYTHON - GOOGLE... create new spreadsheet?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PYTHON - GOOGLE... create new spreadsheet?
#1
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 Wall Smile
Reply
#2
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.
Reply
#3
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
Reply
#4
Legends. Thanks heaps for the advice lads
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Returning Column and Row Data From Spreadsheet knight2000 0 412 Oct-22-2023, 07:07 AM
Last Post: knight2000
  Editing spreadsheet/csv BSDevo 6 969 Sep-01-2023, 05:47 PM
Last Post: BSDevo
  Looking to automate updating a spreadsheet with image from email cubangt 2 943 Feb-14-2023, 03:43 PM
Last Post: cubangt
  Import XML file directly into Excel spreadsheet demdej 0 798 Jan-24-2023, 02:48 PM
Last Post: demdej
  (Python) Pulling data from UA Google Analytics with more than 100k rows into csv. Stockers 0 1,170 Dec-19-2022, 11:11 PM
Last Post: Stockers
  updating Google spreadsheet with gspread mgallotti 0 1,049 Sep-30-2022, 11:26 PM
Last Post: mgallotti
  Modify LibreOffice's ods spreadsheet Pavel_47 0 1,146 Jul-13-2022, 11:28 AM
Last Post: Pavel_47
  Python create a spreadsheet with column and row header ouruslife 4 1,545 Jul-09-2022, 11:01 AM
Last Post: Pedroski55
  Deploy Python to Cloud and save output to Google Drive chandrabr80 2 1,522 Jan-25-2022, 06:56 AM
Last Post: ndc85430
  install apache-airflow[postgres,google] on Python 3.8.12 virtual env ShahajaK 1 6,325 Oct-07-2021, 03:05 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020