Google Trend Data Extract, Summarization with Bright Data & Google Gemini

For Google Trends, this automated workflow extracts and summarizes trend data using Bright Data and Google Gemini. It efficiently converts markdown data to structured text, summarizes insights, and sends results via Gmail, enabling users to quickly access and understand trending topics.

7/8/2025
16 nodes
Complex
kujft2fojmovqamjddpkw7hg5dzhqu2wmanualcomplexsticky notelangchainreadwritefilegmailadvancedapiintegrationcodecustomfilesstorage
Categories:
Communication & MessagingComplex WorkflowManual Triggered
Integrations:
Sticky NoteLangChainReadWriteFileGmail

Target Audience

This workflow is ideal for:
- Data Analysts looking to extract and summarize Google Trends data efficiently.
- Marketing Professionals who want to gain insights from trending topics on YouTube.
- Content Creators needing to stay updated with popular trends for their content strategy.
- Researchers interested in analyzing public interest over time using structured data from Google Trends.

Problem Solved

This workflow addresses the challenge of automating the extraction and summarization of Google Trends data. It eliminates the need for manual data collection and processing, ensuring that users can quickly access relevant information without the hassle of navigating multiple platforms.

Workflow Steps

  • Manual Trigger: The workflow begins when the user clicks 'Test workflow'.
    2. Set URL and Bright Data Zone: The workflow sets the target URL for Google Trends and specifies the Bright Data zone for web unlocking.
    3. Perform Bright Data Web Request: A web request is made to Bright Data to access the structured data from Google Trends.
    4. Markdown to Textual Data Extractor: The returned markdown data is converted into a textual format for easier processing.
    5. Structured Data Extractor: The textual data is processed to extract structured information in JSON format, focusing on key topics and descriptions.
    6. Summarize Google Trends: The extracted data is summarized using the Google Gemini Chat Model, providing concise insights.
    7. Initiate Webhook Notifications: Notifications are sent out for both markdown extraction and summarization results.
    8. Write the File to Disk: The structured data is saved as a JSON file on the local disk.
    9. Send Summary to Gmail: Finally, the summarized data is sent to a specified Gmail address for easy access and sharing.

    • Customization Guide

    Users can customize this workflow by:
    - Updating the URL: Change the URL in the 'Set URL and Bright Data Zone' node to target different Google Trends pages.
    - Modifying the Output Path: Alter the file path in the 'Write the file to disk' node to save the output file in a preferred location.
    - Adjusting Email Settings: Change the recipient email address in the 'Send Summary to Gmail' node to direct the summary to different users.
    - Tuning the Data Extraction Parameters: Users can modify the input schema in the 'Structured Data Extractor' node to focus on different aspects of the data as needed.