Enrich FAQ Sections on Your Website Pages at Scale with AI

This n8n workflow automates the process of extracting and enriching FAQ sections from website pages using AI, then updating your content management system (CMS) with the improved data. It's designed to streamline content updates and ensure your FAQs are comprehensive and well-structured.

What it does

This workflow performs the following key steps:

1. Triggers Manually or via Sub-workflow: The workflow can be initiated manually or by another workflow (acting as a sub-workflow).
2. Reads Website Data: It retrieves website page data from a Google Sheet, which likely contains URLs or other identifiers for the pages to be processed.
3. Loops Through Pages: For each page entry, it iterates to process them individually or in batches.
4. Extracts Content: It makes an HTTP request to fetch the content of the specified website page.
5. Checks for FAQ Section: An 'If' node checks if the extracted website content contains an existing FAQ section.
6. Enriches FAQ with AI (if no FAQ exists):
   • If no FAQ section is found, it uses an OpenAI Chat Model via a Basic LLM Chain to generate a new FAQ section based on the page's content.
   • The generated FAQ is then formatted using an 'Edit Fields (Set)' node.
7. Updates CMS (Webflow or WordPress):
   • A 'Switch' node determines which CMS (Webflow or WordPress) to update based on a specified condition.
   • It then updates the relevant CMS with the enriched or newly generated FAQ content.
8. Stores Processed Data: The processed data, including the updated FAQ, is written back to Google Sheets and potentially Google Drive, likely for logging or further analysis.
9. Aggregates Results: The workflow aggregates the results from the different branches (FAQ found vs. FAQ generated) before concluding.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: Configured credentials for Google Sheets to read input data and write output.
• HTTP Request Node: No specific credentials, but access to the target website pages is required.
• OpenAI API Key: Credentials for OpenAI to use the Chat Model for AI-powered FAQ generation.
• Webflow Account: Configured credentials for Webflow if you intend to update Webflow CMS.
• WordPress Account: Configured credentials for WordPress if you intend to update WordPress CMS.
• Google Drive Account: Configured credentials for Google Drive for storing files.
• Strapi Account (Optional): Although present in the workflow, it's not connected in the provided JSON, suggesting it might be an alternative or future integration.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credentials.
   • Set up your OpenAI API key.
   • Configure either Webflow or WordPress credentials based on your CMS.
   • Set up your Google Drive credentials.
3. Prepare Input Data: Ensure your Google Sheet contains the necessary website page data (e.g., URLs) for the workflow to process.
4. Customize Nodes:
   • Adjust the "Google Sheets" node (ID 18) to point to your specific spreadsheet and sheet.
   • Configure the "HTTP Request" node (ID 19) to correctly fetch content from your website pages.
   • Modify the "If" node (ID 20) to accurately detect existing FAQ sections in your website content.
   • Fine-tune the "Basic LLM Chain" (ID 1123) and "OpenAI Chat Model" (ID 1153) prompts for optimal FAQ generation.
   • Adjust the "Edit Fields" (ID 38) node to format the AI-generated FAQs as needed.
   • Configure the "Switch" node (ID 112) and the respective "Webflow" (ID 480) or "Wordpress" (ID 118) nodes to correctly update your CMS.
   • Adjust the "Google Sheets" (ID 18) and "Google Drive" (ID 58) nodes for output storage.
5. Execute the Workflow:
   • You can execute it manually by clicking "Execute workflow" (using the "Manual Trigger" node, ID 838).
   • Alternatively, integrate it as a sub-workflow with another n8n workflow using the "Execute Workflow Trigger" (ID 837).