N8N Automation Specialist Needed

Workflow Overview:
1. Webhook Trigger for User Input:
• An n8n Webhook node captures input from a user (e.g., “Free trial starts today”).
• This input serves as the base content for a promotional message.
2. Language Model Integration (ChatGPT):
• The raw input is sent to a ChatGPT API node in n8n.
• A predefined prompt template guides ChatGPT to structure the input into a clear, professional promotional message.
• Example prompt:
“Rewrite the following message as a promotional offer with a call-to-action and urgency: ‘{{userInput}}’”
3. Data Retrieval from Google Sheets:
• Using the Google Sheets node, customer data (e.g., names, email addresses, phone numbers) is fetched from a designated spreadsheet.
• The data is iterated row-by-row to prepare for personalized delivery.
4. Automated Message Dispatch:
• Based on the contact data, the generated promotional message is sent via one or more communication channels:
• Email using the Email node (e.g., SMTP or Gmail)
• SMS using third-party integrations like Twilio or WhatsApp Business API
• Each message can be customized with customer-specific variables (e.g., name, discount code, link).

⸻

Example Use Case:
• User Input via Webhook:
"Free trial 2day"
• ChatGPT Output (after formatting):
“Start your Free Trial Today! Experience all premium features at no cost. Offer valid for 24 hours only. Start Now”