Extract SEO Title & Meta Description from URLs via Airtable

This n8n workflow extracts the <title> tag and meta description from any URL stored in an Airtable base, ideal for SEO professionals conducting bulk audits. It queries Airtable for records missing these fields, fetches the webpage content, parses the HTML to retrieve the exact title and meta description, and updates the records automatically. If tags are absent, fields remain empty, ensuring clean data.

The workflow integrates seamlessly with Airtable using two nodes: one to fetch records via a filter formula (e.g., AND(url != "", {title tag} = "", {meta desc} = "")), and another to write back the extracted data. It employs an HTTP Request to retrieve webpage HTML and HTML Extract nodes for precise parsing, handling real-world variations in page structure reliably.

Benefits include massive time savings for SEO teams analyzing hundreds of pages—no manual browser inspections or copy-pasting. Use cases span competitor analysis, site migrations, content optimization, and ongoing monitoring. Enhance it further with Airtable formula fields for character counts (e.g., LEN({title tag})) to check SEO best practices (title <60 chars, meta <160). For full automation, trigger via webhook from Airtable's paid plans.