3. Loop Through the Files and Upload Them to Google Drive

Introduction

In the previous lesson, we created an array of file URLs using the Code Step. Now it’s time to process each file individually by looping through the array.

Using the Loop (For Each) step, we can download each file and upload it directly to a Google Drive folder. This approach works whether the user uploaded one file or hundreds of files—your workflow will automatically handle them all!

Step 1: Create a Google Drive Folder for the Files

Before we start looping through the files, let’s create a dedicated folder in Google Drive to store them. This folder will be dynamically named using the patient’s Name and Date of Birth, ensuring all files stay organized under the correct patient record.

How to Create the Folder:

1. Click the ➕ icon after the Code Step.

2. Select the Google Drive connector and choose the Create Folder action.
   

3. Configure the Folder Name field using dynamic data from the Jotform trigger:

   
4. Save and test the step to make the data of the folder available in your workflow and ensure that it works as expected.
   

Now that the folder is created, we’ll use it in the next step to store all uploaded files.

Step 2: Add a Loop (For Each) Step

1. Click the ➕ icon after the Google Drive / Create folder step.

2. Select For Each (Loop) from the Logic section.
   

3. Configure the Loop:

   • Input Array: Map this to the files output from your Code Step.

4. Save and Test the step: So each item from the array of files to be available inside the loop for further mapping to actions inside the loop. 

💡 Tip: The Loop will run once for each URL in the array. You can access the current item using the Loop Item variable in each step inside the loop.

Step 3: Download Each File

1. Inside the Loop, click ➕ Add to loop to add a new step.

2. Select the Jotform connector and the Download File from answer action.
   

3. Map the File URL to the current Loop Item—this contains the URL for the current file being processed.

4. Save the step.

   

5. Test the loop action again to download the files in Jotform and make their file URLs available for uploading to Google Drive.
   
   

    

   New File URLs

   As you can see from the test outputs, the "Download file from answer" step ran twice since there are two files in the form, and their ready-to-upload URLs became available in the workflow data.

   

Step 3: Upload the File to Google Drive

1. After downloading the file, add another step inside the loop.

2. Select the Google Drive connector and choose the Upload File action.
   

3. Map the Folder input to be the folder id variable that is available from our previous step "Create folder" action.

4. For the File input, map it to the URL variable that is available from the "Download file from answer" action inside our loop.
5. Save the step.

Step 4: Test the Loop

1. Select the "For Each" step in our workflow and click the "Test step" button for the loop to run once again and perform their inside actions.

2. Verify that each file is downloaded and uploaded successfully to Google Drive.

3. Check the Google Drive folder to confirm the files appear correctly.