🧠 Project Name:
Automated LinkedIn Post Generator with AI, Google Sheets & Make.com
🔧 What This Workflow Does:
Generates bi-weekly LinkedIn post drafts using AI, based on your voice and a list of projects stored in Google Sheets, and sends the generated post to Slack for review.
✅ Tools Used:
Google Sheets (content database)
Make.com (automation tool)
Together.ai (for LLaMA-3 AI model)
Slack (to receive drafts)
🗂️ Step-by-Step Tutorial:
🔹 Step 1: Prepare Google Sheets
Create a Google Sheet with the following columns:
Topic - include a list of topics the AI can pull form randomly
Here is what I used: https://docs.google.com/spreadsheets/d/1mcCp8Z5ov0VNqr5Eqdh2qC3RPg4Uramusmh2-5CSG_o/edit?usp=sharing
🔹 Step 2: Set Up Make.com Scenario
Trigger Module:
🔸 Google Sheets → Watch RowsConnect to your Sheet
Choose the tab (e.g. “TopicsPool”)
Trigger: “When row is added or updated”
Set a limit (e.g. A1)
AI Module (HTTP):
🔸 HTTP → Make a RequestURL: https://api.together.xyz/v1/chat/completions
Method:
POST
Headers:
Authorization: Bearer YOUR_OPENROUTER_API_KEY
Content-Type: application/json
Body type: Raw (JSON)
Body JSON (Use this in your request):
{
"model": "meta-llama/Llama-3-8b-chat-hf",
"messages": [
{
"role": "system",
"content": "You are a helpful assistant that writes bi-weekly LinkedIn posts in the user's unique voice, using the provided project information. Write posts in the voice and tone demonstrated here: {{3.ToneSamples}}"
},
{
"role": "user",
"content": "Please write a detailed LinkedIn post (250–300 words) about the following project: {{3.ProjectDetails}}. It should highlight key benefits, what tools were used, and how it helps save time or increase impact."
}
],
"temperature": 0.7,
"max_tokens": 800
}
📝 Replace {{3.ToneSamples}}
and {{3.ProjectDetails}}
with the mapped fields from your Google Sheet (row 3 corresponds to the module number in Make — adjust if different).
3. Create a Slack App & get a webhook URL
Go to https://api.slack.com/apps and click Create New App.
Name it (e.g., “LinkedIn Draft Notifier”) and select your workspace.
On the left menu, click Incoming Webhooks.
Turn on Activate Incoming Webhooks.
Scroll down, click Add New Webhook to Workspace.
Choose the Slack channel where you want the messages (e.g., #personal-notifications).
Click Allow.
Copy the generated Webhook URL — you’ll need this in Make.
Build your scenario in Make
Log in to https://www.make.com/ and create a new Scenario.
Add your AI step (HTTP module or whatever you use to get draft text).
Add a Slack module:
Choose Slack > Send a Message (via webhook).
Paste your Slack webhook URL.
For the message text, map the AI-generated draft content here.
Connect the modules so that once the AI generates a draft, it triggers the Slack message.
Set your scenario to run on schedule: every 2 weeks (bi-weekly).
Save and turn it on.
🔹 Step 5 (Optional): Add Delay or Filtering
Use the Filter module to run only when a new or changed row has content
You can also add Delay if you want to wait before processing
🎯 Final Output
You now have:
A system that auto-generates full LinkedIn post drafts
Pulls content and tone from Google Sheets
Sends it to Slack for review
Uses free LLM (LLaMA-3 8B via Together.ai)