Register users to an event on Demio via Typeform
This workflow allows you to register your audience to an event on Demio via a Typeform submission. Typeform Trigger node: This node will trigger the workflow when a form response is submitted. Based on your use-case, you may use a different platform. Replace the Typeform Trigger node with a node of that platform. Demio node: This node registers a user for an event. It gets the details of the users from the Typeform response.
By Harshil AgrawalMonitor solar energy production & send alerts with Gmail, Google Sheets, and Slack
Solar Energy Production Monitoring Alert Workflow This workflow automatically monitors solar energy production every 2 hours by fetching data from the Energidataservice API. If the energy output falls below a predefined threshold, it instantly notifies users via email. Otherwise, it logs the data into a Google Sheet and posts a daily summary to Slack. Who’s It For Renewable energy teams monitoring solar output. Facility managers and power plant supervisors. ESG compliance officers tracking sustainability metrics. Developers or analysts automating solar energy reporting. How It Works Trigger: The workflow starts every 2 hours using a Schedule Trigger. Data Fetch: An HTTP Request node fetches solar energy production data from the Energidataservice API. Processing: A Code node filters out entries with production below the minimum threshold. Decision Making: An If node checks whether any low-production entries are present. Alerts: If low-production is detected, an email is sent via the Gmail node. Logging: If all entries are valid, they are logged into a Google Sheet. Slack Summary: A Slack node posts the summary sheet data for end-of-day visibility. How to Set Up Schedule Trigger: Configure to run every 2 hours. HTTP Request Node: Method: GET URL: https://api.energidataservice.dk/dataset/YourDatasetHere Add necessary headers and params as required by the API. Code Node: Define logic to filter entries where solarenergyproduction < required_threshold. If Node: Use items.length > 0 to check for low-production entries. Gmail Node: Auth with Gmail credentials. Customize recipient and message template. Google Sheets Node: Connect to a spreadsheet. Map appropriate columns. Slack Node: Use Slack OAuth2 credentials. Specify channel and message content. Requirements n8n Cloud or Self-hosted instance. Access to Energidataservice API. Gmail account (with n8n OAuth2 integration). Google Sheets account & sheet ID. Slack workspace and app with appropriate permissions. How to Customize Change Frequency: Adjust the Schedule Trigger interval (e.g., every hour or 4x per day). Threshold Tuning: Modify the value in the Code node to change the minimum acceptable solar production. Alert Routing: Update Gmail recipients or replace Gmail with Microsoft Outlook/SendGrid. Sheet Format: Add or remove columns in the Google Sheet based on extra metrics (e.g., wind or nuclear data). Slack Posting: Customize Slack messages using Markdown for improved readability. Add‑ons Telegram Node: Send alerts to a Telegram group instead of email. Discord Webhook: Push updates to a Discord channel. n8n Webhook Trigger: Extend it to receive external production update notifications. Integromat/Make or Zapier: For multi-platform integration with CRMs or ticketing tools. Use Case Examples Utility Companies: Automatically detect and act on solar underperformance to maintain grid stability. Solar Farm Operators: Log clean production data for auditing and compliance reports. Sustainability Teams: Track daily performance and anomalies without manual checks. Home Solar System Owners: Get notified if solar generation drops below expected. Common Troubleshooting | Issue | Possible Cause | Solution | | -------------------------------------- | -------------------------------------- | ------------------------------------------------------------------- | | HTTP Request fails | API key missing or URL is incorrect | Check API endpoint, parameters, and authentication headers | | Gmail not sending alerts | Missing or invalid Gmail credentials | Re-authenticate Gmail OAuth2 in n8n credentials | | No data getting logged in Google Sheet | Incorrect mapping or sheet permissions | Ensure the sheet exists, columns match, and credentials are correct | | Slack node fails | Invalid token or missing channel ID | Reconnect Slack credentials and check permissions | | Code node returns empty | Filter logic may be too strict | Validate data format and relax the threshold condition | Need Help? Need help setting this up or customizing it for your own solar or energy monitoring use case? ✅ Set it up on your n8n Cloud or self-hosted instance ✅ Customize it for your own API or data source ✅ Modify alerts to suit your internal tools (Teams, Discord, SMS, etc.) 👉 Just reach out to our n8n automation team at WeblineIndia, we'll be happy to help.
By WeblineIndiaGenerate multi-platform content with OpenAI, Tavily Research & Supabase Storage
Automated Content Page Generator with AI, Tavily Research, and Supabase Storage > ⚠️ Self-Hosted Disclaimer: This template requires self-hosted n8n installation and external service credentials (OpenAI, Tavily, Google Drive, NextCloud, Supabase). It cannot run on n8n Cloud due to dependency requirements. Overview Transform simple topic inputs into professional, multi-platform content automatically. This workflow combines AI-powered content generation with intelligent research and seamless storage integration to create website content, blog articles, and landing pages optimized for different audiences. Key Features Automated Research: Uses Tavily's advanced search to gather relevant, up-to-date information Multi-Platform Content: Generates optimized content for websites, blogs, and landing pages Image Management: Downloads from Google Drive and uploads to NextCloud with public URL generation Database Integration: Stores all content in Supabase for easy retrieval Error Handling: Built-in error management workflow for reliability Content Optimization: AI-driven content strategy with trend analysis and SEO optimization Required Services & APIs Core Services n8n: Self-hosted instance (required) OpenAI: GPT-4 API access for content generation Tavily: Research API for content discovery Google Drive: Image storage and retrieval Google Sheets: Content input and workflow triggering NextCloud: Image hosting and public URL generation Supabase: Database storage for generated content Setup Instructions Prerequisites Before setting up this workflow, ensure you have: Self-hosted n8n installation API credentials for all required services Database table created in Supabase Step 1: Service Account Configuration OpenAI Setup Create an OpenAI account at platform.openai.com Generate API key from the API Keys section In n8n, create new OpenAI credentials using your API key Test connection to ensure GPT-4 access Tavily Research Setup Sign up at tavily.com Get your API key from the dashboard Add Tavily credentials in n8n Configure search depth to "advanced" for best results Google Services Setup Create Google Cloud Project Enable Google Drive API and Google Sheets API Create OAuth2 credentials Configure Google Drive and Google Sheets credentials in n8n Share your input spreadsheet with the service account NextCloud Setup Install NextCloud or use hosted solution Create application password for API access Configure NextCloud credentials in n8n Create /images/ folder for content storage Supabase Setup Create Supabase project at supabase.com Create table with the following structure: sql CREATE TABLE works ( id SERIAL PRIMARY KEY, title TEXT NOT NULL, content TEXT NOT NULL, image_url TEXT, category TEXT, created_at TIMESTAMP DEFAULT NOW() ); Get project URL and service key from settings Configure Supabase credentials in n8n Step 2: Google Sheets Input Setup Create a Google Sheets document with the following columns: TITLE: Topic or title for content generation IMAGE_URL: Google Drive sharing URL for associated image Example format: TITLE | IMAGE_URL AI Chatbot Implementation | https://drive.google.com/file/d/your-file-id/view Digital Marketing Trends 2024 | https://drive.google.com/file/d/another-file-id/view Step 3: Workflow Import and Configuration Import the workflow JSON into your n8n instance Configure all credential connections: Link OpenAI credentials to "OpenAIGPT4Model" node Link Tavily credentials to "TavilyResearchAgent" node Link Google credentials to "GoogleSheetsTrigger" and "GoogleDriveImage_Downloader" nodes Link NextCloud credentials to "NextCloudImageUploader" and "NextCloudPublicURL_Generator" nodes Link Supabase credentials to "SupabaseContentStorage" node Update the Google Sheets Trigger node: Set your spreadsheet ID in the documentId field Configure polling frequency (default: every minute) Test each node connection individually before activating Step 4: Error Handler Setup (Optional) The workflow references an error handler workflow (GWQ4UI1i3Z0jp3GF). Either: Create a simple error notification workflow with this ID Remove the error handling references if not needed Update the workflow ID to match your error handler Step 5: Workflow Activation Save all node configurations Test the workflow with a sample row in your Google Sheet Verify content generation and storage in Supabase Activate the workflow for continuous monitoring How It Works Workflow Process Trigger: Google Sheets monitors for new rows with content topics Research: Tavily searches for 3 relevant articles about the topic Content Generation: AI agent creates multi-platform content (website, blog, landing page) Content Cleaning: Text processing removes formatting artifacts Image Processing: Downloads image from Google Drive, uploads to NextCloud URL Generation: Creates public sharing links for images Storage: Saves final content package to Supabase database Content Output Structure Each execution generates: Optimized Title: SEO-friendly, platform-appropriate headline Multi-Platform Content: Website content (professional, authority-building) Blog content (educational, SEO-optimized) Landing page content (conversion-focused) Category Classification: Automated content categorization Image Assets: Processed and publicly accessible images Customization Options Content Strategy Modification Edit the AI agent's system message to change content style Adjust character limits for different platform requirements Modify category classifications for your industry Research Parameters Change Tavily search depth (basic, advanced) Adjust number of research sources (1-10) Modify search topic focus Storage Configuration Update Supabase table structure for additional fields Change NextCloud folder organization Modify image naming conventions Troubleshooting Common Issues Workflow not triggering: Check Google Sheets permissions Verify polling frequency settings Ensure spreadsheet format matches requirements Content generation errors: Verify OpenAI API key and credits Check GPT-4 model access Review system message formatting Image processing failures: Confirm Google Drive sharing permissions Check NextCloud storage space and permissions Verify file formats are supported Database storage issues: Validate Supabase table structure Check API key permissions Review field mapping in storage node Performance Optimization Adjust polling frequency based on your content volume Monitor API usage to stay within limits Consider batch processing for high-volume scenarios Support and Updates This template is designed for self-hosted n8n environments and requires technical setup. For issues: Check n8n community forums Review service-specific documentation Test individual nodes in isolation Monitor execution logs for detailed error information
By Jameson KanakulyaExtract website intelligence & classify ecommerce URLs with Gemini & Firecrawl to Google Sheets
Description This n8n template automates website analysis and ecommerce URL classification using AI. It scrapes a website, extracts business intelligence, maps all internal pages, and categorises them into products, categories, or non-commerce pages. All outputs are saved in Google Sheets for easy access. --- Use cases Lead enrichment for sales and marketing teams Ecommerce product & category discovery Competitor website analysis Website audits and content mapping Market and industry research --- How it works A user submits a website URL via an n8n form. The homepage is scraped and cleaned. AI extracts company insights (value proposition, industry, audience, B2B/B2C). Firecrawl maps all internal URLs. URLs are enriched with metadata. AI classifies each URL as product, category, or other. Results are written into structured Google Sheets tabs. --- How to use Import the workflow into n8n. Connect Google Sheets, Firecrawl, and AI credentials. Update the Google Sheets document links. Open the form URL and submit a website. Let the workflow run and review the results in Sheets. --- Requirements n8n (self-hosted or cloud) Firecrawl API key Google Gemini or compatible LLM credentials Google Sheets account --- Customising this workflow Change AI prompts to match your niche (SaaS, ecommerce, services). Add filters to exclude unwanted URLs (blogs, legal pages, etc.). Extend Sheets with scoring, tagging, or lead qualification logic. Replace the LLM with another supported model if needed. --- What this template demonstrates End-to-end website intelligence extraction Safe, rule-based AI classification (no hallucinations) Scalable URL processing with batching Clean data pipelines into Google Sheets Practical AI usage for real business workflows This template is designed to work out-of-the-box for website intelligence, ecommerce mapping, and lead research. Feel free to reach out for custom implementation or enhancements: 📧 Email: @dinakars2003@gmail.com
By Dinakar Selvakumar