Scrape & Analyze Google Ads with Bright Data API and AI for Email Reports

This n8n workflow automates the process of scraping Google Ads data, analyzing it with an AI agent, and generating email reports. It's designed for marketers, analysts, or anyone who needs to monitor and understand Google Ads performance efficiently.

What it does

This workflow streamlines the following tasks:

1. Triggers Manually: The workflow is initiated manually, allowing for on-demand analysis.
2. Scrapes Google Ads Data: It uses an HTTP Request node to interact with the Bright Data API to scrape Google Ads data.
3. Prepares Data for AI Analysis: The scraped data is transformed and structured using Edit Fields (Set) and Code nodes to be suitable for AI processing.
4. Analyzes Data with AI Agent: A Basic LLM Chain and AI Agent (likely powered by Google Gemini or OpenRouter) analyze the Google Ads data, extracting key insights and identifying trends.
5. Structures AI Output: A Structured Output Parser ensures the AI's analysis is consistently formatted, likely into JSON.
6. Aggregates and Splits Data: Data is aggregated and then split into individual items for further processing.
7. Generates Email Reports: Based on the AI's analysis, it composes and sends detailed email reports via Gmail.
8. Handles Empty Results: Includes a filter to manage scenarios where no data is returned, preventing errors.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Bright Data Account & API Key: For scraping Google Ads data.
• Google Account (for Gmail): To send email reports.
• AI Model Credentials:
  • Google Gemini API Key OR
  • OpenRouter API Key: For the AI Agent and LLM Chain nodes.
• Google Sheets (Optional): While a Google Sheets node is present, its specific role isn't explicitly connected in the provided JSON. It might be for inputting keywords, storing results, or other related data.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the workflow JSON or upload the file.
2. Configure Credentials:
   • Locate the HTTP Request node and configure your Bright Data API credentials.
   • Locate the Gmail node and set up your Google OAuth2 credentials.
   • Locate the Google Gemini Chat Model or OpenRouter Chat Model nodes (depending on which you intend to use for the AI) and configure their respective API keys.
3. Review and Customize Nodes:
   • HTTP Request: Adjust the Bright Data API call parameters (e.g., target URLs, search queries) as needed for your specific Google Ads scraping requirements.
   • Code Node: Examine the JavaScript code to understand how data is being pre-processed for the AI. Customize if your input data structure differs.
   • AI Agent / Basic LLM Chain: Review the prompts and configurations within these nodes to ensure the AI performs the desired analysis and extracts relevant insights for your reports.
   • Structured Output Parser: If the AI output structure changes, you might need to adjust this parser.
   • Gmail: Customize the email subject, body, recipients, and content based on the AI's analysis.
4. Activate the Workflow: Once all credentials and configurations are set, activate the workflow.
5. Execute Manually: Click "Execute Workflow" on the Manual Trigger node to run the process.

This workflow provides a powerful foundation for automating Google Ads analysis and reporting, saving significant time and effort.