Detailed Project Overview
1. Completed Work:
-
Infrastructure: I have a self-hosted n8n environment running via Docker/Portainer (
gbn-automationstack) on a VPS. My instance is live and stable. -
Workflow Architecture: The core logic is already mapped out in n8n. I have placed the following nodes:
Schedule Trigger,RSS Read,Limit,OpenAI (Message a Model), andGoogle Sheets (Append Row). -
Integrations: Basic credentials for Google Sheets and OpenAI have been initiated.
2. Assistance Needed:
-
Data Mapping & Connections: I am experiencing some UI/UX difficulties in connecting the
RSS Readoutput to theLimitnode and ensuring the data schema flows correctly into the OpenAI node. -
Prompt Engineering: I need help refining the OpenAI prompt to generate high-quality, YouTube-ready news summaries from the RSS descriptions.
-
Data Formatting: Ensuring the output from the AI is correctly parsed into specific columns in Google Sheets (e.g., Date, Title, Summary, Source URL).
-
Error Handling: Implementing “Wait” or “Error” nodes to ensure the workflow doesn’t break if an RSS feed is temporarily down or the AI API hits a limit.
-
Future Expansion: Guidance on eventually connecting this to a video creation tool or the YouTube API directly once the script-saving process is perfect.
Objective: I am looking for an expert to spend a few hours with me (or asynchronously) to “clean up” the connections, verify the data mapping, and ensure the workflow runs 100% reliably from start to finish.