tpal94 · April 25, 2020 06:29 · Apr 25, 2020
diff --git a/Copy.py b/Copy.py
@@ -0,0 +1,35 @@
+def copy_new_sheet():
+    """Shows basic usage of the Docs API.
+    Prints the title of a sample document.
+    """
+    creds = None
+    # The file token.pickle stores the user's access and refresh tokens, and is
+    # created automatically when the authorization flow completes for the first
+    # time.
+    if os.path.exists('token.pickle'):
+        with open('token.pickle', 'rb') as token:
+            creds = pickle.load(token)
+    # If there are no (valid) credentials available, let the user log in.
+    if not creds or not creds.valid:
+        if creds and creds.expired and creds.refresh_token:
+            creds.refresh(Request())
+        else:
+            flow = InstalledAppFlow.from_client_secrets_file(
+                'credentials.json', SCOPES)
+            creds = flow.run_local_server()
+        # Save the credentials for the next run
+        with open('token.pickle', 'wb') as token:
+            pickle.dump(creds, token)
+
+    drive_service = build('drive', 'v3', credentials=creds)
+
+    body = {
+        'name': CURRENT_DATE_TIME,
+        'parents': [DESTINATION_FOLDER_ID]
+    }
+
+    drive_response = drive_service.files().copy(
+        fileId=MASTERSHEET_ID, body=body).execute()
+    sheet_id = drive_response.get('id')
+
+    return sheet_id
No results found