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
2 Likes
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:

2 Likes