AI Automation
AI Integration
AI Content Repurposing is an independent automation project designed to simplify the process of adapting existing articles into content for multiple communication channels. Built with n8n, Gemini, and Google Sheets, the workflow retrieves article content and uses Gemini to generate drafts tailored to different formats, including LinkedIn posts, short-form social media content, and email communications. Rather than requiring separate content-generation processes for each channel, the workflow coordinates source retrieval, AI-powered content transformation, and structured output storage. The generated drafts are organized in Google Sheets, providing a central location for reviewing and working with content intended for different platforms. The project demonstrates how LLM-powered content generation can be integrated into a repeatable business workflow using existing automation tools. This is an independent technical case study, not a verified paid client engagement or production content-publishing system. No audience growth, engagement improvements, or content-production time savings are claimed.
Project details
Context
Publishing content across several channels often requires adapting the same underlying information into different formats. An article that works well as a long-form resource may need to be shortened, reorganized, or rewritten before it can be used as a LinkedIn post, a short social media update, or an email. Although these formats can communicate similar ideas, each has different expectations around length, structure, and presentation. Preparing separate versions manually can involve repeatedly reading the source article, identifying its main points, and drafting content for each channel. AI Content Repurposing explores how this process can be coordinated through an automated workflow. I developed an n8n automation that retrieves article content, sends it to Gemini for transformation, and organizes the generated drafts in Google Sheets. The workflow produces content for three communication formats: LinkedIn, short-form social media, and email. Google Sheets serves as the destination for the generated outputs, keeping the different content versions organized and accessible. The project focuses on content preparation and draft generation rather than automatically publishing material to external platforms.
The workflow was created to demonstrate AI-assisted content repurposing using existing automation services rather than a custom content-management application. n8n handles the orchestration, Gemini generates content variations, and Google Sheets stores the results. The distinction between content generation and publication is important. The workflow prepares drafts for multiple channels but is not presented as automatically posting to LinkedIn, publishing social media updates, or sending marketing emails. Generated content may still require editorial review for accuracy, tone, relevance, and suitability before publication. The project is a self-initiated automation demonstration, and no client adoption or measured business results are attributed to it.
Contribution
I independently designed and developed AI Content Repurposing using n8n, Gemini, and Google Sheets. My work covered article content retrieval, workflow orchestration, AI-powered content transformation, generation of channel-specific drafts, and structured organization of results.
My contribution focused on connecting the individual steps involved in turning existing articles into reusable marketing content. Instead of treating each channel as a separate content-generation task, the workflow uses the same source article to prepare multiple variations. I used n8n to coordinate the process, Gemini to transform the source material, and Google Sheets to organize the generated drafts. The implementation demonstrates how a language model can become part of a practical content-production workflow without requiring the development of a separate publishing application.
Designed and built an n8n workflow connecting article retrieval, AI-powered content generation, and structured output storage. Organized these activities into a repeatable process for transforming existing articles into content suitable for multiple channels.
Implemented the source-content retrieval stage that obtains article information for processing. Connected the retrieved material to the AI generation stage so Gemini could work from existing article content rather than generating unrelated topics.
Integrated Gemini to transform the retrieved article content into different communication formats. Used the source material as the basis for producing variations appropriate to the intended channels.
Developed the workflow to produce three categories of content: LinkedIn posts, short-form social media drafts, and email drafts. The implementation demonstrates how the same source material can support different content formats through AI-assisted transformation.
Organized the generated content into structured results that could be processed by the workflow and stored consistently. This separates individual content variations and makes them easier to retrieve after generation.
Connected Google Sheets as the output destination for the generated content. Archived the structured drafts so the different versions could be accessed and reviewed outside the automation workflow.
The project combines conventional workflow automation with language-model-based content generation. n8n coordinates the connected services, while Gemini performs the writing and content adaptation tasks. Google Sheets acts as a lightweight content repository, making the generated material accessible without requiring users to inspect individual n8n executions. The workflow is an independent demonstration focused on producing and organizing drafts. It is not presented as a complete content publishing, scheduling, or performance analytics platform.
Implementation
AI Content Repurposing uses n8n as its orchestration layer, Gemini as the content-generation model, and Google Sheets for storing structured outputs. The workflow begins by retrieving article content, passes the source material through AI-powered transformation, and produces drafts for LinkedIn, short-form social media, and email. The generated results are organized and archived in Google Sheets.
Implemented an article retrieval stage within the n8n workflow.
This stage obtains the source material used by Gemini to generate content variations.
Keeping the original article as the input allows the workflow to focus on adapting existing information instead of generating content without a source.
The retrieved material is passed to the subsequent AI processing stage.
Integrated Gemini into the workflow to transform article content into alternative formats.
The language model uses the retrieved source material to generate drafts intended for different communication channels.
This stage handles the writing and adaptation work, while n8n coordinates the surrounding retrieval and storage operations.
The resulting content is intended to serve as draft material that can be reviewed before external publication.
Developed the workflow to produce content in three distinct formats.
LinkedIn drafts provide a professional social media format, short-form social drafts present condensed versions of the source material, and email drafts adapt the content for email communication.
The workflow generates these variations from the article content, allowing one source to be used across several content-preparation tasks.
The implementation focuses on preparing drafts, not automatically distributing content through the destination platforms.
Organized the generated content into structured outputs suitable for downstream processing.
The workflow distinguishes the different content formats so they can be stored as separate, identifiable results rather than an undifferentiated block of generated text.
This makes the output easier to archive and retrieve through Google Sheets.
The structured format connects the language-model response to the conventional data-handling requirements of the workflow.
Integrated Google Sheets as the destination for generated content.
The workflow archives the structured output, providing a centralized location for the LinkedIn, short-form social, and email drafts.
Using a spreadsheet keeps the generated material accessible without introducing a dedicated application or database interface.
The stored content can serve as a starting point for editorial review and subsequent content preparation.
Connected article retrieval, Gemini content generation, output organization, and Google Sheets storage into an n8n workflow.
Each integrated service has a specific responsibility.
Article retrieval supplies the source material, Gemini generates content variations, and Google Sheets preserves the resulting drafts.
n8n coordinates these stages so the process can be executed as a connected automation rather than a series of disconnected manual tasks.
Outcomes
AI Content Repurposing demonstrates how an LLM can be integrated into a repeatable content-production workflow. The project connects article retrieval, AI-assisted writing, multi-channel draft generation, and spreadsheet storage. Its primary deliverables are a functioning automation workflow, generation of three content formats, and structured archiving of the resulting drafts. Because this was developed as an independent case study, no claims are made about production deployment, audience growth, content quality improvements, publishing frequency, or measured operational savings.
Deliverable
Built an n8n workflow that retrieves article content, generates channel-specific drafts using Gemini, and archives structured results in Google Sheets.
The workflow connects content retrieval, AI generation, and output storage into a single automation process.
Deliverable
Implemented AI-assisted generation of LinkedIn posts, short-form social media drafts, and email drafts from existing article content.
Measured impact
LinkedIn, short-form social media, and email.
The content variations are derived from a shared source article and prepared for different communication formats.
Deliverable
Integrated Gemini into an n8n workflow to transform retrieved source material into reusable content drafts.
Gemini handles content interpretation and generation while n8n coordinates the broader workflow.
Deliverable
Connected Google Sheets to store generated content in a structured format, providing a central location for accessing the different drafts.
The archive makes content available outside individual automation executions and supports subsequent review and use.
Deliverable
Combined article retrieval, AI-powered transformation, and draft storage into one workflow using existing services.
The project demonstrates integration of an LLM with conventional automation and spreadsheet tools without developing a standalone content management application.
Deliverable
Developed an independent technical demonstration of multi-channel content repurposing using n8n and Gemini.
The workflow is not presented as a paid client engagement or production publishing system. No measured engagement, conversion, revenue, or time-saving outcomes are attributed to it.