Generate weekly client FAQ updates using NewsAPI, GPT-4.1 and Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every week at 08:00). Along the way it connects Google Sheets and OpenAI. It also calls newsapi.org over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00).
- Fetch Market News (HTTP Request): calls newsapi.org
- Fetch Portfolio Data (Google Sheets) (Google Sheets): uses Google Sheets
- Check News Availability (If): checks a condition and branches into true / false
- Format Portfolio Summary (Edit Fields (Set)): sets 1 field: Portfolio
- Format Top News (Edit Fields (Set)): sets 1 field: Prepare News
- Fallback News Message (Edit Fields (Set)): sets 1 field: Prepare News
- Analyze Portfolio Risk & Loss (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Generate Client FAQs (AI) (OpenAI): uses OpenAI
- Extract FAQs (Structured Output) (Edit Fields (Set)): sets or maps fields
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: newsapi.org
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
Auto FAQ Generator for Clients using NewsAPI, OpenAI GPT-4.1 and Google Sheets This workflow automatically generates weekly client-ready investment FAQs by combining market news (NewsAPI) and portfolio data (Google Sheets) using OpenAI GPT-4.1. The final FAQs…