Create LinkedIn posts from articles with OpenAI, Pexels and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every day at 12:00). Along the way it connects Google Sheets, OpenAI Chat Model, Google Drive and LinkedIn and 1 more. It also calls api.tavily.com, api.pexels.com and api.linkedin.com over HTTP.
How it runs
Trigger: On a schedule (every day at 12:00).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- HTTP Request: calls api.tavily.com (POST)
- Generate Content (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- AI Image Query Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Fetch images from web (HTTP Request): calls api.pexels.com
- AI Image Selector (OpenAI): analyze (image)
- Fetch Url (Code): runs custom JavaScript code
- Fetch Actual Image (HTTP Request): calls an HTTP API
- Download Image (Google Drive): uses Google Drive
- Post Image to LinkedIn (HTTP Request): calls api.linkedin.com (POST)
…plus 3 more steps. See the full node list below.
Services it uses
HTTP calls to: api.tavily.com, api.pexels.com, api.linkedin.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Drive
n8n-nodes-base.googleDrive - LinkedIn
n8n-nodes-base.linkedIn - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code
From the author
Quick overview This workflow runs on a daily schedule, reads a “TO DO” topic from Google Sheets, uses Tavily and OpenAI to generate a LinkedIn post, finds and selects a matching image from Pexels, uploads the image to LinkedIn, publishes the post, and writes…