使用Python在指定Google Drive文件夹中创建Google表单的教程

# 替换为您的目标文件夹ID
target_folder_id = "YOUR_TARGET_FOLDER_ID"

# 文件元数据，指定名称、MIME类型和父文件夹
file_metadata = {
    "name": "我的新项目表单", # 这是在Drive中显示的文件名
    "mimeType": "application/vnd.google-apps.form",
    "parents": [target_folder_id]
}

try:
    # 创建文件，并请求返回文件ID
    created_file = drive_service.files().create(
        body=file_metadata,
        fields="id"
    ).execute()

    form_id = created_file.get("id")
    print(f"空白表单已在指定文件夹中创建，ID: {form_id}")

except Exception as e:
    print(f"创建表单文件时发生错误: {e}")
    form_id = None # 确保在出错时form_id为None

if form_id:
    # 构建更新请求体
    # 这里我们更新表单的标题和文档标题，并添加一个文本问题
    update_requests = {
        "requests": [
            {
                "updateFormInfo": {
                    "info": {
                        "title": "项目反馈表单", # 这是表单在Forms界面中显示的标题
                        "documentTitle": "项目反馈表单 - 2023 Q4" # 这是Drive中显示的文件名，与name一致更佳
                    },
                    "updateMask": "title,documentTitle"
                }
            },
            {
                "createItem": {
                    "item": {
                        "title": "您的姓名？",
                        "questionItem": {
                            "question": {
                                "textQuestion": {
                                    "paragraph": False
                                }
                            }
                        }
                    },
                    "location": {
                        "index": 0 # 在表单开头添加
                    }
                }
            },
            {
                "createItem": {
                    "item": {
                        "title": "您对本次项目的总体评价是？",
                        "questionItem": {
                            "question": {
                                "choiceQuestion": {
                                    "type": "RADIO",
                                    "options": [
                                        {"value": "非常满意"},
                                        {"value": "满意"},
                                        {"value": "一般"},
                                        {"value": "不满意"}
                                    ]
                                }
                            }
                        }
                    },
                    "location": {
                        "index": 1 # 在第一个问题之后添加
                    }
                }
            }
        ]
    }

    try:
        # 执行批量更新操作
        form_service.forms().batchUpdate(
            formId=form_id,
            body=update_requests
        ).execute()
        print(f"表单 '{form_id}' 内容已成功更新。")

    except Exception as e:
        print(f"更新表单内容时发生错误: {e}")
else:
    print("无法更新表单，因为表单ID无效。")

import os
from google.auth.transport.requests import Request
from google.oauth2.credentials import Credentials
from google_auth_oauthlib.flow import InstalledAppFlow
from googleapiclient.discovery import build

# --- 1. 认证和API服务构建 ---
SCOPES = [
    "https://www.googleapis.com/auth/drive.file",
    "https://www.googleapis.com/auth/forms.body"
]

creds = None
if os.path.exists("token.json"):
    creds = Credentials.from_authorized_user_file("token.json", SCOPES)
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(port=0)
    with open("token.json", "w") as token:
        token.write(creds.to_json())

drive_service = build("drive", "v3", credentials=creds)
form_service = build("forms", "v1", credentials=creds)

# --- 2. 定义目标文件夹ID ---
# 替换为您的目标文件夹ID
target_folder_id = "YOUR_TARGET_FOLDER_ID"
if target_folder_id == "YOUR_TARGET_FOLDER_ID":
    print("错误：请将 'YOUR_TARGET_FOLDER_ID' 替换为实际的Google Drive文件夹ID。")
    exit()

form_id = None
try:
    # --- 3. 通过Drive API在指定文件夹中创建空白Google表单 ---
    file_metadata = {
        "name": "我的新项目表单",
        "mimeType": "application/vnd.google-apps.form",
        "parents": [target_folder_id]
    }
    created_file = drive_service.files().create(
        body=file_metadata,
        fields="id"
    ).execute()

    form_id = created_file.get("id")
    print(f"空白表单已在指定文件夹中创建，ID: {form_id}")

    # --- 4. 通过Forms API填充和更新表单内容 ---
    if form_id: