Analyze competitor keywords with RapidAPI and Google Sheets reporting
π Analyze Competitor Keywords with RapidAPI and Google Sheets Reporting π Description This n8n workflow streamlines the process of analyzing SEO competitor keywords using the Competitor Keyword Analysis API on RapidAPI. It collects a website and country via form submission, calls the API to retrieve keyword metrics, reformats the response, and logs the results into Google Sheets β all automatically. It is ideal for SEO analysts, marketing teams, and agencies who need a hands-free solution for competitive keyword insights. --- 𧩠Node-by-Node Explanation π On form submission (formTrigger) Starts the workflow when a user submits their website and country through a form. π Competitor Keyword Analysis (httpRequest) Sends a POST request to the Competitor Keyword Analysis API on RapidAPI with form input to fetch keyword data. π Reformat Code (code) Extracts the domainOrganicSearchKeywords array from the API response for structured processing. π Google Sheets (googleSheets) Appends the cleaned keyword metrics into a Google Sheet for easy viewing and tracking. --- π Benefits of This Workflow β Automates SEO research using the Competitor Keyword Analysis API. β Eliminates manual data entry β results go straight into Google Sheets. β Scalable and reusable for any number of websites or countries. β Reformatting logic is built-in, so you get clean, analysis-ready data. --- πΌ Use Cases Marketing Agencies Use the Competitor Keyword Analysis API to gather insights for client websites and store the results automatically. In-house SEO Teams Quickly compare keyword performance across competitors and monitor shifts over time with historical Google Sheets logs. Freelancers and Consultants Provide fast, data-backed SEO reports using this automation with the Competitor Keyword Analysis API. Keyword Research Automation Make this flow part of a larger system for identifying keyword gaps, content opportunities, or campaign ideas. --- π Output Example (Google Sheets) | keyword | searchVolume | cpc | competition | position | previousPosition | keywordDifficulty | |---------------|--------------|-----|-------------|----------|------------------|-------------------| | best laptops | 9900 | 2.3 | 0.87 | 5 | 7 | 55 | --- π How to Get Your API Key for the Competitor Keyword Analysis API Go to π Competitor Keyword Analysis API - RapidAPI Click "Subscribe to Test" (you may need to sign up or log in). Choose a pricing plan (thereβs a free tier for testing). After subscribing, click on the "Endpoints" tab. Your API Key will be visible in the "x-rapidapi-key" header. π Copy and paste this key into the httpRequest node in your workflow. β Summary This workflow is a powerful no-code automation tool that leverages the Competitor Keyword Analysis API on RapidAPI to deliver real-time SEO insights directly to Google Sheets β saving time, boosting efficiency, and enabling smarter keyword strategy decisions. --- Create your free n8n account and set up the workflow in just a few minutes using the link below: π Start Automating with n8n
By Evoort SolutionsAutomate job search with AI cover letters using Google Jobs, RemoteOK & GPT-3.5
Automated Job Search with AI-Generated Cover Letters π― What This Template Does This workflow transforms your job search from a time-consuming daily chore into a fully automated system. Every 24 hours, it searches Google Jobs and RemoteOK for positions matching your criteria, generates unique AI-powered cover letters for each role, and delivers a polished HTML email digest straight to your inbox. β‘ Key Features Multi-Platform Search: Simultaneously queries Google Jobs (via SerpAPI) and RemoteOK Smart Filtering: Automatically removes duplicates and low-quality postings AI-Powered Cover Letters: Uses OpenAI GPT-3.5 to write personalized 60-word cover letters for each position Beautiful Email Digests: HTML-formatted emails with job details, descriptions, and apply buttons Zero Manual Work: Runs automatically every 24 hours Cost-Effective: ~$0 for first 3 months using free API tiers, then ~$3/month β±οΈ Time Saved | Method | Time Required | |--------|---------------| | Manual Job Search | 2-3 hours daily | | With This Workflow | 0 minutes (fully automated) | | Annual Time Savings | ~800 hours per year | π Prerequisites SerpAPI Account Cost: FREE tier (100 searches/month) Sign up: https://serpapi.com/ What you need: API key from dashboard OpenAI Account Cost: FREE ($5 trial credits) Sign up: https://platform.openai.com/ What you need: API key (requires phone verification) Email Service Cost: FREE (use existing email) Options: Gmail, Outlook, or any SMTP provider Gmail users: Use App Password (requires 2FA enabled) π Quick Start Guide Step 1: Get API Keys (10 minutes) SerpAPI Setup Go to https://serpapi.com/ and sign up Verify your email Log in β Dashboard Copy your API key OpenAI Setup Go to https://platform.openai.com/ Create account and verify phone number Profile icon β View API keys Create new secret key Copy immediately (shown only once) Gmail Setup (if using Gmail) Google Account β Security Enable 2-Step Verification Search for "App Passwords" Generate app password for Mail Copy the 16-character password Step 2: Add Credentials to n8n (5 minutes) Add SerpAPI n8n Credentials β Add Credential Select "HTTP Query Auth" Name: api_key Value: [paste your SerpAPI key] Save Add OpenAI Add Credential β OpenAI Paste your API key Save Add SMTP Add Credential β SMTP Configure: Host: smtp.gmail.com Port: 587 Security: STARTTLS Username: your-email@gmail.com Password: [app password] Save Step 3: Configure Your Search (2 minutes) Click the "Settings" node and update: query - Your target job title β Good: senior react developer β Good: product manager saas β Good: data scientist machine learning β Bad: developer (too broad) location - Where you want to work For remote: Remote For city: San Francisco, CA For city: New York, NY For state: Texas π‘ Tip: Start with Remote for most options email - Your email address Use the SAME email from SMTP setup Example: yourname@gmail.com Step 4: Connect Credentials Click "Search Google Jobs" node β Select SerpAPI credential Click "Generate Letter" node β Select OpenAI credential Click "Send Email" node β Select SMTP credential Click "No Results Email" node β Select SMTP credential Step 5: Test & Activate Click "Execute Workflow" button (top right) Watch nodes light up green β Wait 30-60 seconds Check your email inbox If successful β Toggle "Active" switch Done! You'll receive daily job digests π§ What You'll Receive Each day, you'll get an email containing: Up to 4 highly relevant job listings Company name and location for each Job description snippets AI-generated personalized cover letter for each position Direct "Apply Now" button Source attribution (Google Jobs vs RemoteOK)
By Shelly-Ann Davy