Collect content requests with a simple form, draft a full article with AI, and store everything in Google Drive with a log in Google Sheets. It is built for marketing teams and agencies that need fast production and clear tracking. Writers and managers can request structured content and get files and links in minutes.

After the form is submitted, the system saves the request to a sheet and creates a Drive folder named after the title. An AI model builds a Markdown outline, which is saved to the folder. The outline is split into sections, checked for headings, and each section is expanded with clear paragraphs. A random branch updates the format for about a quarter of sections to keep tone and layout fresh. Sections are sorted in the right order, merged with an introduction, and combined into a single article file, then uploaded and the link is written back to the sheet.

To run this in n8n Cloud, you need Google Drive and Google Sheets credentials and an OpenAI API key. Expect to cut drafting and assembly time from hours to minutes, while keeping a clean record of files and links for every request. It fits teams that produce blogs, SEO pages, and briefs at scale.

• Form intake collects title, target word count, keywords, and notes from a simple page
• Google Sheets append logs every request and later stores file links
• Google Drive folder is created and named after the content title
• AI generates a Markdown outline and the outline file is uploaded to Drive
• Outline is split into sections and headings are checked before writing
• Each section is expanded with AI paragraphs, with a 25 percent format change for variety
• Sorting and merging keep sections in the right order with a clean introduction
• Article is combined, converted to a text file, uploaded to Drive, and the link is written to the sheet
• A small code step adds line breaks for clear spacing between sections

• Reduce manual drafting and assembly from 2 hours to 15 minutes per article
• Streamline intake to publish steps by about 70 percent
• Cut formatting mistakes by using section rules and checks
• Connect Google Drive, Google Sheets, and OpenAI in one flow
• Handle many content requests per day without extra staff

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 Drive, Google Sheets and OpenAI. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create Google Drive credentials. Double click the Drive nodes and in the credential dropdown click Create new credential, then follow the on screen steps to connect your Google account.
4. In the n8n credentials manager, create Google Sheets credentials. Double click the Sheets nodes and create a new credential, then allow access to your Google account.
5. Create an OpenAI API key in your OpenAI account. In n8n, open each OpenAI node and create a new credential using your API key.
6. Open the form trigger node and confirm the path is set. Click Execute workflow to get a test URL and submit a sample form to verify the trigger.
7. In the Google Sheets nodes, set the correct document ID and sheet name. Use the picker if available to avoid typos.
8. In the Google Drive nodes, choose the parent folder where new content folders will be created. Confirm your account has write access.
9. Check the set and code nodes to confirm field mappings. Title, word count, keywords, and notes should map from the form to topic variables.
10. Run a full test. After submitting the form, confirm a new folder exists in Drive, the outline and final article files are inside, and a new row with links appears in your sheet.
11. If sections are empty, adjust the heading check in the If node or update the split pattern used to break the outline. If Google auth fails, reauthorize the credential. If OpenAI errors, verify the API key and model limits.