AppMaker中能否通过Drive Picker在用户/Team Drive创建文件夹并上传文件？

Absolutely, this workflow is totally feasible—lots of developers have built similar systems for organizing user files tied to database entries! Let’s walk through how to make this work, plus fix that DriveApp.addFolder issue you hit.

Is This Use Case Possible? #

Short answer: Yes. Google’s Drive APIs (including Apps Script’s DriveApp and the full Drive REST API) combined with Drive Picker fully support:

• Creating folders in a user’s personal Drive or a Team Drive
• Restricting Drive Picker uploads to that specific folder
• Linking the folder and uploaded files to your driver database entries

Fixing Your DriveApp.addFolder Problem #

Chances are, you used addFolder() incorrectly—this method is for adding an existing folder as a shortcut to another folder, not creating a new one. To make a new folder, use createFolder() instead.

Example: Create Folder in User’s Root Drive #

function createDriverFolder(licenseNumber) {
  try {
    // Creates a folder directly in the user's My Drive
    const newFolder = DriveApp.createFolder(licenseNumber);
    console.log(`Folder created with ID: ${newFolder.getId()}`);
    return newFolder.getId(); // Save this ID to link with your database entry
  } catch (error) {
    console.error(`Failed to create folder: ${error.message}`);
    throw error; // Handle this in your database logic as needed
  }
}

Example: Create Folder in a Team Drive #

If targeting a Team Drive, you need to specify the root folder ID of the Team Drive first, and ensure your script has permission to modify it:

function createTeamDriveDriverFolder(licenseNumber, teamDriveRootId) {
  try {
    const teamDriveRoot = DriveApp.getFolderById(teamDriveRootId);
    const newFolder = teamDriveRoot.createFolder(licenseNumber);
    console.log(`Team Drive folder created: ${newFolder.getId()}`);
    return newFolder.getId();
  } catch (error) {
    console.error(`Team Drive folder error: ${error.message}`);
    throw error;
  }
}

Integrating Drive Picker to Upload to the Created Folder #

Once you have the folder ID, you can configure Drive Picker to let users upload files directly into that folder. Here’s how to set this up (works for web apps or Apps Script HTML services):

1. First, enable the Drive API in the Google Cloud Console, create an API key and OAuth client ID, and configure your OAuth consent screen.
2. Use this frontend code to launch the picker restricted to your target folder:

<script src="https://apis.google.com/js/api.js"></script>
<script>
  // Initialize Picker with the target folder ID
  function launchUploadPicker(targetFolderId) {
    gapi.load('picker', () => {
      const picker = new google.picker.PickerBuilder()
        .addView(new google.picker.DocsUploadView()) // Enable upload view
        .setParentIds([targetFolderId]) // Force uploads to this folder
        .setOAuthToken(gapi.auth.getToken().access_token) // Use user's OAuth token
        .setDeveloperKey('YOUR_GOOGLE_CLOUD_API_KEY')
        .setCallback(handleUploadSuccess)
        .setEnableTeamDrives(true) // Include this if using Team Drives
        .build();
      picker.setVisible(true);
    });
  }

  // Handle successful upload
  function handleUploadSuccess(pickerResponse) {
    if (pickerResponse.action === google.picker.Action.PICKED) {
      const uploadedFile = pickerResponse.docs[0];
      console.log(`File uploaded: ${uploadedFile.name} (ID: ${uploadedFile.id})`);
      // Send this file ID back to your backend/database to link with the driver entry
    }
  }
</script>

If you’re using Apps Script’s Web App, make sure to handle OAuth authorization properly (use ScriptApp.getOAuthToken() to pass the token to the picker).

Key Notes for Team Drives #

• Ensure your app/script has at least Editor access to the Team Drive.
• In Apps Script, go to Project Settings > Check "Enable Team Drive support" to allow access.
• The Drive Picker requires setEnableTeamDrives(true) to interact with Team Drives.

Troubleshooting Common Issues #

• Permission Errors: Double-check your OAuth scopes—you’ll need at least https://www.googleapis.com/auth/drive or https://www.googleapis.com/auth/drive.file (for app-created files only).
• Folder Not Visible: If the folder doesn’t show up, confirm the user has access to the parent Drive/Team Drive, and that the folder was created under the correct parent.
• Drive Picker Not Loading: Verify your API key is correctly linked to your project, and that the OAuth token has the necessary Drive permissions.

内容的提问来源于stack exchange，提问作者JingleBells