Turn your pages into an SEO keyword table
Reads each page you list, records the terms it actually uses in Airtable, and never records the same page twice.
What it does
The integration steps this workflow runs, in the order it first runs them.
- 1AirtableList records
- 2OpenAIQuery model
- 3AirtableCreate record
How it works
Everything the template sets up, and what to fill in before the first run.
Every Monday this workflow fetches each web page you list, reads the wording on it, and adds one Airtable row per page holding the page's title, a one-sentence description, and the search terms the page targets. Over a few weeks that becomes a keyword table for your whole site.
Every term recorded has to appear on the page itself: the workflow checks each suggested term against the page's own wording and drops any it cannot find, and a page where nothing survives that check gets no row at all rather than a row of invented terms. It records no search volume, difficulty or ranking, because none of that is measured here.
Before reading a page the workflow asks Airtable whether that exact address is already in the table, so a page is never recorded twice - and if that question cannot be answered the page is left for the next run rather than written blind. A page that cannot be fetched is reported and skipped, and the rest of the list still runs.
Set it up by listing your page addresses one per line in the 'pageUrls' step and naming your base and table in the 'airtableBaseId' and 'airtableTableName' steps. Your table needs four text fields, named exactly: Page URL, Page Title, Summary, Keywords. How many pages are read per run is editable on its own step.
You May Also Be Interested In
Audit one page's on-page SEO and email the fixesAudits the on-page SEO of a page you name each week and emails what to fix, in priority order.
Approve the outline, then the post, then publishTakes the next topic off your content plan, asks you to approve the outline, writes the post to it, and publishes only if you say so.
Message a topic, get post copy and a picture backSend a topic to your Telegram chat and get back a drafted social post for the platform you choose, with a picture to go with it.
Read a whole site into spreadsheet rowsFinds the pages on a site from its sitemap or front page, reads each one, and adds a row per page to your sheet.
Start from a workflow that already works.
Add "Turn your pages into an SEO keyword table" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required