Google Trend Data Extraction, AI Summarization, and Reporting - n8n Workflow

Market researchers needing automated Google Trends data analysis.
Developers seeking advanced web scraping n8n templates for dynamic sites.
Users who want to integrate Google Gemini and advanced LLM Chains into their n8n workflow for complex data processing.
Business analysts requiring automated, summarized competitive intelligence reports delivered via email.

This specialized n8n workflow solves the complex challenge of reliably extracting and interpreting dynamic data from Google Trends. By using the Bright Data web unlocker service, this n8n node expertly bypasses common anti-bot measures, acquiring the raw trends content in markdown format. The true power of this automation lies in its subsequent AI processing steps, which employ the Google Gemini model via n8n’s Langchain-based nodes. This setup facilitates automated conversion of raw markdown into clean text, followed by the sophisticated extraction of structured trends data, and culminating in the creation of a succinct, actionable summary. This robust n8n template ensures that raw data is not only captured but transformed into usable business intelligence, ready for immediate reporting via Gmail and local file storage. Utilizing this advanced n8n workflow showcases modern data pipeline capabilities.

The n8n workflow begins execution with a manual n8n trigger, initiating the process when clicked:

1. Configuration: The "Set URL and Bright Data Zone" n8n node sets the target Google Trends URL and specifies the web_unlocker1 zone for Bright Data.


2. Data Acquisition: The "Perform Bright Data Web Request" n8n node executes an authenticated POST request to the Bright Data API, retrieving the Google Trends page data formatted as markdown.


3. Data Cleaning: The "Markdown to Textual Data Extractor" n8n workflow step uses a Google Gemini chat n8n node to clean the raw markdown output, ensuring only pure textual data remains, stripping out links or scripts.


4. Structured Extraction: The “Structured Data Extractor” n8n node utilizes the power of the Gemini LLM and a defined JSON schema (topics, desc) to pull specific, structured information from the cleaned text. This is a critical AI step in the n8n automation.


5. Data Storage: The resulting structured JSON is converted into a binary object using a Function n8n node and then saved locally as a JSON file via the "Write the file to disk" n8n node.


6. Summarization: The "Summarize Google Trends" n8n node uses a robust summarization chain powered by another instance of the Google Gemini n8n node to generate a high-level, easy-to-digest summary of the extracted data.


7. Reporting: The final AI-generated summary is sent out via email using the Gmail n8n node and also logged to a webhook URL, concluding this complex n8n workflow.

To deploy this specialized n8n workflow, follow these steps:

1. Import Template: Copy the provided n8n workflow JSON and paste it into your n8n instance using the "New" -> "Import from JSON" option.


2. Bright Data Credentials: Configure the HTTP Header Auth credential linked to the "Perform Bright Data Web Request" n8n node. This requires your Bright Data API key/password.


3. Google Gemini Credentials: Set up the Google Gemini (PaLM) Api account credential. This single credential must be applied to all three Google Gemini Chat Model n8n node instances used for data cleaning, extraction, and summarization.


4. Gmail Credential: Configure your Gmail OAuth2 credential for the "Send Summary to Gmail" n8n node to enable sending the final report.


5. Customization: Review the "Set URL and Bright Data Zone" n8n node to confirm the target URL. Update the recipient email address in the "Send Summary to Gmail" n8n node.


6. Testing: Activate the n8n workflow and use the manual n8n trigger to test the end-to-end data pipeline.

When clicking ‘Test workflow’ (Manual Trigger n8n trigger): This simple n8n trigger starts the entire automation.
Set URL and Bright Data Zone (Set n8n node): Key configuration defining the target web property (url) and the specific Bright Data web unlocker zone.
Perform Bright Data Web Request (HTTP Request n8n node): Handles the external request to the Bright Data API, using HTTP Header Auth and requesting the Google Trends page content in markdown format.
Markdown to Textual Data Extractor (Chain LLM n8n node): A core AI step that uses Google Gemini (models/gemini-2.0-flash-exp) to clean and refine the raw markdown into pure, unstructured text.
Structured Data Extractor (Information Extractor n8n node): An advanced n8n node leveraging Gemini to convert the cleaned text into structured JSON data based on a predefined schema (for topics and desc).
Summarize Google Trends (Summarization Chain n8n node): Uses another Gemini model instance to intelligently summarize the extracted trends data, providing concise, actionable insights.
Create a binary data (Function n8n node): A custom JavaScript n8n node function converting the final JSON output into binary format for file writing.
Send Summary to Gmail (Gmail n8n node): The final output n8n node, sending the AI-generated summary directly to a specified recipient.