Hi everyone,
I’m working on a consumer portal in the German media market and looking to automate the production of news content as much as possible. I need help setting up an automated workflow in Zapier. Here’s what I’m aiming to achieve:
-
Time-based Trigger: The workflow should run daily at 9 AM, 1 PM, and 5 PM.
-
Content Source: Relevant content should be collected either through an RSS feed or, alternatively, via scraping.
-
Content Selection: The collected text should be filtered based on specific keywords (e.g., "supermarket," "recall," "Aldi," "Lidl"). The content should focus on topics with high traffic potential on Google (e.g., Google Discover) and social media. It should cover trending and relevant news topics that are often searched for by consumers.
-
ChatGPT: The text should be sent to ChatGPT, where it will be processed using a prompt (including generating an article image).
-
WordPress: The processed text should be saved as a draft post in WordPress.
-
Telegram Notification: I would like to receive a Telegram notification once the draft is ready.
Steps and Apps/APIs I believe are needed:
- Schedule by Zapier: For the time-based trigger.
- RSS by Zapier or a Web scraping tool (e.g., Scraptio): To gather the content from the relevant sources.
- Filter by Zapier: To ensure only content with the specified keywords is processed.
- OpenAI (ChatGPT): For content rewriting and generating an article image.
- WordPress: To create the draft post.
- Telegram: To send the notification once the post is ready.
If anyone has experience with setting up such workflows or can recommend specific tools or integrations, I’d greatly appreciate your help!
Thank you!