🧠 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 Rows
- Connect 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 Request
- URL: 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.