Community Contributed: Congratulations Workflow

Name: Community Contributed: Congratulations Workflow
Rating: 1.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

50 views

0 downloads

Community Contributedautomationcongratulationsgoogle sheetspersonalizationschedulingsmstwilio

Automates sending personalized congratulatory messages based on calendar events.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automatically checks a Google Sheet for daily events. If an event occurs today, it retrieves congratulatory messages from another Google Sheet, personalizes them with names and phone numbers, and sends them via SMS using Twilio.

Key Features

Scheduled daily trigger.
Reads event data from a Google Sheet.
Checks for today's events.
Retrieves predefined congratulatory messages.
Personalizes messages with recipient names.
Sends personalized SMS messages via Twilio.

How To Use

Import the workflow: Upload the provided JSON to your n8n instance.
Configure Credentials: Set up and connect your Google Sheets and Twilio API credentials.
Set Google Sheets: Update the sheetId parameter for both Google Sheets nodes to match your spreadsheet IDs. Ensure the sheets are named correctly or adjust the ranges.
Configure Trigger: Adjust the cron node if you need the workflow to run at a different time.
Customize Messages: Populate the 'Congratulations Calendar' sheet with event dates and names, and the 'Congratulations Messages' sheet with greetings and phone numbers. Ensure the columns match the node configurations (e.g., 'Date', 'First Name', 'Phone Number', 'Congratulations').

Apps Used

automation

congratulations

google sheets

personalization

scheduling

sms

twilio

Workflow JSON

{
  "id": "2b98641b-bd5a-45db-993f-29ce60698a0d",
  "name": "Community Contributed: Congratulations Workflow",
  "nodes": 0,
  "category": "Community Contributed",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.