Get Started
Screenshot of n8n workflow
FREE TEMPLATE
Generate OpenAI SEO Content Catalog
2
Views
0
Downloads
23
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
OpenAI
Trigger Type
Approx setup time ≈ 25 min
Need help setting up this template?
Ask in our free Futurise community
About
Community
Courses
Events
Members
Templates

How to Generate OpenAI SEO Content Catalog?

Leon Petrou
FREE TEMPLATE
Generate OpenAI SEO Content Catalog
2
Views
0
Downloads
23
Nodes
Download Template
Free
Preview Template
Utility Rating
7 / 10
Business Function
Marketing
Automation Orchestrator
n8n
Integrations
OpenAI
Trigger Type
Approximate setup time ≈ 25 minutes
Need help setting up this template?
Ask in our free Futurise community

Description

Turn a site crawl export into a clean text catalog that highlights the best pages for AI and SEO work. Ideal for content and SEO teams that want a fast way to prepare curated links with titles and short descriptions.

The flow starts with a simple form where you enter the site name, a short summary, and upload a CSV from your crawler. The file is parsed, then mapped to seven key fields like URL, title, description, status, indexability, content type, and word count. A filter keeps only pages that return 200, are indexable, and are text HTML. You can also enable an AI step with OpenAI to classify pages as useful content or other content. Each page is formatted as a simple line, then all lines are combined and saved as a downloadable text file. You can swap the last node to upload the file to cloud storage.

Use a CSV export that includes internal URLs, ideally the internal HTML version. The mapping handles multiple languages, so non English exports still work. Expect big time savings by moving from manual sorting to a guided flow. Teams can build a clean list in minutes and reuse the same steps for new sites or larger crawls.

Copy link

Tools Required

What this workflow does?

  • Form upload that collects site name, short summary, and a CSV file
  • CSV extraction that prepares rows for easy processing
  • Multi language column mapping for URL, title, description, status, indexability, content type, and word count
  • Rules that keep only 200 status, indexable, and text HTML pages
  • Optional OpenAI powered classification to flag useful content
  • Row builder that formats each page as a simple list line
  • Concatenation that combines all lines into one clean text block
  • File creation that lets you download the final text file in n8n
  • Swap the final step to upload the file to cloud storage if needed

What are the benefits?

  • Reduce manual review from 3 hours to 10 minutes for a 5000 URL crawl
  • Improve URL selection accuracy by enforcing 200 status and indexable rules
  • Handle 10 times more pages by automating parsing, filtering, and formatting
  • Use OpenAI to prioritize high value pages without extra steps
  • Create a single text file that any team can read and share

How to set this up?

  1. 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.
  2. You'll need accounts with OpenAI. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create an OpenAI credential: Click New > Search for OpenAI > Choose API Key > Name the credential clearly (for example, OpenAI SEO Classifier) > Paste your API key from your OpenAI account > Save.
  4. Open the Form trigger node and confirm the three fields are present: site name, site description, and file upload. Copy the form URL so you can submit a test later.
  5. Export a CSV of internal pages from your crawler. The internal HTML version works best. The internal all version is supported because the flow filters pages after import.
  6. Submit the form with the CSV, a site name, and a short summary. Run the workflow once to create sample data for testing.
  7. Open the Extract node output and check that rows are parsed. If fields look empty, confirm the CSV headers match the expected columns in your language.
  8. Review the Set useful fields node. Confirm URL, title, description, status, indexability, content type, and word count map correctly. Adjust mappings if your headers differ.
  9. Open the Filter URLs node and keep the default rules for 200 status, indexable, and text HTML. Add extra filters like word count or path rules if you want a tighter list.
  10. Optional: Enable the Text Classifier node. In its credential dropdown, pick your OpenAI credential. Start with a small batch to check token usage and classification results.
  11. Check the Set Row and Concatenate nodes. Confirm the output shows one line per page with the title, link, and description when available.
  12. Open the File creation node and run the workflow. Download the text file and review the content. If needed, rename the file to include the site name.
  13. Optional: Replace the placeholder upload node with a Google Drive or OneDrive node and configure folder, file name, and upload options.
  14. Troubleshooting: If the file fails to parse, verify the CSV delimiter and header names. If classification times out on large sites, add a Loop Over Items node and process in batches. If content type values differ, update the filter to match your crawler output.

Need help or want to customize this?

Ask in the Free Futurise Community.

Similar Templates

n8n
Marketing
Generate OpenAI Video Voiceovers
Turn any short video into a narrated audio file. Ideal for content teams that need quick voiceovers for social posts, product demos, and simple explainers. The outcome is a clean MP3 uploaded to your cloud folder for easy sharing. Here is how it works. A manual run starts an HTTP download of the video. A Python step uses OpenCV to capture up to 90 evenly spaced frames. Frames are split into groups of 15, converted to images, resized, and sent to an OpenAI chat model to write short parts of the script. Earlier outputs are included, so the story flows across batches. A wait step avoids rate limits. All partial texts are combined and sent to OpenAI text to speech to create a single MP3, then saved to Google Drive. Setup needs an OpenAI account and a Google Drive connection. Start with a small video to test memory use and adjust the frame limit or batch size if needed. Teams can cut scripting and recording time from hours to minutes and produce consistent voiceovers for product teasers, internal updates, and training clips.
3 views
view
n8n
Marketing
Generate OpenAI Voiceover to Google Drive
Turn short videos into clear voiceovers with one run. The automation pulls a video, writes a simple script from its frames, and produces audio you can store and share from Google Drive. Great for content teams, social clips, product demos, and quick explainers. A manual test starts by downloading a video from a URL. Python with OpenCV captures up to 90 evenly spaced frames from the clip. Frames are split into groups of 15, resized, and sent to an OpenAI model that can read images to draft parts of the narration. Each round adds to the story so the script stays consistent. A wait step helps avoid rate limits. The final script goes to OpenAI text to speech, and the mp3 file is uploaded to Google Drive. You will need an OpenAI API key and a Google Drive account. Keep videos small or limit frame count to avoid high memory use. Expect to reduce manual scripting and voice recording from hours to minutes for short clips. This setup fits teams that need frequent narrated content without studio work.
15 views
view
n8n
Marketing
Generate Telegram OpenAI Image Replies
Turn your Telegram bot into a smart chat assistant that can answer questions and create images on request. Great for marketing and social media teams that need fast mockups, product images, or quick visual ideas right in chat. Everyone can ask for text or images without leaving Telegram. Incoming Telegram messages start the flow. A GPT 4o chat model reads the message and keeps short memory of the last 10 messages per chat, so replies stay on topic and use the user’s first name. If a user asks for an image, the agent calls the Dall E 3 image API through a secure HTTP request and returns a direct image link. The bot then sends the image file back in Telegram. If no image is needed, a text reply is sent. All keys are stored as n8n credentials for safety. You need a Telegram bot token and an OpenAI API key. Connect both in n8n and link them to the trigger, chat model, tools, and send steps. Expect faster content turnarounds and fewer back and forth messages. Use it for ad mockups, social posts, sales visuals, or quick concept art in a team chat. Setup is simple and can be live in minutes.
4 views
view
See More 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.