How to Automate LinkedIn Content Creation with AI

1

Create Your Google Sheet

1. Go to Google Sheets
2. Create a new spreadsheet
3. Name it: LinkedIn Content Generator
4. Create 3 tabs (sheets) at the bottom:

Tab 1: “List”

Column A
Websites

This tab stores article URLs to scrape.

Tab 2: “Store Posts to Sheet”

Create these column headers:

executionId | chatId | postIndex | postText | imagePrompt | topic | sourceUrl | pendingImageId

This tab stores generated post options.

Tab 3: “Published”

Create these column headers:

postText | imagePrompt | topic | sourceUrl | imageId | publishedAt

This tab stores approved posts ready to publish.

2

Create Your Telegram Bot

1. Open Telegram and search for @BotFather
2. Send /newbot
3. Choose a name (e.g., “My LinkedIn Bot”)
4. Choose a username (e.g., “my_linkedin_content_bot”)
5. Save the API token – you’ll need it later

Your token looks like this:

3

Import the Workflow into n8n

1. Log into your n8n account
2. Click “Add workflow” → “Import from file”
3. Upload the JSON file you downloaded
4. The workflow will appear with red warning icons (that’s normal – we need to connect accounts)

4

Connect Your Accounts in n8n

You need to connect 4 services:

Connect Google Sheets

1. Click any Google Sheets node (green icon)
2. Click “Credential to connect with” → “Create new”
3. Choose “OAuth2”
4. Sign in with your Google account
5. Allow access

Connect Google Drive

1. Click the “Upload Image to Drive” node
2. Click “Credential to connect with” → “Create new”
3. Sign in with the same Google account

Connect Telegram

1. Click the “Telegram Trigger” node
2. Click “Credential to connect with” → “Create new”
3. Paste your Bot API Token from Step 2

Connect OpenAI

1. Click the “AI Generate Content Options” node
2. Click “Credential to connect with” → “Create new”
3. Paste your OpenAI API Key

5

Update Google Sheet References

Each Google Sheets node needs to point to YOUR spreadsheet:

1. Click on each Google Sheets node (there are several)
2. In “Document”, select your “LinkedIn Content Generator” spreadsheet
3. In “Sheet”, select the correct tab

Nodes to update:

• Read Website List → “List” tab
• Store Posts to Sheet → “Store Posts to Sheet” tab
• Read “Store Posts to Sheet” → “Store Posts to Sheet” tab
• Read Posts for Approved → “Store Posts to Sheet” tab
• Save to Published → “Published” tab
• Clear Old Links → “List” tab
• Add New Links → “List” tab

6

Update Google Drive Folder

1. Click the “Upload Image to Drive” node
2. Select the folder where you want images saved
3. Do the same for “Upload Regenerated Image” node

7

Activate the Workflow

1. Click the “Save” button (top right)
2. Toggle the “Active” switch to ON
3. Your workflow is now live!