Generate content ideas from social trends with Apify, Gemini, and Google Sheets

Trend2Content

This n8n workflow (named Trend2Content) takes a short topic input from a small web form, scrapes recent/top social content for that topic (via an Apify act), aggregates the raw text, passes that aggregated content into a LangChain AI agent (Google Gemini in this flow) which returns a structured content output (topic summary, blog post title ideas, tweet hooks), formats that output, and appends the results into a Google Sheet.

It’s a lightweight:

Topic → Trending Content → AI Ideas → Sheet

pipeline for fast content ideation.

---

How It Works (Step-by-Step)

1. On Form Submission The user fills a single field Topic (webhook/form trigger).