top of page

Automated LinkedIn Content Generator

ree




Project Overview

This smart automation workflow transforms a simple spreadsheet into an AI-powered content creation engine. It scans for pending article ideas and generates LinkedIn posts based on web research and OpenAI, ready to scale your thought leadership



Use Case


You maintain a list of article ideas in Google Sheets — each with a title and status ("To do", "Completed", etc.). This automation checks for ideas marked as “To do”, conducts a smart web search on the topic using Tavily, and generates a LinkedIn-style post using OpenAI. It then writes the completed content back into the same row of the sheet.



Tech Workflow (simplified for a general audience)


Trigger: User clicks "Execute Workflow" to begin content creation

Scan Sheet: The system reads a Google Sheet with article ideas

Detect Topic: It finds the first topic marked as "To do"

Web Search: Tavily performs an AI-powered search to gather relevant information

Content Creation: OpenAI generates a LinkedIn-style post based on the search results

Save & Update: The final content is written back into the sheet and marked as "Completed"



Tools Used:


  • Google Sheets: Stores your content pipeline

  • Tavily API: AI-powered web search (retrieves recent, relevant data)

  • OpenAI Chat Model: Converts research into polished, engaging content

  • n8n AI Agent: Coordinates logic, memory, and prompt chaining




Why Tavily?

Tavily is an AI-powered web search API that brings up-to-date, relevant summaries from across the web. It ensures your AI-generated content is grounded in facts and enriched with context — avoiding hallucinations or generic fluff.



Visual Preview


The content creation workflow scans this Google Sheet to identify article ideas marked as “To do”, and automatically generates draft content using AI.
The content creation workflow scans this Google Sheet to identify article ideas marked as “To do”, and automatically generates draft content using AI.

Automated flow in n8n that connects Google Sheets, Tavily, and OpenAI. It fetches pending topics, performs AI-powered research, generates a LinkedIn post, and updates the original sheet.
Automated flow in n8n that connects Google Sheets, Tavily, and OpenAI. It fetches pending topics, performs AI-powered research, generates a LinkedIn post, and updates the original sheet.

Summary


This automation transforms a simple content pipeline into a fully AI-powered writing assistant. By connecting Google Sheets with Tavily and OpenAI via n8n, it identifies pending article ideas, enriches them with real-time web context, and generates ready-to-publish LinkedIn posts. It’s a scalable and efficient solution for thought leadership and content marketing — without manual effort.


bottom of page