Turn trending topics into ready to use ideas without manual research. The flow watches Google Trends, pulls the linked articles, builds a short summary, and saves everything into a Google Sheet for your editorial plan. It fits content teams, SEO shops, and newsrooms that need fresh topics fast.

On a schedule, the flow calls the Google Trends RSS feed, converts XML to JSON, and loads simple settings like min traffic and max results. It loads your existing ideas from Google Sheets, then filters out keywords already saved or below your traffic threshold. For each new topic, it scrapes up to three linked pages through Jina AI, merges the text into one clean summary, and writes a new row with status set to idea. A check step makes sure at least one page scraped well before saving.

Setup is simple. You need a Google Sheets account and a Jina AI API key, plus a target sheet with the columns you want to track. Pick your min traffic and the sheet to write to, then test with the manual trigger and switch on the schedule. Expect faster topic scouting, fewer duplicates, and a steady feed of fresh ideas for blogs, newsletters, and social posts.

• Hourly schedule and manual run options for flexible control
• HTTP request to Google Trends RSS and XML to JSON conversion
• Config node sets min traffic, max results, and the Jina AI key
• Reads existing rows from Google Sheets to avoid duplicates
• Code node filters results by traffic and compares with saved keywords
• Scrapes up to three article links with Jina AI and merges the text
• Checks that at least one scrape worked before appending to Google Sheets

• Reduce topic research from hours to minutes by watching Google Trends on autopilot
• Automate up to 80% of idea scouting with traffic filters and dedupe logic
• Improve data quality by removing repeats and only saving valid summaries
• Unify three news sources into one clear summary for faster editorial review
• Scale to dozens of topics per day without extra team effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets, Jina AI and Google Trends. See the Tools Required section above for links to create accounts with these services.
3. In n8n, open the Google Sheets nodes. In the Credential to connect with field, click Create new credential and follow the prompts to sign in with Google using OAuth2. Give the credential a clear name like Google Sheets Editorial.
4. Create a Google Sheet with a main tab for your ideas. Include columns for status, pubDate, abstract, approx_traffic, keyword, and the three link fields if you want to store them.
5. In the Google Sheets nodes, choose your Document and set the Sheet to gid=0 or your target tab. Keep the operation as Append.
6. Get your Jina AI API key from your Jina AI account page. Copy the key.
7. Open the CONFIG node. Set min_traffic to your threshold like 500, set max_results to limit how many RSS items you process, and paste the Jina AI key into the jina_key field.
8. Open the GoogleTrends request node and confirm the RSS URL is correct for your region. The example uses https://trends.google.it/trending/rss?geo=IT.
9. Run the Manual trigger to test. Check the Execution log and verify that the XML step returns items and that at least one content scrape returns text.
10. Open the Google Sheets node output and confirm new rows appear with status set to idea and a merged summary. If no rows are added, check the New keywords node filter and your min_traffic value.
11. Enable the Schedule trigger. Confirm the cron expression runs every hour at minute 11. Watch one full cycle and review the sheet for new entries.
12. Troubleshooting: If scraping fails with 401, recheck the Jina AI key. If the Google Sheets node errors, ensure your Google account has edit access to the sheet. If no items pass, lower min_traffic or increase max_results.