2

Is there a way to copy a Google Spreadsheet programatically using Python? I am using Gspread to manipulate my Google sheet, but there is no support for this functionality.

Any suggestions?

DBE7
  • 766
  • 2
  • 9
  • 23
  • 1
    https://developers.google.com/sheets/api/quickstart/python I suggest you use the official API – Micks Ketches Aug 09 '18 at 15:39
  • I’m kind of new to programming. Can you suggest a code example? Thanks – DBE7 Aug 09 '18 at 15:40
  • 1
    please go to the link I provided it has a step by step set of instructions and a basic code example of how to interface with google sheets. It also assumes you are using macOS or Linux shell. If you are on windows I suggest you use cygwin to have a similar shell. – Micks Ketches Aug 09 '18 at 15:49

2 Answers2

1

This library, pygsheets, for the new V4-API solved my problems.

The add_worksheet-method did the trick.

DBE7
  • 766
  • 2
  • 9
  • 23
0

There is a google drive API for this , you can find more details in this link