Generate AI-Enriched FAQ JSON from Google Sheets with n8n

What this workflow does

This workflow reads integration details from multiple Google Sheets tabs and creates enriched FAQ question-answer pairs automatically.

It uses OpenAI’s GPT AI to make FAQ answers clear and complete.

The output is organized JSON files saved in Google Drive folders by integration type.

This stops the manual, slow, error-prone work of writing FAQs yourself.

Who should use this workflow

This workflow fits product managers, documentation teams, and anyone managing many software integrations FAQs.

It helps those who use Google Sheets to keep FAQ data and want fast, consistent FAQ JSON files.

You should have some basics of n8n and API credentials ready.

Tools and services used

• Google Sheets: Source for integration FAQ data.
• Google Drive: Stores output FAQ JSON files organized by categories.
• OpenAI GPT: Enhances and completes FAQ answers for better quality.
• n8n automation platform: Runs the entire workflow orchestration and processing.
• Optional CMS platforms: Like Strapi, WordPress, Webflow can be added for direct FAQ publishing.

Beginner step-by-step: How to use this workflow in n8n

Step 1: Import the workflow

1. Download the workflow file using the Download button on this page.
2. Open n8n editor where you want to run the automation.
3. Choose “Import from File” and select the downloaded workflow file.

Step 2: Add credentials

1. In n8n, go to Credentials and add Google Sheets and Google Drive API credentials.
2. Add OpenAI API Key for GPT model access.

Step 3: Configure folder and sheet details

1. Update Google Drive folder IDs in the Prepare Job node with your actual folder IDs.
2. Check that sheet names in Define Sheets node exactly match your Google Sheets tabs.

Step 4: Test the workflow

1. Use the When clicking ‘Test workflow’ node to start the process manually.
2. Observe the workflow run and check that JSON files appear in the correct Drive folders.
3. Verify status columns in Google Sheets update to “done” for processed rows.

Step 5: Activate workflow for ongoing use

1. Once happy with test results, activate the workflow using the toggle switch.
2. You can replace the manual trigger with a scheduler or webhook node for automatic runs.
3. Watch execution logs in n8n for any errors or problem rows.

Check out self-host n8n if better hosting control or cost savings are needed.

Inputs, processing steps, and outputs

Inputs

• Multiple tabs in a Google Sheets document containing integration FAQ raw data.
• Google Drive folders to store generated JSON.
• OpenAI GPT API Key to query AI model for answer completion.

Processing steps

• Read each sheet’s rows filtered by status to find unprocessed items.
• Set variables including folder ID and raw row data.
• Route rows through branches for different integration types to build tailored FAQ templates.
• Break FAQ questions into lists for sequential AI completion.
• Use GPT to complete or improve answers with friendly, clear language.
• Format and combine completed Q&A pairs into one FAQ JSON object.
• Create JSON files named with integration and date in correct Drive folder.
• Mark processed Google Sheets rows as done to avoid repeats.

Outputs

• JSON FAQ files saved in categorized Google Drive directories.
• Google Sheets rows updated with processed status.

Customization ideas

• Change GPT model in OpenAI Chat Model node to try different answer styles or speeds.
• Add more FAQ question-answer templates inside Set nodes for your integration needs.
• Redirect JSON outputs by editing folder IDs in Prepare Job node.
• Insert CMS publishing nodes after status update node to post FAQs directly on your site.
• Switch the manual trigger to a webhook or scheduler in When clicking ‘Test workflow’ node for automation.

Common errors and troubleshooting

• Issue: “No rows found after Get Services node”
  Cause: Status column filtering no matches or all rows done.
  Fix: Check status values in sheets; ensure some rows are empty or match the filter.
• Issue: Errors or empty output from AI Completion1 node.
  Cause: Incorrect or expired OpenAI API key or model misconfigured.
  Fix: Check API key in credentials, test with simple prompts, verify model name.
• Issue: JSON files not created in Drive.
  Cause: Wrong folder IDs or insufficient Drive permissions.
  Fix: Confirm Google Drive folder IDs in Prepare Job node, check API scopes.

Summary: Workflow benefits and outcome

✓ Saves hours by automating FAQ creation from Google Sheets data.

✓ Makes FAQ answers clear and complete using AI assistance.

✓ Outputs structured, organized JSON files ready for help centers or websites.

✓ Updates Google Sheets to avoid repeat processing.

✓ Easy to extend with CMS publishing or scheduling triggers.