Turn a services list in Google Sheets into ready to publish Q and A content for your website or knowledge base. The flow builds consistent FAQ blocks for each tool or category, uses AI to fill gaps, saves clean JSON files to Google Drive, and can also send them to your CMS. It suits marketing and content teams that manage many integrations or product pages.

Under the hood, the flow starts on a manual run or from an internal trigger when processing in batches. It loops through four sheet types and pulls rows for each service. A switch chooses the right Q and A template based on the type of integration. OpenAI completes missing answers to keep tone and detail steady. The content is formatted as JSON, stored in Google Drive with a date stamp, and the Google Sheets row is marked done. Optional nodes push the result to Strapi, WordPress, or Webflow so pages update fast without copy paste work. Batching and self runs let you scale to hundreds of entries.

You will need a Google Sheets file with the four tabs listed in the template and a status column. Set your Google Drive folder for outputs and connect your OpenAI key. Pick a CMS and add credentials if you want to publish right away. Expect faster content delivery, fewer errors, and a repeatable process that fits a busy content calendar.

• Reads service rows from four Google Sheets tabs and tracks status updates
• Routes each row through a template set based on integration type using a Switch node
• Uses OpenAI to complete or improve answers for clearer and more natural text
• Builds clean JSON files and saves them to a chosen Google Drive folder with date stamped names
• Marks each processed row as done in Google Sheets to prevent duplicates
• Optionally sends the JSON to Strapi, WordPress, or Webflow to publish or store content
• Scales with Split In Batches and internal Execute Workflow calls for large lists
• Lets you edit Q and A templates directly in Set nodes for fast changes

• Reduce manual FAQ building from 2 hours to 10 minutes per service
• Automate up to 80 percent of repetitive writing with AI completion
• Improve data consistency by 90 percent by using one source of truth in Google Sheets
• Handle 10 times more entries with batching and internal runs
• Connect Google Sheets, Google Drive, and your CMS in one flow

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 Google Sheets, Google Drive, OpenAI, WordPress, Webflow and Strapi. See the Tools Required section above for links to create accounts with these services.
3. Create a Google Sheets file with four tabs named Single Integration Native, Single Integration Cred-only, Single Integration Non-native, and Categories. Include columns like displayName, status, and any fields referenced in the templates.
4. In n8n, double click the Google Sheets nodes and on the Credential to connect with dropdown, click Create new credential, then follow the on screen instructions to connect your Google account.
5. Open the Get Services node and choose your Google Sheets document and each sheet name so the node can read the right tabs.
6. Double click the Google Drive Create From Text node and on the Credential to connect with dropdown, click Create new credential, then follow the on screen instructions to connect Google Drive. Set the target Drive and folder or pass a folderId via the outdir field as shown in the template.
7. Double click the OpenAI Chat Model node and on the Credential to connect with dropdown, click Create new credential. Add your OpenAI API key from the official API page.
8. If you want to publish to a CMS, double click the Strapi, WordPress, or Webflow nodes. Click Create new credential and follow the instructions for each platform.
9. Review the Define Sheets and template Set nodes named Single Integration Native, Single Integration Cred-only, Single Integration Non-native, and Categories. Adjust the questions and answers to match your voice and details.
10. Open the Prepare Job or related Set nodes near the destination note and add values for outdir and any IDs you want to pass to the internal run so files save to the right folder.
11. Click Test workflow to run on a small batch. Confirm a JSON file appears in your Google Drive with the expected name and that the status column in Google Sheets changes to done.
12. If the CMS step is enabled, confirm the entry is created or updated. If you see auth errors, reconnect the credential. If no files appear, check the folderId or outdir value and sheet names. If AI steps fail, verify your OpenAI key and model settings.