Workflow Goal

Automate the journey from a Google Form submission to a drafted blog post and social media announcement, reducing manual data entry for Malathi, Nivetha, and future nominees.

The n8n Workflow Blueprint.

Step 1: The Trigger (Data Ingestion)

• Node: Google Forms Trigger

• Action: n8n "listens" for a new response in your Spotlight 2026 nomination form.

• Data Captured: Name, Business Name, Location, Website, and their "Why me?" story.

Step 2: The Logic Engine (Data Formatting)

• Node: Set / Code Node

• Action: Clean up the data. It ensures URLs have https://, names are capitalized correctly, and images are extracted from the Google Drive links provided in the form.

Step 3: The AI Brain (Content Generation)

• Node: AI Agent (powered by Gemini or GPT-4o)

• Prompt: "You are an expert PR writer. Take this nomination data and write:

  1. A 300-word inspiring blog post.

  2. A professional LinkedIn post.

  3. A punchy Twitter (X) post."

• Memory: Connect a Window Buffer Memory node so the AI remembers the "Spotlight 2026" branding guidelines across all nominees.

Step 4: The Output (Multi-Channel Publishing)

• Branch A (Drafting): Send the blog content to Google Docs or WordPress as a "Pending Review" draft.

• Branch B (Approval): Send a notification to your Slack/WhatsApp with a button: "Approve for Social Media?"

• Branch C (Publishing): Once approved, the LinkedIn and Twitter nodes post the content automatically with the nominee's image.

Why use this for your Spotlight campaign?