Skip to content

README.md

Latest commit

 

History

History
52 lines (33 loc) · 1.66 KB

README.md

File metadata and controls

52 lines (33 loc) · 1.66 KB
Raw

Dnyx Newsletter – Tech & AI (Full)

Purpose

Fully automated newsletter pipeline — curates tech & AI content, generates an AI-written newsletter, and sends it to subscribers from a Google Sheets list.

Trigger Type

Webhook (HTTP POST)

Input Format

Subscriber list in Google Sheets; triggered manually or on schedule.

Output Format

Formatted HTML newsletter emailed to all active subscribers.

External Services Used

Google Sheets

High-Level Flow

  1. Trigger fires (manual or scheduled)
  2. Subscriber list loaded from Google Sheets
  3. Latest tech/AI news fetched via HTTP requests
  4. OpenAI generates editorial content and newsletter body
  5. HTML newsletter assembled with formatting
  6. Gmail sends newsletter to each active subscriber
  7. Send count and last-sent date updated in Google Sheets

Required Environment Variables / Credentials

  • OPENAI_API_KEY — (set in n8n credentials or environment)
  • GOOGLE_SHEETS_ID — (set in n8n credentials or environment)
  • SENDER_EMAIL — (set in n8n credentials or environment)
  • NEWSLETTER_FROM_NAME — (set in n8n credentials or environment)

Note: All credentials must be configured in n8n's Credentials manager.
Never hardcode secrets in the workflow JSON.

Setup Instructions

  1. Import dnyx-newsletter-tech-ai-full.json into your n8n instance via Workflows → Import from file.
  2. Open the workflow and configure all credential nodes (look for nodes marked with a credential warning).
  3. Set the required environment variables in n8n's settings or your .env file.
  4. Activate the workflow.

Generated by n8n Workflow Auditor · Safe for public GitHub upload.