Create a new IG post from google drive

Hi everyone,
I’m new (just completed make academy) and I’m trying to automate my social media posting.
My goal is to take a random photo from the google drive folder, place it in a google sheets and then create a post for IG & FB.

Do far I’ve tried to setup a google drive module (not sure if I should use “Search for files”) and then set a “random” way to get the random file or I should have “tools” module first? and then place it in a row in a spreadsheet and then post. (I might add chat gpt to create a caption)

My main issue is how to get a photo collected from Google drive and pasted into Google sheets.

Any help is massively appreciated:)

Thanks, Oksana