Automated email blast with follow-ups & response tracking
This n8n workflow automates email blasts with follow-ups and response tracking by reading contact data from a Google Sheet daily, looping through contacts to send personalized emails based on follow-up stages via Gmail, updating the sheet with status changes, and monitoring replies for logging. Why Use It This workflow streamlines email marketing campaigns by automating personalized email distribution, managing follow-up sequences, and tracking responses without manual intervention, saving time, improving engagement, and providing actionable insights into contact interactions. How to Import It Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. Configure Credentials: Set up Gmail and Google Sheets credentials in n8n. Run the Workflow: Activate the scheduled trigger and test with a sample Google Sheet. System Architecture Email Blast Pipeline: Daily Trigger - 9 AM: Initiates the workflow daily at 9 AM via Cron. Read Contact Data from Google Sheet: Fetches contact details from the sheet. Loop Through Contacts: Processes each contact individually. Determine Follow-Up Stage: Identifies the current stage for each contact. Send Main/Follow-Up Email: Delivers the appropriate email via Gmail. Update Sheet Status: Updates the Google Sheet with the latest status. Response Tracking Flow: Check Gmail for Replies: Monitors Gmail for email responses. Log Responses: Records responses in the Google Sheet. Google Sheet File Structure Sheet Name: EmailCampaign Range: A1:F10 (or adjust based on needs) | A | B | C | D | E | F | |------------|------------|---------------|---------------|---------------|---------------| | name | email | stage | lastemaildate | status | response | | John Doe | john@example.com | Initial | 2025-08-07 | Pending | | | Jane Smith | jane@example.com | Follow-Up 1 | 2025-08-06 | Sent | "Interested" | | Bob Jones | bob@example.com | Follow-Up 2 | 2025-08-05 | Replied | "Follow up later" | Columns: name: Contactβs full name. email: Contactβs email address for sending emails. stage: Current follow-up stage (e.g., Initial, Follow-Up 1, Follow-Up 2). lastemaildate: Date of the last email sent. status: Current status (e.g., Pending, Sent, Replied). response: Logged response from the contact (updated after reply detection). Customization Ideas Adjust Schedule: Change the Cron trigger to hourly or weekly based on campaign needs. Add Email Templates: Customize email content for different stages or audiences. Incorporate SMS: Add WhatsApp or SMS follow-ups using additional nodes. Enhance Tracking: Integrate a dashboard (e.g., Google Data Studio) for real-time campaign analytics. Automate Segmentation: Add logic to segment contacts by industry or interest for targeted emails. Requirements to Run This Workflow Google Sheets Account: For storing and managing contact data and responses. Gmail Account: For sending emails and checking replies (requires IMAP enabled). n8n Instance: With Google Sheets and Gmail connectors configured. Cron Service: For scheduling the daily trigger. Internet Connection: To access Google Sheets and Gmail APIs. API Credentials: Gmail OAuth2 and Google Sheets API credentials set up in n8n. --- Notes Ensure the Google Sheet is shared with the n8n service account or has appropriate permissions. Test the workflow with a small contact list to verify email delivery and response logging. Adjust the stage logic in the "Determine Follow-Up Stage" node to match your campaign structure.
By Oneclick AI SquadVisual storytelling content factory: Gemini & Replicate AI with human-in-the-loop publishing
This n8n workflow automates the entire content creation and publishing pipeline for engaging, AI-generated visual stories, ensuring image and video quality with human-in-the-loop approvals. What it does: It takes a narrative concept (e.g., 'A Day in the Life of a Serene Skeleton') and transforms it into a series of unique images and videos, which are then published across multiple social media platforms. How it works: Creative Conceptualization: An AI 'Creative Director' develops a detailed narrative, including scenes, moods, and character details. Prompt Engineering: An AI 'Creative Technician' translates the narrative into precise text-to-image and text-to-video prompts, maintaining a consistent artistic style, lighting, and character appearance. AI Asset Generation: Replicate's AI models (Qwen-Image for images and Seedance-1-Lite for videos) create the visual content from these prompts. Human-in-the-Loop Approval: Generated images and videos are sent to Slack for manual review. Users can approve or request regeneration, ensuring creative control and quality. Multi-Platform Publishing: Approved content is automatically published via Blotato to Instagram and Facebook (videos), and TikTok (image slideshows), ready for your audience. Technical Requirements: Replicate Account with Balance: For image and video generation (using Qwen-Image and Seedance-1-Lite). Blotato Subscription: For seamless publishing to multiple social media platforms. OpenRouter Account with Balance: To access various Large Language Models (LLMs) like Gemini 2.5 Flash for creative direction and prompt generation. Slack Account: For the human-in-the-loop approval process. Customization Potential: This workflow serves as a robust foundation that can be easily adapted for various use cases beyond story narratives, such as: Automating product publishing with AI-generated visuals and descriptions. Creating dynamic advertising content for campaigns. Generating personalized visual content for marketing. Scaling content creation for personal or e-commerce brands. Why use it? Ideal for content creators, marketers, and businesses seeking to scale their visual content production, maintain creative control through human oversight, and automate distribution (with scheduling option) to key social media channels (Instagram, Facebook, TikTok, X, Pinterest, YouTube, and more). Customize the initial story brief to unleash endless themed narratives tailored to your brand.
By Nadia PrivalikhinaAI testimonial extractor agent: feedback to marketing gold
AI Testimonial Extractor Agent: Feedback to Marketing Gold Subtitle: Feedback to Marketing Gold π Overview This workflow transforms raw customer feedback from Google Forms into short, emotionally engaging testimonials using Google Gemini. It then saves the testimonial back into Google Sheets and notifies the marketing team via email. Think of it as your automatic testimonial assistant. --- π’ Section 1: Trigger β Capture New Feedback π Node: New Form Response Trigger (Google Sheets Trigger) Watches for new rows added to a Google Sheet (linked to your form). Starts the workflow whenever a customer submits feedback. π‘ Why useful? No manual copy-pasting β the process kicks off instantly. π© Example: Someone fills in: > βThe product made my workflow so much easier β I finished tasks in half the time!β --- π¦ Section 2: AI Extraction with Gemini π Nodes: Extract Testimonial with Gemini β Uses Google Gemini Flash to rephrase the raw feedback into a concise testimonial. Google Gemini Chat Model β Supports the LLM chain. π§ Prompt Logic: Keep only the emotional & engaging part. Remove neutral/irrelevant text. Return only the testimonial quote. π‘ Why useful? Raw feedback is often long or messy β Gemini cleans it up into a marketing-ready quote. π© Example output: > βThis tool cut my work time in half and boosted my productivity instantly!β --- π£ Section 3: Save to Database π Node: Save Extracted Testimonial (Google Sheets) Saves the following data into the sheet: Timestamp Name Email Original Feedback Extracted Testimony π‘ Why useful? Keeps an organized log of all testimonials in one place. --- π‘ Section 4: Notify the Marketing Team π Node: Notify Marketing Team (Gmail) Sends an email alert with the new testimonial. Subject: New Testimonial Extracted Body: Contains the extracted quote. π‘ Why useful? Your team gets notified in real time β no need to keep checking the sheet. --- π Workflow Summary | Section | Node(s) | Purpose | Benefit | | ---------------- | --------------------- | -------------------------------- | -------------------------- | | π’ Trigger | Google Sheets Trigger | Detects new form submissions | Fully automated start | | π¦ AI Extraction | Gemini LLM Chain | Turns raw feedback β testimonial | Marketing-ready content | | π£ Save | Google Sheets | Logs testimonial + user info | Organized central database | | π‘ Notify | Gmail | Emails marketing team | Real-time updates | --- π Benefits Automation β No manual editing or sorting needed. Consistency β Every testimonial is short, emotional, and engaging. Centralized storage β Everything logged in Google Sheets. Team alignment β Marketing notified instantly. --- β‘ Bonus: You already added Sticky Notes inside the workflow β makes it beginner-friendly for anyone opening it in n8n. ---
By Yaron Been