Make automation of posting on social media + GPT

Automation goal:
Collects a pool of information from various sources, processes it, and generates content based on pre-set keywords, sorts it by networks, adds images, descriptions, hashtags, keywords, and posts it on social networks.

I have created two scenarios, the second scenario has been added to the portfolio for clarity.
In the first scenario, I used RSS to collect news from different sources on one topic, filtered them, and passed them to GPT, then output the responses to various Google Sheet pages.
In the second scenario, the Hootsuite service was used for auto-posting at scheduled times.