make-com-automation-recipes

Here’s a ready-to-deploy Make.com automation recipe to **automatically create and schedule LinkedIn posts from a Google Sheet** every Monday at 9 AM. This recipe pulls content ideas, images, and hashtags from a Google Sheet, formats them into a polished LinkedIn post using AI (via Make’s built-in AI tools), and schedules the post using LinkedIn’s native scheduler. It also logs the post metadata (e.g., scheduled time, engagement metrics) back into the Google Sheet for tracking.

**JSON Blueprint (Copy-Paste into Make.com):**
```json
{
  "scenario": {
    "name": "LinkedIn Post Scheduler from Google Sheet",
    "modules": [
      {
        "id": "1",
        "type": "google-sheets",
        "operation": "get",
        "spreadsheet_id": "[YOUR_SPREADSHEET_ID]",
        "range": "A:D",
        "options": {
          "header_row": 1
        }
      },
      {
        "id": "2",
        "type": "ai",
        "model": "gpt-4",
        "prompt": "Format the following LinkedIn post content into a professional, engaging post. Include emojis and 3-5 relevant hashtags. Content: {{1.text}} {{1.image_url}} {{1.hashtags}}"
      },
      {
        "id": "3",
        "type": "linkedin",
        "operation": "schedule_post",
        "content": "{{2.output}}",
        "scheduled_time": "{{formatDateTime(addDays(now; 1); 'yyyy-MM-dd')T09:00:00Z')}"
      },
      {
        "id": "4",
        "type": "google-sheets",
        "operation": "append",
        "spreadsheet_id": "[YOUR_SPREADSHEET_ID]",
        "range": "E:F",
        "values": [
          ["{{3.post_id}}", "{{formatDateTime(now; 'yyyy-MM-dd HH:mm')}}"]
        ]
      }
    ]
  }
}
```

**Step-by-Step Instructions:**
1. **Set Up Google Sheet**: Create a sheet with columns for `text`, `image_url`, `hashtags`, and `status` (e.g., "Pending", "Posted").
2. **Add Make.com Scenario**: Paste the JSON blueprint into Make.com’s scenario editor. Replace `[YOUR_SPREADSHEET_ID]` with your actual Google Sheet ID.
3. **Configure AI Module**: Ensure your Make.com account has access to the AI module (GPT-4 or similar). Adjust the AI prompt if needed.
4. **Connect LinkedIn**: Authorize Make.com to post to your LinkedIn page via the LinkedIn module.
5. **Test & Schedule**: Run a test post to verify the workflow, then set the scenario to run weekly (e.g., every Monday at 9 AM).

**How It Works:**
- The scenario starts by fetching new rows from the Google Sheet where `status = "Pending"`.
- The AI module formats the raw content into a polished LinkedIn post.
- The post is scheduled using LinkedIn’s API, and the `post_id` + timestamp are logged back into the sheet.
- The `status` column auto-updates to "Posted" (you can add a webhook to trigger this if needed).

**Pro Tip**: Add a filter module after the Google Sheets step to only process rows where `status = "Pending"`. This avoids reprocessing old posts.