📊 Generate SEO-optimized titles & meta descriptions with Bright Data & Gemini AI
⚡ 1,622 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
What does this workflow do?
This workflow helps speed up the analysis process of the top ranking titles and meta descriptions to identify paterns and styles that will help us rank on Google for a given keyword
How does it work?
We provide a keyword we are interested in on our Google sheet. When executed, We scrap the top 10 pages using Bright Data serp API and analyse the style and patterns of the top ranking pages and generate a new title and meta description
Techncial setup
- Make a copy of this Google sheet
- Update your desired keywords on the cell/row
- Set your Bright data credentials on the
Fetch Google Search Results JSONnode - Update the
zoneto your preset zone - We are getting the results as a JSON. You can update this setting on the url
https://www.google.com/search?q={{ $json.search_term .replaceAll(" ", "+")}}&start=0&brd_json=1by removing the brd_json=1 query - Store the generated results on the Duplicated sheet
- Run the workflow
Setting up the Serp Scraper in Bright Data
- On Bright Data, go to the Proxies & Scraping tab
- Under SERP API, create a new zone
- Give it a suitable name and description. The default is serp_api
- Add this to your account
- Add your credentials as a header credential and rename to
Bright data API
🔗 Nodes Used
Google Sheets, HTTP Request, AI Agent, Structured Output Parser, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File