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 from randomly.

Here is what I used: Google Sheet Link

🔹 Step 2: Set Up Make.com Scenario

This scenario involves three main modules:

1. Trigger Module (Google Sheets - Watch Rows):
• Connect to your Sheet.
• Choose the tab (e.g. "Topics/Post").
• Trigger: "When row is added or updated".
• Set a limit (e.g. "43").
2. AI Module (HTTP - Make a Request):
• URL: `https://api.together.ai/v1/chat/completions`
• Method: POST
• Headers:
  • Authorization: Bearer `YOUR_OPENAI/TOGETHER_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 weekly LinkedIn posts in the user's voice using the provided project information. Write posts in the voice and tone demonstrated here: [1.ToneSamples]"
          },
          {
              "role": "user",
              "content": "Please write a detailed LinkedIn post (250 - 300 words) about the following project: [1.ProjectDetails]. It should highlight key benefits, what tools were used, and how it helps save time or increase impact."
          }
      ],
      "temperature": 0.7,
      "max_tokens": 400
  }

• *Replace `[1.ToneSamples]` and `[1.ProjectDetails]` with the mapped fields from your Google Sheet (row 1 corresponds to the module number in Make - adjust if different).*

🔹 Step 3: Create a Slack App & get a webhook URL

Go to https://api.slack.com/apps and click Create New App.

1. Name it (e.g., "LinkedIn Draft Notifier") and select your workspace.
2. On the left menu, click Incoming Webhooks.
3. Turn on Activate Incoming Webhooks.
4. Scroll down, click Add New Webhook to Workspace.
5. Choose the Slack channel where you want the messages (e.g., `#personal-notifications`).
6. Click Allow.
7. Copy the generated Webhook URL—you’ll need this in Make.

🔹 Step 4: Build your scenario in Make

1. Log in to https://www.make.com/ and create a new Scenario.
2. Add your AI step (HTTP module or whatever you use to get draft text).
3. 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.
4. Connect the modules so that once the AI generates a draft, it triggers the Slack message.
5. Set your scenario to run on schedule (every 7 weeks, bi-weekly, etc.).
6. Save and turn it on.

🔹 Step 5 (Optional): Add Delay or Filtering

Use the Filter module to run only whenever a new or changed row has content.

You can also add Delay if you want to wait before processing.