Extract Title tag and Meta description from url for SEO analysis with Airtable
Extract Title tag and meta description from url for SEO analysis. How it works The workflows takes records from Airtable, get the url in the records and extract from the related webpage the title tag (<title>) and meta description (<meta name="description" content="Some content">). If title tag and/or meta description tag isn't available on the webpage, the result will be empty. Setup Set a Base in Airtable with a table with the following structure: url (field type url), title tag (field type text string), meta desc (field type text field) Minimum suggested table structure is: url (https://example.com), title (Title example), meta desc* (This is the meta description of the example page) Connect Airtable to both Airtable nodes in the template and, with the following formula, get all the records that miss title tag and meta desc. Formula: AND(url != "", {title tag} = "", {meta desc} = "") Insert the url to be analyzed in the table in the field url and let the workflow do the rest. Extra You can also calculate the length for title tag and meta desc using formula field inside Airtable. This is the formula: LEN({title tag}) or LEN({meta desc}) You can automate the process calling a Webhook from Airtable. For this, you need an Airtable paid plan.
By Giacomo LanziGenerate SEO/AEO-optimized Shopify blog articles with GPT-4 and Google Sheets
This n8n template demonstrates how to automatically generate and publish SEO/AEO-optimized Shopify blog articles from a list of keywords using AI for content creation, image generation, and metadata optimization. Who’s it for Shopify marketers, content teams, and solo founders who want consistent, hands-off blog production with built-in SEO/AEO hygiene and internal linking. What it does The workflow picks a keyword from your Google Sheet based on priority, search volume, and difficulty. It then checks your Shopify blog for existing slugs to avoid duplicate, drafts a 900+ word article optimized for SEO/AEO, generates a hero image, creates the article in Shopify, sets SEO metafields (title/description), and logs the result to your Sheets for tracking and future internal links. How it works Google Sheets → Candidate selection: Reads Keywords, Links, and Published tabs: ranks by priority → volume → difficulty. (In the workflow it is explained how to exactly set up the Google Sheets) De-dupe slugs: Paginates your blog via Shopify GraphQL to collect existing handles and make sure to use a different one. OpenAI content + image: Builds a structured prompt (SEO/AEO and internal linking), calls Chat Completions and Image Generation for a hero image. Shopify publish: Creates the article via REST and updates titletag / descriptiontag metafields via GraphQL. Log + link graph: Appends to Published tab to keep track of articles posted and Links tab for ongoing internal-link suggestions. How to set up Open Set – Config and fill: shopDomain, siteBaseUrl, blogId, blogHandle, sheetId, author. Optional: autoPublish, maxPerRun, tz. Create the Google Sheet with Keywords, Links, Published tabs using the provided column structure. I have personally used Semrush to generate that list of keywords. Add credentials: Shopify Admin token (Header/Bearer), OpenAI API key, and Google Service Account. Requirements Shopify store with Blog API access OpenAI API key Google Service Account with access to Google Sheets API (can be activated here here) How to customize Change the cron in Schedule Trigger for different days/times. Adjust maxPerRun, autoPublish, language or any other variables in the "Set - Config" node. Adjust the prompt from the "Code - Build Prompt" node. Extend the Sheets schema with extra scoring signals if needed.
By GeoffroyGet synonyms of a German word
No description available.
By Harshil AgrawalAutomate 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