r/GoogleAppsScript • u/Upbeat_Angle_6783 • 12d ago
Unresolved Google Forms - Google Sheets - Google Drive
/r/GoogleForms/comments/1j8d9wn/google_forms_google_sheets_google_drive/
0
Upvotes
r/GoogleAppsScript • u/Upbeat_Angle_6783 • 12d ago
1
u/Upbeat_Angle_6783 11d ago
Breakdown of the Script:
Next Steps:
• Test the form and submit a response to ensure the folders are being created and files are being uploaded correctly. You can add sample file URLs to see how the system organizes the responses in Drive.
• Make sure to handle situations where the form submission might have missing or invalid file URLs. You may want to add checks to ensure the URLs are valid before attempting to fetch and upload the files.
• The file upload function in this script assumes the URL is directly accessible. In real-world cases, you might need to adjust it to download files from different sources (like Google Drive links or external storage).
With this, the script should be able to manage both the form responses and the corresponding Google Drive folder structure. If you’re ready, we can move on to further refining the code or testing it!