Dvir Sharon
Templates by Dvir Sharon
Generate content ideas with Gemini Pro and store in Google Sheets
Automated Content Idea Generation and Expansion with Google Gemini and Google Sheets This n8n workflow automates the process of generating content ideas based on a user-defined topic, then expands each idea into a more detailed content piece (like a blog post) using Google Gemini, and finally saves all the generated data (idea title, description, and full content) into a Google Sheet. It's a powerful tool for streamlining content creation workflows. This workflow includes: Generation of multiple content ideas from a single topic. Expansion of each idea into detailed content using AI. Storage of ideas and generated content in a structured Google Sheet. Sticky Notes within the workflow for inline documentation and setup guidance. Prerequisites n8n Instance: You need a running n8n instance (self-hosted or cloud). Google AI Account: Access to Google AI (Gemini). You will need an API key. Google Account: Access to Google Sheets. You will need to create or use an existing spreadsheet with specific column headers. Installation and Setup Import the Workflow: Copy the entire JSON code provided. In your n8n instance, go to "Workflows". Click "New" -> "Import from JSON". Paste the JSON code and click "Import". Configure Credentials: Google AI (Gemini): Find the "Google Gemini Chat Model for Content Idea Generator" node and the "Google Gemini Chat Model for Content Generation" node. Click on the "Credentials" field in both* nodes (it will likely show a placeholder name like "Google Gemini(PaLM) Api account"). Click "Create New". Select "Google AI API". Enter your Google AI API Key. Save the credential. (You can reuse the same credential for both nodes). Google Sheets: Find the "Google Sheets" node. Click on the "Credentials" field (it will likely show a placeholder name like "Google Sheets account"). Click "Create New". Select "Google Sheets OAuth2 API". Follow the steps to connect your Google Account and grant n8n access to Google Sheets. Save the credential. Configure Google Sheets Node: Open the "Google Sheets" node settings. Spreadsheet ID: Replace the placeholder value with the actual ID of your Google Sheet. You can find the Spreadsheet ID in the URL of your Google Sheet (it's the long string of characters between /d/ and /edit). Sheet Name: Select or enter the name or GID of the sheet within your spreadsheet where you want to save the data (e.g., Sheet1 or gid=0). Columns: Ensure your Google Sheet has columns named title, description, and content. The node is configured to map the generated data to these specific column headers. Save the node settings. Review Sticky Notes: Look at the Sticky Notes placed around the workflow canvas. They provide helpful context and reminders for setup, required Google Sheet columns, and the AI models used. How to Use Activate the Workflow: Toggle the workflow switch to "Active". Trigger the Workflow: Since this workflow uses a "When clicking ‘Execute workflow’" node as the trigger, you can run it directly from the n8n editor. Click the "Execute Workflow" button. The workflow will start automatically. Set the Topic: Open the "Set the input fields" node. Modify the topic value to the subject you want to generate content ideas about. Save the node settings. Monitor Execution: Watch the workflow execute. The nodes will light up as they process. The "Loop Over Items" node will show multiple executions as it processes each generated idea. Check Results: The generated content ideas (title, description) and the expanded content will be written as new rows in the Google Sheet you configured. Each row will correspond to one generated idea and its content. This workflow provides a robust starting point for AI-assisted content creation. You can customize the AI prompts in the "Content Idea Generator" and "LLM Content Generator" nodes to refine the output style and format, or integrate additional steps like sending notifications or further processing the generated content.
By Dvir SharonDiscover & analyze TikTok influencers with Bright Data, Claude AI & email outreach
🎯 Automated TikTok Influencer Discovery & Analysis A complete n8n automation that discovers TikTok influencers using Bright Data, evaluates their fit using Claude AI, and sends personalized outreach emails. Designed for marketing teams and brands that need a scalable, intelligent way to find and connect with relevant creators. --- 📋 Overview This workflow provides a full-service influencer discovery pipeline: it finds TikTok profiles using search keywords, uses AI to assess alignment with your brand, and initiates contact with qualified influencers. Ideal for influencer marketing, brand partnerships, and campaign planning. --- ✨ Key Features 🔍 Keyword-Based Discovery Locate TikTok influencers by specific niche-related keywords. 📊 Bright Data Integration Access accurate TikTok profile data from Bright Data’s datasets. 🤖 AI-Powered Analysis Claude AI evaluates each profile's fit with your brand based on bio, content, and more. 📧 Smart Email Notifications Sends tailored outreach emails to creators deemed highly relevant. 📈 Data Storage Google Sheets stores profile details, AI evaluation results, and outreach status. 🎯 Intelligent Filtering Processes only influencers who meet your criteria (e.g., 5000+ followers, industry match). ⚡ Fast & Reliable Uses professional scraping with robust error handling. 🔄 Batch Processing Supports bulk influencer processing through a single automated flow. --- 🎯 What This Workflow Does Input Search Keywords – TikTok terms for finding niche creators Business Info – Brand description and industry Collaboration Criteria – Follower count minimum, niche alignment Processing Steps Form Submission TikTok Discovery via Bright Data Data Extraction and Normalization Save to Google Sheets Relevance Scoring via Claude AI Filtering Based on AI Score + Follower Count Personalized Email Outreach Output Data Points | Field | Description | Example | |---------------|------------------------------------|----------------------------------| | Profile ID | TikTok profile identifier | tiktoker123456 | | Username | TikTok handle | @creativecreator | | URL | Profile link | https://tiktok.com/@creativecreator | | Description | Creator bio | "Fashion & lifestyle content..." | | Followers | Total follower count | 50,000 | | Collaboration | AI assessment of brand fit | "Highly Relevant" | | Analysis | 50-word Claude AI relevance summary| "Strong alignment with fashion..."| --- 🚀 Setup Instructions Prerequisites n8n (cloud or self-hosted) Bright Data account with TikTok access Google Sheets + Gmail Anthropic Claude API key 10–15 minutes setup time Step-by-Step Setup Import Workflow via JSON in n8n Configure Bright Data – Add API credentials and dataset ID Google Sheets – Setup credentials and map columns Claude AI – Insert API key and select desired model Gmail – Authenticate Gmail and update mail node settings Update Variables – Replace placeholders with business info Test & Launch – Submit a sample form and verify all outputs --- 📖 Usage Guide Adding Search Keywords Submit the form with search terms, business description, and industry category to trigger the workflow. Understanding AI Analysis Emails are sent only if: Collaboration status = Highly Relevant Follower count ≥ 5000 Industry alignment confirmed Claude AI returns a 50-word analysis justifying the match Customizing Filters Edit the "Find the Collaborator" prompt to adjust: Follower thresholds Industry relevance Additional metrics (e.g., engagement rate) Viewing Results Google Sheets log includes: Influencer metadata AI scores and rationale Collaboration status Email delivery timestamp --- 🔧 Customization Options Add More Fields: Engagement rate, contact email, content themes Email Personalization: Customize message templates or integrate other mail services Enhanced Filtering: Use engagement rates, region, content frequency --- 🚨 Troubleshooting | Issue | Fix | |-------|-----| | Bright Data fails | Recheck API and dataset ID | | No influencer data | Adjust keywords or dataset scope | | Sheets permission error | Re-authenticate and check sharing | | Claude fails | Validate API key and prompt | | Emails not sent | Re-auth Gmail or update recipient field | | Form not triggering | Reconfirm webhook URL and permissions | Advanced Debugging Check n8n execution logs Run individual nodes for pinpointing failures Confirm all data formats Handle API rate limits Add error-catch nodes for retries --- 📊 Use Cases & Examples Brand Discovery: Fashion, tech, fitness creators Competitor Insights: Find influencers used by rival brands Campaign Planning: Build targeted influencer lists Market Research: Identify creator trends across regions --- ⚙️ Advanced Configuration Batch Execution: Process multiple keywords with delay logic Engagement Metrics: Scrape and calculate likes-to-follower ratios CRM Integration: Sync qualified profiles to HubSpot, Salesforce, or Slack --- 📈 Performance & Limits Processing Time: 3–5 minutes per keyword Concurrency: 3–5 simultaneous fetches (depends on plan) Accuracy: >95% influencer data reliability Success Rate: 90%+ for outreach and processing
By Dvir SharonExtract Google My Business leads by service or location with Bright Data
📍 Extract Google My Business Leads by Service & Location with Bright Data to Google Sheets This template requires a self-hosted n8n instance to run. A comprehensive n8n automation that extracts Google My Business listings by service type and geographic location using Bright Data's Google Maps dataset, with intelligent city expansion and automatic duplicate removal. --- 👥 Who is this for? Lead generation professionals Sales teams Marketing agencies Business development representatives Entrepreneurs conducting outreach or market research --- ❓ What problem is this solving? Manual lead generation from Google Maps is time-consuming and inefficient. This workflow automates the process of finding businesses by service type and location, expanding searches across cities, removing duplicates, and organizing results in a structured format. --- ⚙️ What this workflow does Input Processing Accepts service type, state, and country via web form Uses Claude AI to generate city lists Auto-categorizes services Creates search queries per city Data Collection Uses Bright Data's Google Maps dataset Processes in batches with rate limits Monitors scraping with retry logic Formats and handles API responses Quality Control Removes duplicates by name and phone Maintains clean data in Google Sheets Ensures structured, usable datasets 📄 Output Data Points | Field | Description | Example | | :-------------- | :-------------------------- | :---------------------------- | | Business Name | Company or business name | TechFix Computer Repair | | Category | Business category type | Electronics | | Country | Country location | US | | City | Specific city searched | Austin | | Phone Number | Contact phone number | +1 (555) 123-4567 | | Website URL | Business website | https://techfix.com | | Google Maps URL | Direct Maps link | https://maps.google.com/... | | Address | Full business address | 123 Main St, Austin, TX | | Operating Hours | Business hours | Mon-Fri 9AM-6PM | | Google Rating | Star rating | 4.5 | | Total Reviews | Number of reviews | 127 | | Reviews URL | Link to reviews | https://maps.google.com/reviews... | --- 🚀 Setup Instructions Prerequisites n8n instance (self-hosted or cloud) Google account with Sheets access Bright Data account with Google Maps dataset access Anthropic API key for Claude AI Step-by-Step Import the workflow JSON into n8n Configure Bright Data credentials and dataset access Set up Google Sheets and OAuth2 credentials Configure Claude AI with your API key Replace all placeholder credential IDs and tokens. For improved security, use credentials instead of hardcoding the API token placeholder in the HTTP Request node. Test with sample data (e.g., "Coffee Shop" in California, US) Activate the workflow and use the form for submissions --- 🛠 How to Customize Modify Geographic Scope Add countries to the form dropdown Customize Claude prompts for city generation Adjust search logic for international markets Enhance Data Collection Add more fields from Bright Data Include revenue, employee count, social profiles Improve Duplicate Detection Use fuzzy matching for similar names Include address-based checks Customize Output Format Transform data for CRM compatibility Export to CSV, database, or multiple destinations Implement Advanced Features Integrate email finder services Include lead scoring logic Discover social media profiles Batch Processing Optimization Adjust batch sizes per Bright Data limits Use parallel processing and retry logic Integration Options Connect to CRMs like HubSpot or Salesforce Trigger email automation Integrate with marketing platforms
By Dvir SharonExtract competitor SERP rankings from Google Search to Sheets with Bright Data
🔍 Extract Competitor SERP Rankings from Google Search to Sheets with Bright Data This template requires a self-hosted n8n instance to run. A comprehensive n8n automation that extracts competitor data from Google search results for specific keywords and target countries, automatically saving structured data to Google Sheets for competitive analysis and market research. --- 📋 Overview This workflow provides a professional competitor analysis solution that identifies ranking websites for specific search terms across different countries. Perfect for SEO research, competitive intelligence, market analysis, and content strategy planning. The system uses Bright Data's SERP API for accurate search result extraction and advanced HTML parsing for detailed competitor information. Who is this for? SEO professionals conducting competitive analysis Digital marketers researching market landscapes Business analysts studying competitor positioning Content strategists analyzing competitor content approaches Market researchers tracking competitive intelligence across regions What problem is this workflow solving? Extracting competitor data from Google search results Processing multiple keywords across different countries Organizing results in a structured, analyzable format Eliminating manual copy-paste work Ensuring consistent data collection methodology What this workflow does Manual Trigger: Starts the workflow execution Get Keywords from Sheet: Fetches keywords and target countries from Google Sheets URL Encode Keywords: Converts keywords to URL-safe format Process Keywords in Batches: Handles multiple keywords sequentially Fetch Google Search Results: Uses Bright Data SERP API to scrape HTML Extract Competitor Data from HTML: Parses HTML to extract competitor details Save Competitor Results to Sheet: Stores structured data in Google Sheets Wait to Avoid Rate Limits: Implements 30-second delays between requests Output Data Points | Field | Description | Example | | :--------------- | :--------------------------------- | :------------------------------------------ | | Keyword | Original search term | digital marketing services | | Target Country | Geographic target | US | | websiteName | Domain/company name | hubspot | | websiteUrl | Complete website URL | https://www.hubspot.com/marketing | | websiteTitle | Page title from search results | Digital Marketing Software & Tools | | websiteDescription | Meta description/snippet | Grow your business with HubSpot's digital marketing tools... | --- ⚙️ Setup Prerequisites n8n instance (self-hosted) Google account with Sheets access Bright Data account with SERP API access Google Sheet Structure This workflow utilizes two Google Sheets: one for input keywords and one for outputting competitor data. Input Sheet: "Keywords" This sheet should contain the keywords and target countries for your search queries. | Column Header | Data Type | Description | Example | | :------------- | :-------- | :------------------------------------------------- | :-------------- | | Keyword | Text | The search term you want to analyze. | digital marketing | | Country | Text | The 2-letter ISO country code for the target region of the search (e.g., US, GB, DE). | US | Output Sheet: "Competitor Results" This sheet will be populated automatically by the workflow with the extracted competitor data. | Column Header | Data Type | Description | Example | | :----------------- | :-------- | :---------------------------------------------------------------------------------- | :----------------------------------------------- | | Keyword | Text | The original search term used for the query. | digital marketing services | | Target Country | Text | The 2-letter ISO country code of the search results. | US | | websiteName | Text | The name of the website or domain found in the search results. | hubspot | | websiteUrl | URL | The full URL of the website or page found in the search results. | https://www.hubspot.com/marketing | | websiteTitle | Text | The title of the page as displayed in the Google search results. | Digital Marketing Software & Tools | | websiteDescription | Text | The meta description or snippet text displayed under the title in search results. | Grow your business with HubSpot's digital marketing tools... | Step-by-Step Setup Import the Workflow: Copy JSON → n8n → Workflows → + Add → Import from JSON Configure Bright Data Credentials: Credential Type: HTTP Header Auth Header Name: Authorization Header Value: Bearer YOURAPITOKEN Configure Google Sheets: Create two new Google Sheets as described above: one named "Keywords" (for input) and one named "Competitor Results" (for output). Set up Google Sheets OAuth2 credentials within n8n. Update Workflow Settings: Replace placeholders: YOURGOOGLESHEETID (for both input and output sheets), YOURBRIGHTDATACREDENTIALID. Ensure correct sheet/tab names are selected in the Google Sheets nodes. Test & Activate: Add test data to your "Keywords" sheet → Execute workflow → Verify output in your "Competitor Results" sheet. --- 🛠 How to Customize Add More Data Points: Modify the JavaScript code in the "Extract Competitor Data from HTML" node to parse and extract additional information from the HTML. Custom Filtering: Implement logic to exclude specific domains, filter results by title length, or other criteria. Expand Geographic Coverage: Add more 2-letter ISO country codes to the Bright Data SERP API call to broaden your competitive analysis. Batch Processing: Adjust the settings in the "Process Keywords in Batches" node to optimize for your Bright Data plan and desired execution speed. Rate Limiting: Modify the "Wait" node (default: 30 seconds) to increase or decrease the delay between requests based on API limits or performance needs. --- 📊 Use Cases & Examples SEO Competitive Analysis: Identify top-ranking competitors for your target keywords and analyze their strategies. Market Entry Research: Understand the competitive landscape in new geographic regions before expanding. Content Strategy Planning: Analyze competitor page titles and meta descriptions for inspiration and to identify content gaps. International Market Research: Compare search engine results and competitor positioning across different countries. --- 📈 Performance & Limits Single Keyword: 30–60 seconds per keyword. Batch of 10 Keywords: Typically takes 5–10 minutes. Large Lists (50+ Keywords): Expect execution times of 30–60 minutes or more, depending on batching and rate limits. Success Rate: Generally 95%+ for data extraction. Data Accuracy: Typically 98%+ for extracted fields. API Calls: 1 Bright Data SERP API call per keyword, plus multiple Google Sheets writes per execution. Rate Limit: A 30-second delay between requests is recommended to prevent exceeding API limits. --- 🧰 Troubleshooting Bright Data API error: Double-check your API token, ensure you have sufficient credits, and confirm SERP API access is enabled on your Bright Data account. No keywords found: Verify the Google Sheet ID and ensure the column headers in your "Keywords" sheet precisely match the specifications (e.g., "Keyword", "Country"). Google Sheets permission denied: Re-authenticate your Google Sheets credentials within n8n and check that the correct sharing settings are applied to your sheets. No results extracted: Review the JavaScript parsing logic in the "Extract Competitor Data from HTML" node. Also, verify the validity of your keywords and target countries. Loop not processing all: Check the batch settings in the "Process Keywords in Batches" node and ensure all connections within the loop are correctly configured. --- 🤝 Support & Community n8n Forum: <https://community.n8n.io> n8n Docs: <https://docs.n8n.io> Bright Data Support: Access support directly via your Bright Data dashboard. GitHub Issues: Report any bugs or suggest new features on the n8n GitHub repository. --- 🎯 Final Notes This workflow provides a comprehensive foundation for competitor research and market analysis. Customize it to fit your specific industry needs and competitive intelligence requirements. --- Please note that this template uses Community Nodes. Ensure you understand the risks before using community nodes.
By Dvir SharonMonitor Google Shopping prices with Bright Data & email alerts
🛒 Monitor Google Shopping Prices with Bright Data & Email Alerts This template requires a self-hosted n8n instance to run. A comprehensive n8n automation that monitors product prices daily using Bright Data's Google Shopping dataset and sends smart email alerts when price conditions are met. --- 📋 Overview This workflow provides an automated price monitoring solution that tracks product prices from Google Shopping daily and sends intelligent email notifications. Perfect for e-commerce monitoring, competitor analysis, deal hunting, and inventory management. --- ✨ Key Features 🕘 Scheduled Monitoring: Daily automated price checks at 9 AM 🛍️ Google Shopping Integration: Uses Bright Data's dataset for accurate pricing 📊 Smart Price Comparison: Compares current prices with historical data 📧 Intelligent Alerts: Sends emails only when prices meet criteria 📈 Data Storage: Updates Google Sheets with latest pricing data 🔄 Batch Processing: Handles multiple products with rate limiting ⚡ Fast & Reliable: Built-in error handling 🎯 Customizable Filters: Advanced price comparison logic --- 🎯 What This Workflow Does Schedule Trigger: Runs daily at 9 AM Data Retrieval: Fetches product list from Google Sheets Price Extraction: Scrapes current prices using Bright Data Data Update: Updates Google Sheets with new prices Price Comparison: Compares new vs. old prices Smart Filtering: Filters products that meet alert criteria Email Notifications: Sends alerts for qualifying changes Rate Limiting: Adds delay between emails Output Data Points | Field | Description | Example | | :------------ | :------------------------- | :------------------------------- | | Product URL | Original Google Shopping URL | https://shopping.google.com/product/... | | Product Name | Product title | iPhone 15 Pro Max 256GB | | Ratings | Product rating score | 4.5 | | Reviews | Number of reviews | 1,247 | | Old Price | Previous price | $1,199.00 | | New Price | Current scraped price | $1,199.00 | | Timestamp | When the check occurred | 2025-05-30T09:00:00Z | --- 🚀 Setup Instructions Prerequisites n8n instance (self-hosted or cloud) Google account with Sheets access Bright Data account with Google Shopping dataset access Gmail account for notifications Steps Import the workflow JSON into n8n Configure Bright Data credentials and dataset access Set up Google Sheets with required columns Configure Gmail OAuth2 credentials Update sheet IDs and schedule settings Test with sample products and activate --- 📖 Usage Guide Google Sheet Structure Your Google Sheet should have the following columns to ensure the workflow functions correctly: Product URL (Text): The direct URL to the Google Shopping product page. This is the primary identifier for the product. Product Name (Text): The name of the product. This will be automatically populated or updated by the workflow. Old Price (Number/Currency): The price of the product from the previous check. This column is crucial for price comparison. New Price (Number/Currency): The most recently scraped price of the product. Ratings (Number): The star rating of the product. Reviews (Number): The total number of reviews for the product. Timestamp (Datetime): The date and time when the price check was performed. Adding Products Add Google Shopping URLs to your Google Sheet. The workflow will fetch product details and track prices. Historical price data builds over time. Understanding Price Alerts The default setting for this workflow is to send an email alert when the new price equals the old price. This might seem counterintuitive, but it's useful for specific scenarios, such as: Monitoring stable pricing: If you are tracking a product and want to be notified when its price has remained consistent over time, indicating a potential stable buying opportunity or a benchmark. Verifying data consistency: To confirm that the scraping process is working correctly and consistently retrieving the same price when no changes are expected. You can easily customize the alert logic to trigger on different conditions as described below. Customizing Alert Logic Price drops: newprice < oldprice Significant drops: new_price < (old_price 0.9) (e.g., price dropped by more than 10%) Price increases: newprice > oldprice Any change: newprice != oldprice Reading the Results Real-time pricing data Historical tracking Product metadata Timestamps for each check --- 🔧 Customization Options Add More Data: Descriptions, availability, seller info, shipping, images Modify Email Templates: Customize subject and body Multiple Recipients: Duplicate email node and change recipients Webhook Integration: Add real-time triggers or Slack alerts --- 🚨 Troubleshooting Bright Data connection failed: Check API credentials and dataset access No price data extracted: Verify URLs and test with different products Google Sheets permission denied: Re-authenticate and check sharing Emails not sending: Re-auth Gmail OAuth and verify recipients Filter not working: Check price formats and logic Workflow failed: Check logs, retry logic, and network status --- 📊 Use Cases & Examples E-commerce Monitoring: Track competitor pricing and trends Deal Hunting: Get alerts for price drops on wishlist items Inventory Management: Monitor supplier pricing for procurement Market Research: Analyze pricing trends and generate reports --- ⚙️ Advanced Configuration Batch Processing: Increase batch size, add delays, use parallel processing Price History: Store historical data, calculate averages, forecast trends Tool Integration: CRM, Slack, databases, BI tools (Tableau, Power BI) --- 📈 Performance & Limits Single URL: 2–5 seconds Concurrent Requests: 3–5 (depends on Bright Data plan) Data Accuracy: 95%+ Success Rate: 90%+ Daily Capacity: 100–500 products Memory: ~100MB per execution API Calls: 1 Bright Data + 2 Google Sheets per product --- 🤝 Support & Community n8n Forum: <https://community.n8n.io> Documentation: <https://docs.n8n.io> Bright Data Support: Via your Bright Data dashboard GitHub Issues: Report bugs and request features --- 🎯 Ready to Use! Your workflow provides a solid foundation for automated price monitoring. Customize it to fit your specific needs and use cases for maximum effectiveness in tracking Google Shopping prices with intelligent email notifications. --- Please note that this template uses Community Nodes. Ensure you understand the risks before using community nodes.
By Dvir SharonGoodreads quote extraction with Bright Data and Gemini
Goodreads Quote Extraction with Bright Data and Gemini This workflow demonstrates how to fetch data specifically from Goodreads web pages using Bright Data and then extract specific information (quotes) from that data using a Google Gemini AI model. How it works The workflow is triggered manually. It sends a request to a Bright Data collector to scrape data from a predefined list of Goodreads URLs. The collected text data from Goodreads is then passed to a Google Gemini AI node. The AI node processes the text and extracts quotes based on a specified JSON schema output format. Set up steps Setting up this workflow should take only a few minutes. You will need a Bright Data API key to configure the 'Header Auth' credential. You will need a Google Gemini API key to configure the 'Google Gemini(PaLM) Api account' credential. Ensure the correct Bright Data collector ID is set in the 'Perform Bright Data Web Request' node URL. Make sure the full list of target Goodreads URLs is correctly added to the 'Perform Bright Data Web Request' node's body. Link your created credentials to the respective nodes ('Perform Bright Data Web Request' and 'Quotes Extractor'). Keep detailed descriptions for specific node configurations in sticky notes inside your workflow canvas.
By Dvir Sharon