See which search terms each page of your site targets
Each week, records the title, summary and search terms of each page you list in Airtable, using only words found on the page.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
For each
rawUrl- 1AirtableList recordsLooks up each page address in your table first, so a page already recorded is skipped rather than added twice.
- 2OpenAIQuery modelAsks the AI for the page's title, a one-sentence description and up to ten search terms copied from its own wording.
- 3AirtableCreate recordAdds one record per page with its address, title, summary and only the search terms actually found on the page.
- 1
How it works
What happens on each run, in plain English.
Every Monday at 07:00, each web page on your list is fetched and read, and one row per page is added to your Airtable table holding the page's title, a one-sentence description and the search terms it targets. Over a few weeks that becomes a keyword table for your whole site.
Every term recorded has to appear on the page itself: each suggestion the AI makes is checked against the page's own wording and dropped if it cannot be found, and a page where nothing survives that check gets no row at all. No search volume, difficulty or ranking is recorded, because none of that is measured here. Airtable is asked first whether each address is already in the table, so no page is recorded twice; if that check fails the page waits for the next run rather than being written blind. A page that cannot be fetched is reported and skipped while the rest still run.
You need an Airtable table with four text fields named 'Page URL', 'Page Title', 'Summary' and 'Keywords'.
You may also be interested in
Fill a spreadsheet with a ChatGPT-written list every hourEvery hour, has ChatGPT write a fresh batch of the list you describe and adds each item as a row in your Google Sheet.
Get a weekly SEO checkup of your key page by emailEvery Monday, checks the on-page SEO of a page you name and emails its score and what to fix, most important first.
Write blog posts from your content plan, with your sign-offTurns your content plan into blog posts: you approve the outline, then the finished post, before anything is published on WordPress.
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.Start from a workflow that already works.
Add "See which search terms each page of your site targets" to your workspace, connect its apps, and make it yours.
Free plan, no credit card