Gmail and MongoDB integration

How it works This workflow runs on a daily schedule to monitor users currently on a trial plan. It fetches user data from MongoDB, calculates their trial stage, and assigns a trigger label such as Day 3, Day 7, Day 13, or Last Day. Based on this stage, the workflow sends a targeted email using Gmail. This ensures consistent engagement and improves trial-to-paid conversion without manual effort. Step-by-step Fetch and filter trial users** Schedule Trigger – Runs the workflow daily at a fixed time. Find documents – Retrieves users with an active trial plan from MongoDB. Code in JavaScript – Calculates trial progress and assigns a trigger type (day_3, day_7, day_13, last_day). Send stage-based emails** Loop Over Items – Iterates through each filtered user. Switch – Routes users based on their trigger type. Send day 3 email – Sends onboarding encouragement email. Send day 7 mail – Sends mid-trial engagement email. Send day 13 mail – Sends near-expiry reminder email. Send Last day email – Sends final urgency email before trial ends. Merge – Combines all branches and continues looping for remaining users. Why use this? Automates user engagement throughout the trial lifecycle Improves activation and feature adoption with timely nudges Increases conversion rates with strategic email timing Eliminates manual tracking of trial users Scales easily for large SaaS user bases

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Workflow: *Daily News Aggregator & MongoDB Storage This workflow is designed to run seamlessly in the background, automating the full cycle of news aggregation, storage, and reporting with precision and reliability. Daily Trigger (Cron Node) The process kicks off every morning at 8:00 AM UTC. This scheduling ensures that fresh global news is captured consistently at the start of each day. Perplexity Node At the heart of the workflow, a Perplexity node queries the latest global news. The prompt specifies both the type of news and the JSON structure required, guaranteeing the output is ready for structured storage. The result is a clean feed of headlines, timestamps, sources, and URLs. Data Formatting (Code Node) Since Perplexity’s response is a string, the workflow includes a custom JavaScript function to clean and parse it into a valid JSON array. Each news item is then transformed into its own object, ready for iteration. MongoDB Insertion (Loop Node) Each news article is inserted into the daily_news collection in MongoDB. The workflow ensures that fields such as headline, timestamp, source, URL, and category are stored neatly, with additional metadata available for future filtering and analysis. Aggregation & Notification Prep (Code Node) Once all items are stored, the workflow aggregates the day’s results. This step prepares a digest of what was successfully processed, ensuring visibility into the pipeline’s performance. Email Notification (Gmail Node) Finally, a summary email is sent via Gmail. This message confirms the operation’s success and provides a quick snapshot of the news collected and stored that day. Workflow Flow Cron Trigger → Perplexity API → Format Data → MongoDB Insert → Aggregate Results → Send Email Notification This setup transforms what could be a manual, repetitive task into a streamlined daily routine. It not only guarantees timely and structured storage of news but also provides immediate confirmation, making it an elegant solution for automated information management.