Workflow Templates

Get daily SMS updates to tell you if you should wear a sweater

Creative Asset Manager with ScrapeGraphAI Analysis and Brand Compliance 🎯 Target Audience Creative directors and design managers Marketing teams managing brand assets Digital asset management (DAM) administrators Brand managers ensuring compliance Content creators and designers Marketing operations teams Creative agencies managing client assets Brand compliance officers 🚀 Problem Statement Managing creative assets manually is inefficient and error-prone, often leading to inconsistent branding, poor organization, and compliance issues. This template solves the challenge of automatically analyzing, organizing, and ensuring brand compliance for creative assets using AI-powered analysis and automated workflows. 🔧 How it Works This workflow automatically processes uploaded creative assets using ScrapeGraphAI for intelligent analysis, generates comprehensive tags, checks brand compliance, organizes files systematically, and maintains a centralized dashboard for creative teams. Key Components Asset Upload Trigger - Webhook endpoint that activates when new creative assets are uploaded ScrapeGraphAI Asset Analyzer - Uses AI to extract detailed information from visual assets Tag Generator - Creates comprehensive, searchable tags based on asset analysis Brand Compliance Checker - Evaluates assets against brand guidelines and standards Asset Organizer - Creates organized folder structures and standardized naming Creative Team Dashboard - Updates Google Sheets with organized asset information 📊 Google Sheets Column Specifications The template creates the following columns in your Google Sheets: | Column | Data Type | Description | Example | |--------|-----------|-------------|---------| | asset_id | String | Unique asset identifier | "asset_1703123456789_abc123def" | | name | String | Standardized filename | "image-social-media-2024-01-15T10-30-00.jpg" | | path | String | Storage location path | "/creative-assets/2024/01/image/social-media" | | asset_type | String | Type of creative asset | "image" | | dimensions | String | Asset dimensions | "1920x1080" | | file_format | String | File format | "jpg" | | primary_colors | Array | Extracted color palette | ["#FF6B35", "#004E89"] | | content_description | String | AI-generated content description | "Modern office workspace with laptop" | | text_content | String | Any text visible in asset | "Welcome to our workspace" | | style_elements | Array | Detected style characteristics | ["modern", "minimalist"] | | generated_tags | Array | Comprehensive tag list | ["high-resolution", "brand-logo", "social-media"] | | usage_context | String | Suggested usage context | "social-media" | | brand_elements | Array | Detected brand elements | ["logo", "typography"] | | compliance_score | Number | Brand compliance score (0-100) | 85 | | compliance_status | String | Approval status | "approved-with-warnings" | | compliance_issues | Array | List of compliance problems | ["Non-brand colors detected"] | | upload_date | DateTime | Asset upload timestamp | "2024-01-15T10:30:00Z" | | searchable_keywords | String | Search-optimized keywords | "image social-media modern brand-logo" | 🛠️ Setup Instructions Estimated setup time: 25-30 minutes Prerequisites n8n instance with community nodes enabled ScrapeGraphAI API account and credentials Google Sheets account with API access File upload system or DAM integration Brand guidelines document (for compliance configuration) Step-by-Step Configuration 1. Install Community Nodes Install required community nodes npm install n8n-nodes-scrapegraphai 2. Configure ScrapeGraphAI Credentials Navigate to Credentials in your n8n instance Add new ScrapeGraphAI API credentials Enter your API key from ScrapeGraphAI dashboard Test the connection to ensure it's working 3. Set up Google Sheets Connection Add Google Sheets OAuth2 credentials Grant necessary permissions for spreadsheet access Create a new spreadsheet for creative asset management Configure the sheet name (default: "Creative Assets Dashboard") 4. Configure Webhook Trigger Set up the webhook endpoint for asset uploads Configure the webhook URL in your file upload system Ensure asset_url parameter is passed in webhook payload Test webhook connectivity 5. Customize Brand Guidelines Update the Brand Compliance Checker node with your brand colors Configure approved file formats and size limits Set required brand elements and fonts Define resolution standards and quality requirements 6. Configure Asset Organization Customize folder structure preferences Set up naming conventions for different asset types Configure metadata extraction preferences Set up search optimization parameters 7. Test and Validate Upload a test asset to trigger the workflow Verify all analysis steps complete successfully Check Google Sheets for proper data formatting Validate brand compliance scoring 🔄 Workflow Customization Options Modify Analysis Parameters Adjust ScrapeGraphAI prompts for specific asset types Customize tag generation algorithms Modify color analysis sensitivity Add industry-specific analysis criteria Extend Brand Compliance Add more sophisticated brand guideline checks Implement automated correction suggestions Include legal compliance verification Add accessibility compliance checks Customize Organization Structure Modify folder hierarchy based on team preferences Implement custom naming conventions Add version control and asset history Configure backup and archiving rules Output Customization Add integration with DAM systems Implement asset approval workflows Create automated reporting and analytics Add team collaboration features 📈 Use Cases Brand Asset Management**: Automatically organize and tag brand assets Compliance Monitoring**: Ensure all assets meet brand guidelines Creative Team Collaboration**: Centralized asset management and sharing Marketing Campaign Management**: Organize assets by campaign and context Asset Discovery**: AI-powered search and recommendation system Quality Control**: Automated quality and compliance checks 🚨 Important Notes Respect ScrapeGraphAI API rate limits and terms of service Implement appropriate delays between requests to avoid rate limiting Regularly review and update brand guidelines in the compliance checker Monitor API usage to manage costs effectively Keep your credentials secure and rotate them regularly Consider data privacy and copyright compliance for creative assets Ensure proper backup and version control for important assets 🔧 Troubleshooting Common Issues: ScrapeGraphAI connection errors: Verify API key and account status Webhook trigger failures: Check webhook URL and payload format Google Sheets permission errors: Check OAuth2 scope and permissions Asset analysis errors: Review the ScrapeGraphAI prompt configuration Brand compliance false positives: Adjust guideline parameters File organization issues: Check folder permissions and naming conventions Support Resources: ScrapeGraphAI documentation and API reference n8n community forums for workflow assistance Google Sheets API documentation for advanced configurations Digital asset management best practices Brand compliance and governance guidelines

To notify by Slack and mail all modification on a Google Sheet

This workflow allows you to create, update, and get an object from Bubble. Bubble node: This node will create a new object of the type Doc in Bubble. If you want to create an object with a different type, use that type instead. Bubble1 node: This node will update the object that we created using the previous node. Bubble2 node: This node will retrieve the information of the object that we created earlier.

This workflow exports a local CSV file to a JSON file.

This workflow allows you to create, update, and get a webinar in GoToWebinar. GoToWebinar node: This node will create a new webinar in GoToWebinar. GoToWebinar1 node: This node will update the description of the webinar that we created in the previous node. GoToWebinar2 node: This node will get the information about the webinar that we created earlier.

Overview HR departments and recruiters spend countless hours manually reviewing resumes, often missing qualified candidates due to time constraints. This workflow automates the entire resume screening process by extracting structured data from resumes in any format (PDF, Word documents, or even photographed/scanned resume images), calculating experience scores, and creating comprehensive candidate profiles ready for your ATS system. What You Can Do This workflow automatically retrieves resumes from Google Drive and uses AI to extract all relevant candidate information including personal details, work experience with dates, education, skills, and certifications. It intelligently handles various resume formats including PDFs, Word documents, and even scanned or photographed resumes using OCR. The workflow calculates total years of experience, tracks skill-specific experience, generates proficiency scores for each skill, and provides an AI-powered assessment of candidate strengths and suitability for different roles. Who It's For Perfect for HR departments processing high volumes of applications, recruitment agencies managing multiple clients, talent acquisition teams seeking to improve candidate quality, and hiring managers who want data-driven insights for decision making. Ideal for organizations that need to maintain consistent evaluation standards across different reviewers and want to reduce time-to-hire while improving candidate match quality. The Problem It Solves Manual resume screening is inefficient and inconsistent. Different reviewers may evaluate the same resume differently, leading to missed opportunities and bias. This workflow standardizes the extraction process, automatically calculates years of experience for each skill, and provides objective scoring metrics to help identify the best candidates faster while reducing human bias in the initial screening process. Setup Instructions Configure Google Drive credentials in n8n Install the PDF Vector community node from the n8n marketplace Configure your PDF Vector API credentials Set up your preferred data storage (database or spreadsheet) Customize the skill categories for your industry Configure the scoring algorithm based on your requirements Connect to your existing ATS system if needed Key Features Automatic Resume Retrieval**: Pull resumes from Google Drive folders automatically Universal Format Support**: Process PDFs, Word documents, and photographed resumes OCR Capabilities**: Extract text from scanned or photographed documents Experience Calculation**: Automatically compute total and skill-specific experience Proficiency Scoring**: Generate objective skill proficiency ratings AI Assessment**: Get intelligent insights on candidate fit and strengths Multi-Language Support**: Handle resumes in various languages ATS Integration**: Output structured data compatible with major ATS systems Customization Options Define custom skill categories relevant to your industry, adjust scoring weights for different experience types, add specific extraction fields for your organization, implement keyword matching for job requirements, set up automated candidate ranking systems, create role-specific evaluation criteria, and integrate with LinkedIn or other professional networks for enhanced candidate insights. Note: This workflow uses the PDF Vector community node. Make sure to install it from the n8n community nodes collection before using this template.

This workflows allows you to create a customer and an invoice and send the invoice to the customer. QuickBooks node: This node will create a new customer in QuickBooks. QuickBooks1 node: This node will create an invoice for the customer that we created in the previous node. QuickBooks2 node: This node will send the invoice that we created in the previous node.

This workflow allows you to create a campaign, add a contact, and get the campaign from Emelia. Emelia node: This node will create a new campaign in Emelia. Emelia1 node: This node will add a contact to the campaign that we created in the previous node. Based on your use-case, you can add a Google Sheets node or an Airtable node to get the email address of the contact. Emelia2 node: This node will get the information about the campaign that we created earlier.

This workflow allows you to create a collection and create, update, and get a bookmark in Raindrop. Raindrop node: This node will create a new collection in Raindrop. If you already have a collection, you can skip this node. Raindrop1 node: This node will create a new bookmark and add it to a collection. Raindrop2 node: This node will update the bookmark that we created in the previous node. Raindrop3 node: This node will return the information about the bookmark that we created earlier.

This form takes data from a Typeform submission and creates an invoice on Google Sheets

Automated Email Verification for Google Sheets This n8n template demonstrates how to automatically validate email addresses from your Google Sheets using a reliable email verification API. Perfect for cleaning contact lists, validating leads, and ensuring email deliverability before marketing campaigns. Use cases are many: Lead qualification for sales teams, contact list cleaning for marketing, subscriber validation for newsletters, or CRM data hygiene maintenance! Good to know The rapid-email-verifier API is free for up to 1,000 verifications per month Each email verification typically takes less than 500ms to complete The workflow runs automatically every hour, checking for new entries Only processes emails that haven't been verified yet, preventing duplicate API calls How it works Monitor Google Sheets: The trigger watches your spreadsheet for new email entries every hour Smart Filtering: Only emails with empty "Email Verified" columns are processed to avoid duplicates Batch Processing: Emails are processed one by one to respect API rate limits and ensure reliability API Verification: Each email is sent to the rapid-email-verifier service which returns validation status Results Update: The original sheet is updated with verification results (valid/invalid/unknown) using the Serial Number as a match key The verification accuracy is consistently above 95% and shows excellent detection of invalid, disposable, and risky email addresses! How to use The Google Sheets trigger monitors your spreadsheet automatically, but you can also test manually Simply add new rows with email addresses to your connected Google Sheet Leave the "Email Verified" column empty for new entries The workflow will automatically process and update the verification status Technically, you can process unlimited emails, but consider API rate limits and costs for large batches. Requirements Google Sheets account** with a spreadsheet containing columns: SrNo, Name, Email, Email Verified Google Sheets credentials** configured in n8n for both trigger and update operations Internet connection** for API access (no additional API key required for rapid-email-verifier) Customising this workflow Email verification can be enhanced for many use-cases: Add webhook trigger** for real-time verification when leads are captured Connect to CRM systems** like HubSpot or Salesforce for direct integration Add email categorization** to separate personal vs business emails Include bounce detection** by connecting to your email service provider Set up notifications** to alert when invalid emails are detected in important lists This template is perfect for marketing managers, sales professionals, data analysts, and anyone managing contact databases who needs reliable email validation!