πŸ“Š Extract Title tag and Meta description from url for SEO analysis with Airtable

⚑ 3,865 views Β· πŸ“Š Market Research & Insights

Description

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

  1. 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)

  1. 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} = "")
  1. Insert the url to be analyzed in the table in the field url and let the workflow do the rest.

Extra

πŸ”— Nodes Used

Airtable, HTTP Request

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup