Read in an Excel spreadsheet file
How to take the path of a local Excel file and read its contents into n8n.
By Tien DeReal estate lead generation with BatchData skip tracing & CRM integration
How It Works This workflow automates the entire property lead generation process in a few simple steps: Property Search: Connects to BatchData's Property Search API with customizable parameters (location, property type, value range, equity percentage, etc.) Lead Filtering & Scoring: Processes results to identify the most promising leads based on criteria like absentee ownership, years owned, equity percentage, and tax status. Each property receives a lead score to prioritize follow-up. Skip Tracing: Automatically retrieves owner contact information (phone, email, mailing address) for each qualified property. Data Formatting: Structures all property and owner data into a clean, organized format ready for your systems. Multi-Channel Output: Generates an Excel spreadsheet with all lead details Pushes leads directly to your CRM (configurable for HubSpot, Salesforce, etc.) Sends a summary email with the spreadsheet attached The workflow can run on a daily schedule or be triggered manually as needed. All parameters are easily configurable through dedicated nodes, requiring no coding knowledge. Who's It For This workflow is perfect for: Real Estate Investors looking to find off-market properties with motivated sellers Real Estate Agents who want to generate listing leads from distressed or high-equity properties Investment Companies that need regular lead flow for acquisitions Real Estate Marketers who run targeted campaigns to property owners Wholesalers seeking to build a pipeline of potential deals Property Service Providers (roof repair, renovation contractors, etc.) who target specific property types Anyone who needs reliable, consistent lead generation for real estate without the manual work of searching, filtering, and organizing property data will benefit from this automation. About BatchData BatchData is a comprehensive property data provider that offers access to nationwide property information, owner details, and skip tracing services. Key features include: Extensive Database: Covers 150+ million properties across all 50 states Rich Property Data: Includes ownership information, tax records, sales history, valuation estimates, equity positions, and more Skip Tracing Services: Provides owner contact information including phone numbers, email addresses, and mailing addresses Distressed Property Indicators: Flags for pre-foreclosure, tax delinquency, vacancy, and other motivation factors RESTful API: Professional API for programmatic access to all property data services Regular Updates: Continuously refreshed data for accurate information BatchData's services are designed for real estate professionals who need reliable property and owner information to power their marketing and acquisition strategies. Their API-first approach makes it ideal for workflow automation tools like N8N.
By Preston ZellerUpdate time-tracking projects based on Syncro status changes
This workflow is part of an MSP collection, which is publicly available on GitHub. This workflow archives or unarchives a Clockify projects, depending on a Syncro status. Note that Syncro should be setup with a webhook via 'Notification Set for Ticket - Status was changed'. It doesn't handle merging of tickets, as Syncro doesn't support a 'Notification Set' for merged tickets, so you should change a ticket to 'Resolved' first before merging it. Prerequisites A Clockify account and credentials Nodes Webhook node triggers the workflow. IF node filters projects that don't have the status 'Resolved'. Clockify nodes get all projects that (don't) have the status 'Resolved', based on the IF route. HTTP Request nodes unarchives unresolved projects, and archives resolved projects, respectively.
By JonathanLINE BOT - Google Sheets file lookup with AI agent
This workflow integrates LINE BOT, AI Agent (GPT), Google Sheets, and Google Drive to enable users to search for file URLs using natural language. The AI Agent extracts the filename from the message, searches for the file in Google Sheets, and returns the corresponding Google Drive URL via LINE BOT. Supports natural language queries (e.g., "Find file 1.pdf for me") AI-powered filename extraction Google Sheets Lookup for file URLs Auto-response via LINE BOT How to Use This Template Download & Import Copy and save the Template Code as a .json file. Go to n8n Editor β Click Import β Upload the file. Update Required Fields Replace YOURGOOGLESHEET_ID with your actual Google Sheet ID. Replace YOURLINEACCESS_TOKEN with your LINE BOT Channel Access Token. Activate & Test Click Execute Workflow to test manually. Set Webhook URL in LINE Developer Console. Features of This Template Supports Natural Language Queries (e.g., βFind file 1.pdf for meβ) AI-powered filename extraction using OpenAI (GPT-4/3.5) Real-time file lookup in Google Sheets Automatic LINE BOT Response Fully Automated Workflow
By Jaruphat J.AI DJ: Text-to-Spotify playlist generator with Linkup and GPT4
Stop manually searching for songs and let an AI DJ do the work for you. This template provides a complete, end-to-end system that transforms any text prompt into a ready-to-play Spotify playlist. It combines the creative understanding of a powerful AI Agent with the real-time web knowledge of Linkup to curate perfect, up-to-the-minute playlists for any occasion. The experience is seamless: simply describe the vibe you're looking for in a web form, and the workflow will automatically create the playlist in your Spotify account and redirect you straight to it. Whether you need "upbeat funk for a sunny afternoon" or "moody electronic tracks for late-night coding," your personal AI DJ is ready to deliver. Who is this for? Music lovers: Create hyper-specific playlists for any mood, activity, or niche genre without the hassle of manual searching. DJs & event planners: Quickly generate themed playlists for parties, weddings, or corporate events based on a simple brief. Content creators: Easily create companion playlists for your podcasts, videos, or articles to share with your audience. n8n developers: A powerful example of how to build an AI agent that uses an external web-search tool to accomplish a creative task. What problem does this solve? Creates up-to-date playlists: A standard AI doesn't know about music released yesterday. By using Linkup's live web search, this workflow can find and include the very latest tracks. Automates the entire creation process: It handles everything from understanding a vague prompt (like "songs that feel like a summer road trip") to creating a fully populated Spotify playlist. Saves time and effort: It completely eliminates the tedious task of searching for individual tracks, checking for relevance, and manually adding them to a playlist one by one. Provides a seamless user experience: The workflow begins with a simple form and ends by automatically opening the finished playlist in your browser. There are no intermediate steps for you to manage. How it works Submit your playlist idea: You describe the playlist you want and the desired number of tracks in a simple, Spotify-themed web form. The AI DJ plans the search: An AI Agent (acting as your personal DJ) analyzes your request. It then intelligently formulates a specific query to find the best music. Web research with Linkup: The agent uses its Linkup web-search tool to find artists and tracks from across the web that perfectly match your request, returning a list of high-quality suggestions. The AI DJ curates the list: The agent reviews the search results and finalizes the tracklist and a creative name for your playlist. Build the playlist in Spotify: The workflow takes the agent's final list, creates a new public playlist in your Spotify account, then searches for each individual track to get its ID and adds them all. Instant redirection: As soon as the last track is added, the workflow automatically redirects your browser to the newly created playlist on Spotify, ready to be played. Setup Connect your accounts: You will need to add your credentials for: Spotify: In the Spotify nodes. Linkup: In the Web query to find tracks (HTTP Request Tool) node. Linkup's free plan is very generous! Your AI provider (e.g., OpenAI): In the OpenAI Chat Model node. Activate the workflow: Toggle the workflow to "Active." Use the form: Open the URL from the On form submission trigger and start creating playlists! Taking it further Change the trigger: Instead of a form, trigger the playlist creation from a Telegram message, a Discord bot command, or even a webhook from another application. Create collaborative playlists: Set up a workflow where multiple people can submit song ideas. You could then have a final AI step consolidate all the requests into a single, cohesive prompt to generate the ultimate group playlist. Optimize for speed: The Web query to find tracks node is set to deep search mode for the highest quality results. You can change this to standard mode for faster and cheaper (but potentially less thorough) playlist creation.
By Guillaume DuvernayAutomate meeting notes summaries with Gemini AI & Slack notifications
π Meeting Notes Summarizer & Slack Notifier Easily keep your team aligned by summarizing meeting notes, extracting action items, and delivering them directly to Slack. π What This Workflow Does β° Triggers on a schedule to fetch meeting data from your note-taking tool π Retrieves meeting summaries and action items using the MeetGeek API π€ Uses Google Gemini AI to generate concise summaries and action points π¨ Restructures the output into Slack Block Kit format π’ Sends daily Slack notifications with clear summaries and actionable tasks π₯ Who Is This For? π©βπΌ Teams that want automated daily meeting briefs π Project managers who need action items clearly assigned π Remote or hybrid teams using Slack as their main communication hub β³ Anyone looking to reduce the time spent reviewing long meeting notes π οΈ Technical Requirements π API key & credentials for your meeting note-taking app π€ Google Gemini AI credentials π¬ Slack workspace with proper OAuth setup β‘ Set Up the Workflow with Ease ποΈ Configure your meeting note API in the βGet Meetings Listβ and βSummaryβ nodes. π€ Add Gemini AI credentials for generating summaries. π Connect your Slack channel for notifications. β Activate the workflow so that your team will start receiving daily meeting insights automatically. π¨ Want to Customize It Further? π Change the trigger schedule (daily, weekly, or after each meeting). π Modify the Slack Block Kit layout for different formatting styles. π§ Add extra integrations like email, Notion, or Google Docs to save notes. βοΈ Adjust the AI prompt for different summary styles (short/long, formal/casual, etc.). π Filter meetings by specific teams, projects, or keywords. π Customize the API URL in the HTTP Request node to connect with other note-taking tools or different API endpoints.
By SayOne TechnologiesAutomate job posting creation with Forms, Dropbox, and Foxit PDF generation
This n8n template demonstrates how to add a tie form data to a new PDF. The idea is to automate the creation of a professional looking job posting. Use cases would be organizations who need to automate the creation of job postings. How it Works The trigger is a form that asks for job position, salary, office location, and responsiblities When the form is posted, it kicks off the workflow's next steps A Word document is downloaded from a Dropbox folder. This Word document is used as the template for the posting. The Word document is converted to base64. A call to Foxit's Document Generation endpoint includes the encoded Word document along with the form information. The resulting PDF is downloaded and converted from base64 into binary. At this point, the PDF is just there, but it could be emailed, sent to another workflow, etc. Requirements A Dropbox account. The workflow's first step points to a Word template. See our doc gen APIs for information on how to craft the Word doc, but the easiest way is to copy text like so: Job Position We are pleased to announce the opening of a new job, {{ jobPosition }}. This job pays ${{ salary }} per year and is in our {{ office }} location. The details of this job are: {{ responsibilities }} Foxit developer account (https://developer-api.foxit.com) Next Steps As mentioned above, you could do anything with the resulting PDF when done.
By Raymond CamdenMagento 2 low stock alert via Slack & Gmail (MSI compatible)
Daily Magento 2 stock check Automation It identifies SKUs with low inventory per source and sends daily alerts via: π¬ Gmail (HTML email) π¬ Slack (formatted text message) This automation empowers store owners and operations teams to stay ahead of inventory issues by proactively monitoring stock levels across all Magento 2 sources. By receiving early alerts for low-stock products, businesses can restock before items sell outβensuring continuous product availability, reducing missed sales opportunities, and maintaining customer trust. Avoiding stockouts not only protects your brand reputation but also keeps your store competitive by preventing customers from turning to competitors due to unavailable items. Timely restocking leads to higher fulfillment rates, improved customer satisfaction, and ultimately, stronger revenue and long-term loyalty. β Features: Filters out configurable, virtual, and downloadable products Uses Magento 2 MSI stock per source Customizable thresholds (default: β€10 overall or β€5 per source) HTML-formatted email report Slack notification with a code-formatted Runs daily via Cron (08:50 AM) No need of any 3rd part Modules One time Setup π Credentials Used HTTP Request (Magento 2 REST API using Bearer Token) Gmail (OAuth2) Slack (OAuth2 or Webhook) π Tags Magento, Inventory, MSI, Stock Alert, Ecommerce, Slack, Gmail, Automation π Category E-commerce β Magento 2 (Adobe Commerce) π€ Author Kanaka Kishore Kandregula Certified Magento 2 Developer https://gravatar.com/kmyprojects https://www.linkedin.com/in/kanakakishore
By Kanaka Kishore KandregulaSync Attio CRM with Jotform & Slack for deal updates & sales alerts
This workflow streamlines your lead management process by automatically capturing form submissions from Jotform, updating Attio CRM, and notifying your team (sales team for example) via Slack β all without manual work. How it works Receive Lead: A new submission is captured from Jotform (name, email, message). Prepare CRM: Checks if the Pending and Urgent deal stages exist in Attio CRM and creates them if they donβt exist. Checks if the Message column exists in Attio CRM and creates it if it doesn't exist. Lead Handling: If the lead doesn't exist in Attio CRM, the contact is created, a new deal is added to the Pending stage, and a Slack notification is sent. If the lead exists but has no deal, a new deal is added to Pending, and Slack is notified. If the lead exists with a deal, the deal is moved to the Urgent stage, and Slack is notified. Slack Notification: Your team (sales team for example) receives an instant Slack message whenever a new or existing lead is processed, so they can act fast. Requirements Make sure to have Jotform, Attio CRM and Slack accounts, then follow this video guide on how to start using this template.
By AppUnits AI