Akram Kadri
n8n Automation Freelancer ------------------------ Contact me at: akram@digispruce.com
Templates by Akram Kadri
Generate text images from the Free DummyJSON API using the HTTP request node
Who is this for? This workflow template is ideal for marketers, designers, content creators, and developers who need to generate custom text-based images dynamically. Whether you want to create social media graphics, placeholder images, or text-based LinkedIn carousels, this workflow provides a simple, no-code solution using an API that requires no authentication. What problem does this workflow solve? Creating text-based images often requires design software or complex integrations with graphic tools. This workflow eliminates that hassle by allowing users to generate images with custom text, font styles, colors, and background colors using a simple HTTP request. It’s perfect for automating image generation without relying on external tools or manual effort. What this workflow does This workflow leverages an HTTP request to a free API that generates text-based images dynamically. Here's what it enables you to do: Define custom image text Set image dimensions (width x height) Choose a background color and text color using hex codes Select a font family and font size Specify the image format (PNG, JPG, or WebP) The generated image can be used immediately, making it ideal for automating content creation workflows. Setup Open the workflow in n8n. Modify the Set node to define your preferred image properties: text: The message displayed on the image. size: Image dimensions (e.g., 500x300 pixels). backgroundColor: Hex color code for the background. textColor: Hex color code for the text. fontFamily: Select from available font options (e.g., Pacifico, Ubuntu). fontSize: Define the text size. type: Choose the image format (PNG, JPG, or WebP). Execute the workflow to generate an image. The HTTP request returns the generated image, ready for use. How to customize this workflow Adjust the Set node values to match your desired design. Use dynamic data for text, allowing personalized images based on user input. Automate image delivery by adding email or social media posting nodes. Integrate this workflow into larger automation sequences, such as content marketing pipelines.
By Akram KadriGenerate business leads with OpenStreetMap data and save to Google Sheets
Who is this template for? This n8n lead generation workflow template is designed for business owners, marketers, sales professionals, and entrepreneurs who need to generate targeted business leads without paying for expensive APIs or third-party services. The template leverages the free Overpass API (powered by OpenStreetMap data) to gather comprehensive business information for any industry in almost any region worldwide. Perfect for: Small businesses looking to expand their customer base Real estate agents seeking potential clients Marketing agencies needing targeted lead lists Entrepreneurs researching potential markets Sales teams building prospect databases You can watch the video tutorial here: https://youtu.be/6WVfAIXdwsE How it works This n8n lead generation template provides a powerful solution using n8n core nodes and the free OpenStreetMap Overpass API, allowing you to generate thousands of business leads with comprehensive contact information: Data Collection Process Define Your Queries Create a list of search queries combining keywords (like "real estate", "dentist", etc.) with target locations Use both inner areas (specific cities) and outer areas (broader regions) to precisely target your search Iterative Query Execution The workflow processes each query in sequence, preventing API timeout issues Each query triggers a sub-workflow that handles the data extraction process Data Extraction via OpenStreetMap's Overpass API Searches for businesses matching your keywords in name, description, and relevant OpenStreetMap tags Collects comprehensive business data including names, addresses, and contact details from the OpenStreetMap database Searches using both regular expressions and exact tag matching for optimal n8n lead generation results Website Scraping for Additional Information For businesses with websites but missing email addresses, the workflow visits their homepage Extracts email addresses using regular expressions for more complete contact information Filters out irrelevant emails using configurable patterns Data Cleaning and Organization Removes duplicate contact information and standardizes data format Filters results based on your specific requirements for contact details Saves all extracted data to Google Sheets for easy access and management Setup Configure Your Queries: Open the "Run Workflow" node and input your list of queries Format queries with outer area, inner area, and keyword (e.g., "California,Los Angeles,real estate") Optimize Tag Targeting: After initial runs, identify the specific tags used by your target industry Update the HTTP Request node with these specific tags to improve result quality Common tags include "office", "shop", and "amenity" with industry-specific values Configure Data Filters: Customize the filter node to keep only results meeting your specific requirements Adjust the email filtering regex to remove irrelevant email addresses Set up Google Sheets Integration: Configure the Google Sheets node to save results to your preferred spreadsheet Authorize the connection to your Google account Run the Workflow: Start the workflow and watch as your Google Sheet fills with comprehensive business leads The template automatically handles pagination and rate limiting to prevent API timeouts The resulting leads include comprehensive contact information such as: Business names Complete addresses (street, city, postal code) Phone numbers Email addresses (both from API and website scraping) Website URLs Social media accounts Opening hours And more!
By Akram Kadri