How to Automate Airtable SEO Metadata Enrichment?
Description
Fill missing SEO titles and meta descriptions in your Airtable base without manual copy and paste. Ideal for marketers and content teams that keep a list of URLs and need complete metadata for audits, briefs, and site updates.
On each run, the flow looks in Airtable for rows where the url field is filled, but title tag and meta desc are empty. For each match, it fetches the web page, then pulls the page title and the meta description with simple CSS rules. The values are written back to the same Airtable record, so your table stays current and clean. A batch limit of 10 runs by default and can be adjusted to fit your workload.
Set up one Airtable table with url, title tag, and meta desc fields, connect your Airtable token, and run on demand when you add new URLs. Expect a big cut in manual work and faster SEO checks across many pages. Great for quick metadata audits, content refresh projects, and migration prep where dozens or hundreds of pages are missing basic tags.
Tools Required
What this workflow does?
- Runs on demand with a manual trigger for quick batches.
- Searches Airtable for rows missing title and meta using a filter formula.
- Downloads each web page from the url field with an HTTP request.
- Extracts the page title and meta description using simple CSS selectors.
- Updates the same Airtable record by ID with the new metadata.
- Processes records in batches with an adjustable limit for safe testing.
What are the benefits?
- Reduce manual work from 2 hours to 5 minutes for 100 URLs
- Automate 100 percent capture of titles and descriptions when present
- Improve data quality by 90 percent by removing copy paste errors
- Handle 10 times more pages per week without adding headcount
- Connect Airtable with live web content for up to date records
How to set this up?
- Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
- You'll need accounts with Airtable. See the Tools Required section above for links to create accounts with these services.
- In Airtable, create a base and a table with three single line text fields named url, title tag, and meta desc. Add a few test URLs and leave the two metadata fields blank.
- In n8n, open the Credentials section and create a new Airtable Personal Access Token credential. On the Airtable website, create a token with access to your base and copy the token into n8n.
- Open the Get records node and select your Airtable credential, base, and table. Keep the filterByFormula set to AND(url != "", {title tag} = "", {meta desc} = ""). Adjust the limit if you want to process more than 10 rows.
- Open the Get url content node and confirm the URL field uses the expression {{$json.url}}. If some sites block requests, set a user agent in the headers.
- Open the Extract title tag and meta description node. Confirm the selectors are title for the page title and meta[name="description"] with the content attribute for the meta description.
- Open the Update original record node. Map id to the id from the Get records node, and map title tag and meta desc to the outputs from the extract step.
- Click Execute to run the workflow. Watch each node for green checks, then open your Airtable table and confirm the title tag and meta desc fields are filled.
- If some rows stay blank, the page may not have a meta description or the URL may be invalid. Fix the URL, add missing tags on the site, or skip those records. If you see timeouts or 403 errors, lower the batch limit or add a user agent header.
Need help or want to customize this?
Ask in the Free Futurise Community.
Similar Templates
These templates were sourced from publicly available materials across the web, including n8n’s official website, YouTube and public GitHub repositories. We have consolidated and categorized them for easy search and filtering, and supplemented them with links to integrations, step-by-step setup instructions, and personalized support in the Futurise community. Content in this library is provided for education, evaluation and internal use. Users are responsible for checking and complying with the license terms with the author of the templates before commercial use or redistribution.Where an original author was identified, attribution has been provided. Some templates did not include author information. If you know who created this template, please let us know so we can add the appropriate credit and reference link. If you are the author and would like this template removed from the library, email us at info@futurise.com and we will remove it promptly.
