Create & send GA4 report with insights via email
Who’s it for Marketing, growth, and analytics teams who want a decision-ready GA4 summary—automatically calculated, clearly color-coded, and emailed as a polished HTML report. How it works / What it does Get Client (Form Trigger) collects GA4 Property ID (“Account ID”), Key Event, date ranges (current & previous), Client Name, and recipient email. Overall Metrics This Period / Previous Period (GA4 Data API) pull sessions, users, engagement, bounce rate, and more for each range. Form Submits This Period / Previous Period (GA4 Data API) fetch key-event counts for conversion comparisons. Code normalizes form dates for API requests. AI Agent builds a valid HTML email: Calculates % deltas, applies green for positive (10B981) and red for negative (EF4444) changes. Writes summary and recommendations. Produces the final HTML only. Send a message (Gmail) sends the formatted HTML report to the specified email address with a contextual subject. How to set up 1) Add credentials: Google Analytics OAuth2, OpenAI (Chat), Gmail OAuth2. 2) Ensure the form fields match your GA4 property and event names; “Account ID” = GA4 Property ID. Property ID - https://take.ms/vO2MG Key event - https://take.ms/hxwQi 3) Publish the form URL and run a test submission. Requirements GA4 property access (Viewer/Analyst) • OpenAI API key • Gmail account with send permission. Resources Google OAuth2 (GA4) – https://docs.n8n.io/integrations/builtin/credentials/google/oauth-generic/ OpenAI credentials – https://docs.n8n.io/integrations/builtin/credentials/openai/ Gmail OAuth2 – https://docs.n8n.io/integrations/builtin/credentials/google/ GA4 Data API overview – https://developers.google.com/analytics/devguides/reporting/data/v1
By Simeon PenevSend personalized healthcare joke emails with OpenAI, Gmail, and Google Sheets
Healthcare Email Autoresponder - Daily Outreach 📧 A production-ready n8n workflow for automated healthcare email marketing with AI-powered personalization. 🎯 What This Workflow Does This automated email system sends daily personalized healthcare-themed emails to your contact list. Perfect for: Healthcare professionals building patient relationships Medical practices maintaining client engagement Wellness coaches staying connected with clients Health educators sharing daily motivation ✨ Key Features AI-Powered Personalization: Uses OpenAI to customize each email with recipient's name Smart Rate Limiting: Random 2-5 minute delays between emails to avoid spam filters Batch Processing: Limits to 10 emails per run for better deliverability Email Tracking: Updates Google Sheets to prevent duplicates and track progress Professional Templates: Healthcare-themed content with customizable signatures Automated Scheduling: Runs daily at 1 PM (customizable) 🛠️ Setup Instructions Prerequisites n8n instance (cloud or self-hosted) Gmail account for sending emails Google Sheets for contact management OpenAI API key Step 1: Import the Workflow Download the HealthcareEmailAutoresponderCommunityTemplate.json file In n8n, go to Templates and click "Import from File" Select the downloaded JSON file The workflow will be imported as inactive Step 2: Configure Credentials Gmail OAuth2 Setup: Click on the "Send Email" node Create new Gmail OAuth2 credential Follow n8n's Gmail setup guide Test the connection Google Sheets Setup: Click on the "HealthcareContactList" node Create new Google Sheets OAuth2 credential Replace YOURGOOGLESHEETIDHERE with your actual sheet ID Ensure your sheet has these columns: First Name Email Emailed (for tracking timestamps) OpenAI API Setup: Click on the "OpenAI Chat Model" node Create new OpenAI credential Add your OpenAI API key Select your preferred model (gpt-4o-mini recommended for cost efficiency) Step 3: Customize Your Email Template Click on the "AI Email Generator" node Edit the system message to include your details: Replace [YOUR NAME HERE] with your actual name Replace [YOUR TITLE HERE] with your professional title Replace [YOUR COMPANY HERE] with your company name Replace [YOUR PHONE NUMBER] with your phone number Replace [YOUR EMAIL] with your email address Replace [YOUR WEBSITE] with your website URL Step 4: Prepare Your Contact List Create a Google Sheet with the following structure: | First Name | Email | Emailed | |------------|-------------------|------------| | John | john@example.com | | | Jane | jane@example.com | | Important Notes: Leave the "Emailed" column empty initially The workflow will populate timestamps as emails are sent Only contacts with empty "Emailed" cells will receive emails Step 5: Test and Activate Test the workflow with a few sample contacts Check that emails are being generated and sent correctly Verify that Google Sheets is being updated with timestamps Once satisfied, activate the workflow 📊 Google Sheets Structure Your contact sheet should include these columns: First Name (required): Used for personalization Email (required): Recipient email address Emailed (required): Timestamp tracking (leave empty initially) Optional columns you can add: Last Name Company Phone Notes ⚙️ Customization Options Change Email Frequency Edit the "Daily Trigger (1 PM)" node Modify the schedule (hourly, daily, weekly) Set preferred time zones Adjust Batch Size Edit the "Limit to 10 Contacts" node Change maxItems value (recommend staying under 50) Modify Wait Times Edit the "Random Wait (2-5min)" node Adjust the random delay formula Current: {{ Math.floor(Math.random() * 4) + 2 }} (2-5 minutes) Update Email Content Edit the system message in "AI Email Generator" node Change the joke, signature, or entire email structure Add seasonal content or special promotions 🔧 Troubleshooting Common Issues: Emails not sending Verify Gmail credentials are active Check email quota limits Ensure recipient emails are valid Google Sheets not updating Confirm sheet ID is correct Check column names match exactly Verify Google Sheets credentials AI not generating content Validate OpenAI API key Check API quota and billing Test with different model if needed Rate limiting issues Increase wait times between emails Reduce batch size Check Gmail sending limits 📈 Best Practices Start Small: Begin with 5-10 contacts to test deliverability Monitor Metrics: Track open rates and responses Respect Privacy: Include unsubscribe options Stay Relevant: Update content regularly Follow Regulations: Comply with CAN-SPAM and GDPR 🤝 Contributing to the Community This template is designed to be: Easy to understand: Clear node names and documentation Production ready: Includes error handling and rate limiting Customizable: Template placeholders for personalization Well documented: Comprehensive setup instructions Feel free to adapt this workflow for your specific healthcare niche! 📄 License This workflow template is provided free to the n8n community under MIT License. 🆘 Support For questions or issues: Check the n8n community forum Review n8n's official documentation Test each node individually to isolate problems --- Made with ❤️ for the n8n community
By Ronnie CraigAutomatic Notion database backup to Google Drive with Telegram notifications
🔍 Workflow Overview What This Workflow Does This workflow automatically saves copies of all your Notion databases to Google Drive. It's like creating a safety backup of your important Notion information, similar to saving important documents in a filing cabinet. Target Audience: Anyone who uses Notion and wants to protect their data by creating automatic backups to Google Drive. --- Prerequisites (What You Need Before Starting) Required Accounts Notion Account - Where your databases are stored Google Account - For Google Drive storage Telegram Account - To receive backup notifications (free messaging app) Required Software n8n Community Edition v2.0.0 installed on your computer or server Web browser (Chrome, Firefox, Safari, or Edge) --- Step-by-Step Configuration Guide PART 1: Setting Up Notion Access Step 1: Create a Notion Integration Step 2: Share Your Databases with the integration --- PART 2: Setting Up Google Drive Access Step 1: Create a Google Drive Folder Step 2: Connect Google Drive to n8n --- PART 3: Setting Up Telegram Notifications Step 1: Create a Telegram Bot Step 2: Get Your Chat ID Step 3: Connect Telegram to n8n --- PART 4: Installing the Workflow in n8n Step 1: Import the Workflow Step 2: Configure Credentials For Notion nodes (Get All Databases, Get Database Pages) For Google Drive nodes (Create Backup Folder, Upload Backup File, etc.) For Telegram node (Send Telegram Notification) Step 3: Configure the Workflow Settings --- PART 5: Testing Your Workflow Step 1: Run a Test Step 2: Verify the Backup If Something Goes Wrong Red X marks on nodes: Check that all credentials are properly connected "Not found" errors: Make sure you shared your Notion databases with the integration No Telegram message: Verify your Chat ID is correct No files in Google Drive: Check your Folder ID is correct
By Prueba