Working with Excel spreadsheet files (xls & xlsx)
This workflow will help guide you through obtaining a spreadsheet file, reading it, making a change then saving it to local or cloud storage.
By n8n TeamAnalyze email headers for IP reputation and spoofing detection - Outlook
Analyze Emails for Security Insights Who is this for? This workflow is ideal for security teams, IT Ops professionals, and managed service providers (MSPs) responsible for monitoring and validating email traffic. It’s especially useful for organizations that need to identify potential phishing attempts, spam, or compromised accounts by analyzing email headers and IP reputation. --- What problem is this workflow solving? This workflow helps identify malicious or suspicious emails by verifying email authentication headers (SPF, DKIM, DMARC) and analyzing the reputation of the originating IP address. By automating these checks, it reduces manual analysis time and flags potential threats efficiently. --- What this workflow does Email Monitoring: Polls a specified Microsoft Outlook folder for new emails in real-time. Header Analysis: Retrieves and processes email headers to extract critical information such as authentication results and the sender’s IP address. IP Reputation Check: Leverages external APIs (IP Quality Score and IP-API) to analyze the originating IP for potential spam or malicious activity. Authentication Validation: Validates SPF, DKIM, and DMARC headers, determining if the email passes industry-standard authentication protocols. Data Aggregation and Reporting: Combines all analyzed data into a unified format, ready for reporting or integration into downstream systems. Webhook Integration: Outputs the findings via a webhook, enabling integration with alerting tools or security information and event management (SIEM) platforms. --- Setup Connect to Outlook: Configure the Microsoft Outlook trigger node with valid OAuth2 credentials. Specify the email folder to monitor for new messages. API Keys (Optional): Obtain an API key for IP Quality Score (https://ipqualityscore.com). Ensure the IP-API endpoint is accessible. This step is optional as ipqualityscore.com will provide a limited number of free lookups each month. See more details here. Webhook Configuration: Set up a webhook endpoint to receive the output of the workflow. Optional Adjustments: Customize polling intervals in the trigger node. Modify header filters or extend the validation logic as needed. --- How to customize this workflow to your needs Add Alerts: Use the Respond to Webhook node to trigger notifications in Slack, email, or any other communication channel. Integrate with SIEM: Forward the workflow output to SIEM tools like Splunk or ELK Stack for further analysis. Modify Validation Rules: Update SPF, DKIM, or DMARC logic in the Set nodes to align with your organization’s security policies. Expand IP Analysis: Add more APIs or services to enrich IP reputation data, such as VirusTotal or AbuseIPDB. --- This workflow provides a robust foundation for email security monitoring and can be tailored to fit your organization's unique requirements. With its modular design and integration options, it’s a versatile tool to enhance your cybersecurity operations.
By Angel MenendezReceive updates for events in Chargebee
No description available.
By tanaypantComplete Google Tasks management: Create, update & delete tasks automatically
Comprehensive workflow template for managing Google Tasks through n8n automation. Provides full CRUD operations (Create, Read, Update, Delete) for seamless task management integration. 🚀 Features Create Tasks - Add new tasks programmatically Retrieve Tasks - Get individual or multiple tasks with filtering Update Tasks - Modify existing task details and status Delete Tasks - Remove completed or obsolete tasks Batch Operations - Handle multiple tasks efficiently 💼 Perfect For Project Management - Automate task creation from project milestones Email Integration - Convert emails to actionable tasks CRM Workflows - Create follow-up tasks from customer interactions Content Planning - Generate tasks from editorial calendars Team Collaboration - Sync tasks across different platforms 🔧 What's Included Pre-configured Google Tasks API nodes Error handling and validation Flexible task filtering and sorting Status management (pending/completed) Batch processing capabilities ⚡ Quick Start Connect your Google Tasks account Configure task list preferences Test individual operations Deploy and automate! Transform your productivity workflow with automated task management.
By Jitesh DugarAutomate payment receipts: Email, archive, and track with Stripe and Google Workspace
Description This workflow automates the process of retrieving Stripe invoices, validating API responses, generating payment receipts, sending them via email, storing PDFs in Google Drive, and appending details to a Google Sheet ledger. It also includes an error logging system to capture and record workflow issues, ensuring financial operations are both automated and reliable. What This Template Does (Step-by-Step) 📋 Manual Trigger – Start the workflow manually by clicking Execute workflow. 🔗 Fetch Invoices – Authenticates with Stripe and retrieves the 5 most recent invoices (includes customer info, amounts, statuses, and invoice URLs). ✅ Check API Response – Ensures the Stripe API response contains a valid data[] array. If not, errors are logged. 📂 Expand List – Splits Stripe’s bundled invoice list into individual invoice records for independent processing. 💳 IF (Paid?) – Routes invoices based on payment status; only paid invoices move forward. 📧 IF (Already Receipted?) – Skips invoices where a receipt has already been generated (receipt_sent = true). 📑 Download File – Downloads the hosted invoice PDF from Stripe for use in emails and archiving. ✉️ Send Receipt Email – Emails the customer a payment receipt with the PDF attached, using invoice details (number, amount, customer name). ☁️ Upload Invoice PDF – Uploads the invoice PDF to a specific Google Drive folder, named by invoice number. 📊 Append to Ledger – Updates a Google Sheet with invoice metadata (date, invoice number, Drive file ID, link, size). ⚠️ Error Logging – Logs workflow issues (failed API calls, missing data, etc.) into a dedicated error tracking sheet. Prerequisites Stripe API key (with invoice read permissions) Google Drive (destination folder for invoices) Google Sheets with: Receipts Ledger Sheet Error Logging Sheet Gmail OAuth2 account for sending receipts Key Benefits ✅ Automates customer receipt delivery with attached PDFs ✅ Builds a permanent ledger in Google Sheets for finance ✅ Archives invoices in Google Drive for easy retrieval ✅ Prevents duplicates by checking receipt_sent metadata ✅ Includes error logging for smooth monitoring and debugging Perfect For Finance/accounting teams needing automated receipt handling SaaS businesses managing recurring Stripe invoices Operations teams requiring error-proof automation Any business needing audit-ready receipts + logs
By Rahul Joshi