<p>有一种更容易理解的方法。安装Python和Gam后,您可以运行一个脚本,在csv文件中使用google drive中的文件id导出列表中的所有文档。一旦安装了python和gam,就需要安装一些模块,脚本才能正常工作。运行脚本时,可以通过谷歌搜索错误代码,查看Python中需要安装的内容。此外,您还需要创建一个api凭据服务帐户,并在脚本中的两个位置用替换该帐户名。使用脚本名为script.py的以下命令以管理员身份运行cmd。“C:\Users\dcahoon\AppData\Local\Programs\Python\Python38\Python.exe C:\GAM\SCRIPT.PY**SCRIPT start</p>
<pre><code>import os
import subprocess
from csv import writer
from csv import reader
# path to googleidlist.csv
csvfile = 'c:\\GAM\\googleidlist.csv'
destination = 'c:\\GAM\\OUTPUT\\' #Destination for downloaded documents
# Open the input_file in read mode and output_file in write mode
with open(csvfile, 'r') as read_obj, \
open('output_1.txt', 'w', newline='') as write_obj:
# Create a csv.reader object from the input file object
csv_reader = reader(read_obj)
# Create a csv.writer object from the output file object
csv_writer = writer(write_obj)
# Read each row of the input csv file as list
for row in csv_reader:
file_id = row[0]
outcome = subprocess.Popen(['gam', 'user', 'googleserviceaccountname', 'get', 'drivefile', 'id', file_id, 'targetfolder',destination], stdout=subprocess.PIPE)
# os.system("gam user david.bruinsma@colonialmed.com show fileinfo "+ file_id + "name")
filename = subprocess.Popen(['gam', 'user', 'googleserviceaccountname', 'show', 'fileinfo', file_id, 'name' ], stdout=subprocess.PIPE)
output = outcome.stdout.readline()
file_name = filename.stdout.readline()
print(output)
# Append the default text in the row / list
# row.append(filename)
row.append(output)
row.append(file_name)
row.append(file_id)
# Add the updated row / list to the output file
csv_writer.writerow(row)
</code></pre>