How to automatically upload multiple pictures from Google Drive?

[Paulo]

Hi all, I'm new to AppSheet and I need your help!

I have an app with tables from Google Spreadsheet, one of them with a image collumn. I already have +5,000 rows with data (like name, address, phone number, email, profile photo, etc) from another database that I want to reuse. Copy and paste worked fine for all the collumns, except the image column for profile photo. I have all the images uploaded in a folder in the same Google Drive, and I need to find a way to create a link for each photo in the image column to make the profile photos appear automatically in each record, otherwise I'll need to upload +5,000 photos in the app one by one. Is there a way to do this or I'm stuck with the one by one image upload?

Thanks in advance!