You can automatically summarize or analyze articles from any website using RSS.app, n8n, and ChatGPT. This workflow collects the latest articles, sends them to ChatGPT for analysis, and saves the results in Google Sheets.
Prerequisites
Step 1: Generate RSS feeds with RSS.app
1. Go to RSS Generator.
2. Paste the URL of the content you want to turn into a feed (e.g. a Twitter profile, subreddit, or blog).
3. Click Generate.
4. Once your feed is ready, click Save to My Feeds.
5. Copy the generated XML URL.
You can apply filters, adjust Feed Output settings, or create multiple feeds and combine them into a single stream using our Bundles feature.
Step 2: Set up OpenAI API access
1. Go to platform.openai.com.
2. Open the API Keys page and click Create new secret key.
3. If you’re using the API for the first time, add a small credit balance in the Billing section to activate token usage.
4. Copy your secret key.
Step 3: Add an RSS Feed Trigger in n8n
1. Click Create Workflow in your n8n dashboard.
2. Click the + button and search for RSS Feed Trigger.
3. Choose how often you want n8n to check your feed for updates by setting the Poll Time.
4. Paste the RSS.app feed URL and click Fetch Test Event.
n8n will fetch the latest feed items according to your poll time.
Step 4: Add a Google Sheets Action Node
1. Click the + button and search for Google Sheets.
2. Choose the Append or update row in sheet option.
3. Click on Credential to connect with and connect your Google account.
4. Select the document and sheet where you'd like to upload the RSS feed data.
5. Map the fields from the RSS feed to the columns:
6. Click Test Step to verify that everything works as expected. The fields you mapped should automatically appear in your Google Sheet.
Step 5: Add a ChatGPT node for analysis
1. Add an OpenAI node to the workflow.
2. Open the Credentials window and paste your OpenAI API key.
3. In the Operation field, select Message a model.
4. Choose your preferred model.
5. In the Prompt field, paste your custom instruction depending on the kind of analysis you want.
6. Map the fields from the previous node (for example, Title, Description, Link) so ChatGPT has all the context it needs.
7. Click Execute Step to confirm it’s working.
Step 6: Add a Google Sheets node for AI results
1. Add another Google Sheets node.
2. Connect it to the same spreadsheet but use a second sheet, such as AI_Analysis.
3. Map the fields you want to include from the RSS feed or ChatGPT results.
4. Click Execute Step to test. The AI-generated summary should appear in your sheet.
Step 7: Run and activate the workflow
1. Click Execute Workflow to run everything together.
2. Toggle the Active button to turn on the workflow.
3. Check the Executions tab anytime to see your workflow history.
