I’m trying to automate a weekly linkedin post. The idea is that I only want to tag 5 articles I like on Inoreader and send automatically title and corresponding link to a google sheet. So far so good. The issue starts here: if I use Google sheets “search row” it returns one output with 5 bubdles (that’s still good!!) but once connected to Gemini, the latter cannot give me back one operation only contaning all the 5 titles and links in one simpke and unique post. Instead, Gemini runs 5 operations for each title and corresponding link.
Can someone help me out please??
P.s. also struggling to have one single scenario to do it all: so far I have the first two steps (Inoreader list articles and Google sheets add rows) in one scenario and the rest (G Sheets search rows and Gemini) in another scenario.
I paste the prompt for gemini below:
Imagine creating a unique post for LinkedIn using only the headlines and links provided to you by a Google Sheet.
Don’t search for articles on the net: just use the data provided.
The post must include:
A short introduction (without an end sentence).
A list of 5 titles and their links, each preceded by a hyphen ‘-’, in which the following data must be present:
- column Link: {{1.
0}} (NOTE: here I mapped the Link column from google sheet and below the same with title)
- Title column: {{1.
1}}
Make sure that there are exactly 5 different titles and 5 corresponding links, and that the post contains a maximum of 3 hashtags in total.
Hey Emanuele,
you need an Aggregator module to combine the bundles from the previous modules in a single array. Then use that to pass the info to Gemini and get only one result.
Also the part about having two separate scenarios - what exactly is the flow? Do you add stuff to the table throughout the week and then get the 5 latest items once a week for the post?
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of four modules:
This is just an example. Your final solution may or may not look like this depending on your requirements.
Combining Bundles Using Aggregators
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, 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. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
Example
Here is an example of how your scenario could look:
This is just an example. Your final solution may or may not look like this depending on your requirements.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hey Stoyan, thanks, now using an aggregator (source from inoreader) I feel like I’m close to the final solution.
I mentioned the fact of using two scenarios because I managed to achieve the result expected using two different scenarios (even if not really needed for my objective) only because, technically, it was working without an aggregator.
hey @samliew thanks a lot for the help and the comprehensive explanation!! I feel like I’m close to the final solution now.
Emanuele
