Automated Local Trends Scraper & Google Sheets Logger

somdn_product_page

This n8n workflow automates the process of monitoring local search trends by scraping Google Trends data, extracting trending keywords, and storing them in a Google Sheet for easy analysis and SEO planning. Starting with a manual trigger, users can specify a region and topic, which directs the workflow to scrape the latest trending keywords using Bright Data MCP (a web scraping service). The scraped data is then processed, unpacked, and saved in a structured format in Google Sheets. This automation is ideal for content creators, SEO specialists, and marketing teams seeking real-time insights into local search behaviors. It streamlines trend monitoring, eliminates manual data collection, and helps optimize local marketing strategies.

Node Count

11 – 20 Nodes

Nodes Used

@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.outputParserAutofixing, @n8n/n8n-nodes-langchain.outputParserStructured, code, googleSheets, manualTrigger, n8n-nodes-mcp.mcpClientTool, set, stickyNote

Reviews

There are no reviews yet.

Be the first to review “Automated Local Trends Scraper & Google Sheets Logger”

Your email address will not be published. Required fields are marked *