AutomationFlowsSocial Media › Schedule Weekly Facebook Posts From Google Sheets Every Sunday

Schedule Weekly Facebook Posts From Google Sheets Every Sunday

ByShelly-Ann Davy @SheCodesFlow on n8n.io

Automate your social media with grace and simplicity. The SoftTech Sunday Scheduler is a no-code Google Sheets + Make (formerly Integromat) integration that lets solopreneurs plan, schedule, and publish a full week of Facebook and Instagram content in under a minute—every Sunday…

Event trigger★★★★☆ complexity19 nodesHTTP RequestEmail SendTelegram
Social Media Trigger: Event Nodes: 19 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #7977 — we link there as the canonical source.

This workflow follows the Emailsend → HTTP Request recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "categories": [
      "Business",
      "CRM",
      "Marketing",
      "Automation"
    ],
    "description": "Automated client nurture email system that sends personalized milestone emails at 7, 30, and 60 days based on Notion database tracking with Telegram notifications",
    "templateVersion": "1.0.0",
    "templateCreatedBy": {
      "id": "n8n-professional",
      "name": "n8n Professional Templates"
    },
    "templateCredentials": [
      "notionApi",
      "smtp",
      "telegramApi"
    ]
  },
  "name": "Automate client nurture emails and testimonial collection from Notion",
  "tags": [
    "crm",
    "email",
    "notion",
    "automation",
    "nurture"
  ],
  "nodes": [
    {
      "id": "main-documentation",
      "name": "\ud83d\udccb Workflow Documentation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        40
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "config-documentation",
      "name": "\u2699\ufe0f Configuration Guide",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "workflow-config",
      "name": "\ud83d\udd27 Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        920,
        180
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "manual-trigger",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        920,
        340
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "schedule-trigger",
      "name": "Daily at 9 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        920,
        460
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "get-today-date",
      "name": "Get Today's Date",
      "type": "n8n-nodes-base.code",
      "position": [
        1160,
        400
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "query-notion",
      "name": "Query Notion Database",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1400,
        400
      ],
      "parameters": {},
      "typeVersion": 4.1
    },
    {
      "id": "calculate-milestones",
      "name": "Calculate Milestone Days",
      "type": "n8n-nodes-base.code",
      "position": [
        1640,
        400
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "if-day-7",
      "name": "Is Day 7?",
      "type": "n8n-nodes-base.if",
      "position": [
        1880,
        300
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "if-day-30",
      "name": "Is Day 30?",
      "type": "n8n-nodes-base.if",
      "position": [
        1880,
        400
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "if-day-60",
      "name": "Is Day 60?",
      "type": "n8n-nodes-base.if",
      "position": [
        1880,
        500
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "email-day-7",
      "name": "Send Day 7 Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2120,
        300
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "email-day-30",
      "name": "Send Day 30 Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2120,
        400
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "email-day-60",
      "name": "Send Day 60 Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2120,
        500
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "telegram-notify",
      "name": "Notify via Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        2360,
        400
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "webhook-testimonial",
      "name": "Testimonial Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        920,
        680
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "parse-testimonial",
      "name": "Parse Testimonial Data",
      "type": "n8n-nodes-base.code",
      "position": [
        1160,
        680
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "telegram-testimonial",
      "name": "Notify New Testimonial",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1400,
        680
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "respond-webhook",
      "name": "Respond to Webhook",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        1640,
        680
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1",
    "saveManualExecutions": true
  },
  "updatedAt": "2025-09-29T12:00:00.000Z",
  "versionId": "1.0.0",
  "staticData": null,
  "connections": {
    "Is Day 7?": {
      "main": [
        [
          {
            "node": "Send Day 7 Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Day 30?": {
      "main": [
        [
          {
            "node": "Send Day 30 Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is Day 60?": {
      "main": [
        [
          {
            "node": "Send Day 60 Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily at 9 AM": {
      "main": [
        [
          {
            "node": "Get Today's Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Get Today's Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Today's Date": {
      "main": [
        [
          {
            "node": "Query Notion Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 7 Email": {
      "main": [
        [
          {
            "node": "Notify via Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 30 Email": {
      "main": [
        [
          {
            "node": "Notify via Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 60 Email": {
      "main": [
        [
          {
            "node": "Notify via Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Testimonial Webhook": {
      "main": [
        [
          {
            "node": "Parse Testimonial Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Query Notion Database": {
      "main": [
        [
          {
            "node": "Calculate Milestone Days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Notify New Testimonial": {
      "main": [
        [
          {
            "node": "Respond to Webhook",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse Testimonial Data": {
      "main": [
        [
          {
            "node": "Notify New Testimonial",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Milestone Days": {
      "main": [
        [
          {
            "node": "Is Day 7?",
            "type": "main",
            "index": 0
          },
          {
            "node": "Is Day 30?",
            "type": "main",
            "index": 0
          },
          {
            "node": "Is Day 60?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "triggerCount": 2
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Automate your social media with grace and simplicity. The SoftTech Sunday Scheduler is a no-code Google Sheets + Make (formerly Integromat) integration that lets solopreneurs plan, schedule, and publish a full week of Facebook and Instagram content in under a minute—every Sunday…

Source: https://n8n.io/workflows/7977/ — original creator credit. Request a take-down →

More Social Media workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Social Media

Once set up, simply send any Instagram Reel or Facebook video link to your Telegram bot, and it will automatically: Check if the shared link is valid. Detect whether it’s an Instagram or Facebook link

Telegram Trigger, HTTP Request, Telegram
Social Media

> Download TikTok videos instantly without watermarks via Telegram > Fast, reliable, and user-friendly automated workflow

Telegram Trigger, Telegram, HTTP Request
Social Media

Desafio RPA TikTok - Bot Dinâmico Master. Uses telegramTrigger, httpRequest, telegram, errorTrigger. Event-driven trigger; 21 nodes.

Telegram Trigger, HTTP Request, Telegram +1
Social Media

This n8n workflow automates the creation and publishing of Instagram carousel posts by downloading images from Google Drive, uploading them to Cloudinary for hosting, and publishing them as a coordina

Google Drive, HTTP Request, Telegram +1
Social Media

This n8n workflow allows users to convert any YouTube video to MP3 using the YouTube To MP3 Fast API on RapidAPI. It handles the entire process end-to-end — from form input to automatic delivery via e

Form Trigger, HTTP Request, Google Drive +1