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

Welcome to the Make community!

Every result (item/record) from a search module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module.

Once you have the results in an array, you can use the built-in get function with the special random variable to get a random item from the array.

If you need further assistance, please provide the following:

  • explain why you need to use the Google Sheets module

That looks like a new question, could you please create a separate topic for this?

While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.

The “New Topic” link can be found in the top-right of the header:



ok my bad, i just did that. Creating a datetime filter for dropbox