How to create automation which it will randomly select picture from Google drive/car/

I’m creating a content. prompt content using ChatGpt,

everyday will different content and different image

i’m have lot of car pictures on Google drive/car/

how to create automation which it will randomly select picture from Google drive/car/

sunday select Car-a.jpeg
monday select Car-b.jpeg
tuesday select Car-c.jpeg

Thank you

The easiest way would be to have a speadsheeet which contains a column for a number and a column with the (shareable) link to the car picture.

Then, use the random function to get the number and get the file from Google Drive:

image

The random function returns a number between 0 and 1 so you would need to multiply that by the number of items you have.

So something like

ceil(random * 10) would give you a number between 1 and 10.

L

if i want to do this automation, which module and which action i should pick?

:pray: :pray:

You can probably use the flow you already have. Use the Google SHeets module to locate the row you want using the random value (which works in any module) like I explain above.

Then you can use Google Drive to download the image file and publish it in your Gmail or LinkedIn or Facebook page.

L