Track Local Search Trends from Google Trends into Sheets

## 🎯 📍 Title: “Local Trends Scraper & SEO Booster — Automated Google Trends to Sheets Workflow” --- ### ## 🟢 SECTION 1 — 🚀 Trigger & Input: “Set the Mission” ✨ Nodes in this section: 1️⃣ 🔌 Trigger: Manual Start 2️⃣ 📝 Set Region & Topic --- ### 🎯 What happens here? * Purpose: This section is your *starting point*. It lets *you* (or anyone using this workflow) decide when to run it and what you want to search for. * How it works: * The 🔌 Trigger node is like a *button*. When you click *Execute Workflow*, the whole process starts. * The 📝 Input Fields node lets you fill in details — for example: * *Region:* “Los Angeles” * *Topic:* “Restaurants”, “Concerts”, “Events near me” * These inputs tell the Agent exactly which local trends to scrape. * Benefit for beginners: You don’t need to open Google Trends manually or copy-paste URLs — just set your target location & topic once, click a button, and you’re good to go! 🌍✨ --- --- ### ## 🟡 SECTION 2 — 🤖 Scrape Trends with Bright Data MCP ✨ Nodes in this section: 3️⃣ 🤖 Scrape Trends with MCP * Sub-nodes: * 🧠 OpenAI Model → Handles the Agent’s logic & instructions * 🌐 Bright Data MCP → Runs the actual scraping * 🗂️ Structured Output Parser → Makes sure the data comes back clean JSON --- ### 🎯 What happens here? * Purpose: This section is the *smart engine* of your workflow. It sends your search request out to the internet, collects the latest local trending keywords, and puts them in a neat, structured format. * How it works: * The 🤖 Agent takes your region & topic and talks to Bright Data MCP — your web scraper. * Bright Data crawls Google Trends (or another site) and finds hot keywords, interest scores, and when they started trending. * The Structured Output Parser makes sure the raw text is turned into tidy, machine-readable JSON — so you don’t need to clean up messy data yourself. * Benefit for beginners: You don’t have to write scraping code or build a custom parser. The Agent + Bright Data MCP do it all. It’s like having a digital research assistant that never sleeps. 🧑‍💻🔍 --- --- ### ## 🟣 SECTION 3 — 🧩 Process & Save: “Put it to Work” ✨ Nodes in this section: 4️⃣ 🧩 Split Trends (One per Item) 5️⃣ 📄 Save to Google Sheets --- ### 🎯 What happens here? * Purpose: This section *unpacks* the scraped data and *u