Create a Short URL and Get Its Statistics with YOURLS

Overview

This workflow lets you quickly shorten a long URL using YOURLS (a self-hosted URL shortener) and then automatically retrieve statistics (clicks, referrers, etc.) for the shortened link. It’s perfect for marketers, content creators, or anyone who wants to track link performance without relying on third-party services. The workflow is triggered manually, making it ideal for on-demand use.

Nodes and Authentication

  • On clicking 'execute' (Manual Trigger) — No auth. Starts the workflow when the user clicks the "Execute" button in the n8n editor.
  • Yourls (YOURLS node) — API Key auth (signature-based). Takes a long URL and an optional title, creates a short URL via the YOURLS API.
  • Yourls1 (YOURLS node) — API Key auth. Uses the short URL generated by the previous step to fetch click statistics.

What Each Node Does

  • Yourls node:
    • url: The long URL you want to shorten (hardcoded in this example to a Medium article).
    • additionalFields.title: An optional human-readable title for the short link.
    • The node requires YOURLS credentials (API endpoint and signature).
  • Yourls1 node:
    • shortUrl: Expression referencing the output of the Yourls node ($node["Yourls"].json["shorturl"]) to obtain the shortened URL.
    • operation: Set to "stats" to retrieve statistics for that short URL.
    • Also requires the same YOURLS credentials.

Setup Instructions

  1. YOURLS Instance: You need a self-hosted YOURLS installation with the API enabled. (If you don’t have one, see YOURLS.org to set it up.)
  2. Credentials in n8n:
    • Go to Credentials → New and select YOURLS API.
    • Enter your YOURLS installation URL (e.g., https://yourdomain.com/yourls-api.php) and your Signature (the API token from the YOURLS admin panel under Tools).
    • Save the credential and assign it to both YOURLS nodes.
  3. Customize the Long URL: If you want to shorten a different URL, edit the url field in the Yourls node.

Use Cases and Variations

  • Social Media Sharing: Shorten links for Twitter, LinkedIn, or other platforms that have character limits.
  • Campaign Tracking: Use different short URLs for each campaign and automatically pull their stats to compare performance.
  • Email Newsletters: Shorten links in emails and later retrieve click data to measure engagement.
  • Batch Processing: Replace the manual trigger with a Schedule Trigger or Webhook and feed multiple URLs from a Google Sheet or database to create short URLs and log their stats.
  • Alerting: Add an Email or Slack node after Yourls1 to send the statistics to your team automatically.
3 nodesmanual triggerMarketing
Yourls

Workflow JSON

{
  "id": "167",
  "name": "Create a short URL and get the statistics of the URL",
  "nodes": [
    {
      "name": "On clicking 'execute'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        370,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "name": "Yourls",
      "type": "n8n-nodes-base.yourls",
      "position": [
        570,
        300
      ],
      "parameters": {
        "url": "https://medium.com/n8n-io/sending-sms-the-low-code-way-with-airtable-twilio-programmable-sms-and-n8n-90dbde74223e?source=---------4-----------------------",
        "additionalFields": {
          "title": "Sending SMS the Low-Code Way with Airtable, Twilio Programmable SMS, and n8n"
        }
      },
      "credentials": {
        "yourlsApi": "Yourls"
      },
      "typeVersion": 1
    },
    {
      "name": "Yourls1",
      "type": "n8n-nodes-base.yourls",
      "position": [
        770,
        300
      ],
      "parameters": {
        "shortUrl": "={{$node[\"Yourls\"].json[\"shorturl\"]}}",
        "operation": "stats"
      },
      "credentials": {
        "yourlsApi": "Yourls"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
// ... truncated (copy to see full JSON)

How to Import This Workflow

  1. 1Copy the workflow JSON above using the Copy Workflow JSON button.
  2. 2Open your n8n instance and go to Workflows.
  3. 3Click Import from JSON and paste the copied workflow.

Don't have an n8n instance? Start your free trial at n8nautomation.cloud

Related Templates

AI LinkedIn Content Creator with Perplexity Research & Auto-Posting

AI-Powered LinkedIn Content Automation Workflow Overview This workflow automates the entire LinkedIn content lifecycle — from research and ideation to image generation and scheduled posting. It uses Perplexity AI for topic research, an Anthropic Claude model as the content strategist, and OpenAI's image generation model to create branded visuals. The workflow runs on two separate schedules: one for content creation (daily) and one for publishing (twice weekly). It stores all posts in a Google Sheet for review before they go live, giving you full control over what gets published. This is ideal for founders, marketers, and content creators who want to maintain a consistent LinkedIn presence without spending hours writing, designing, and scheduling posts manually. The system learns from past content stored in Google Sheets and uses AI to generate fresh, on-brand posts that resonate with your target audience. Node-by-Node Breakdown Content Creation Pipeline (Runs Daily at 5 AM) Schedule () — No auth. Triggers the content creation workflow daily at 5:00 AM. This is the starting point for generating new post ideas. Get Past Ideas () — OAuth2. Reads all rows from the "LinkedIn Posts" sheet in the Google Sheet "AI Content Database". This provides the AI with context about previously generated posts to avoid repetition. Join Ideas () — No auth. A JavaScript code node that concatenates all past post ideas into a single text string, making it easy for the AI to reference them. LinkedIn Creator Agent () — No auth (uses connected models). This is the core AI agent that generates LinkedIn post content. It uses: - Anthropic Chat Model () — API Key auth. Uses Claude 3.7 Sonnet as the language model for content generation. - Perplexity Research () — API Key auth. A sub-workflow that uses Perplexity AI to research current topics and trends. - Structured Output Parser () — No auth. Ensures the AI output follows a structured JSON format with fields: , , and . Image Style () — OAuth2. Downloads a reference image from Google Drive that serves as the style guide for generating new images. OpenAI Image1 () — Header Auth (HTTP Header Auth). Sends a POST request to OpenAI's image generation API (gpt-image-1 model) with the reference image and a prompt describing the desired image for the LinkedIn post. Convert to File () — No auth. Converts the base64 image data from OpenAI's response into a binary file for saving to Google Drive. Save Image () — OAuth2. Uploads the generated image to a specific folder ("LinkedIn AI Posts") in Google Drive, naming it after the post title. Save Post () — OAuth2. Appends a new row to the "LinkedIn Posts" sheet with the post text, description, image URL, and status set to "review". Publishing Pipeline (Runs Every 3 Days at 2 PM) Schedule 2 () — No auth. Triggers the publishing workflow every 3 days at 2:00 PM. Get Ready Posts () — OAuth2. Filters the Google Sheet for rows where the status column equals "ready", retrieving posts that have been approved for publishing. Pick One () — No auth. Limits the output to a single post (first row) from the filtered results. Download Image () — OAuth2. Downloads the image associated with the selected post from Google Drive using the image URL stored in the sheet. Publish Post () — OAuth2. Publishes the post to LinkedIn with the text content and attached image, set to public visibility. Update Status () — OAuth2. Updates the status of the published post from "ready" to "posted" in the Google Sheet, matching by the "about" column. Setup Instructions Required Accounts & Services Google Account — For Google Sheets and Google Drive access. You'll need to create a Google Cloud Project and enable the Sheets and Drive APIs, then create OAuth2 credentials. Anthropic Account — Sign up at console.anthropic.com to get an API key for Claude 3.7 Sonnet. Perplexity AI Account — Sign up at perplexity.ai and obtain an API key for research capabilities. OpenAI Account — Sign up at platform.openai.com and get an API key for image generation. LinkedIn Account — You'll need a LinkedIn profile or company page to post to. Connect via n8n's LinkedIn OAuth integration. Configuration Steps Create a Google Sheet named "AI Content Database" with a sheet called "LinkedIn Posts" containing columns: , , , . Upload a reference image to Google Drive that represents your brand's visual style. Update the Google Sheet ID and folder IDs in the nodes to match your own. Configure all credential connections in n8n for each service. Adjust the cron schedules to match your desired posting frequency. Customize the AI system prompt in the LinkedIn Creator Agent to match your brand voice. Use Cases & Variations Primary Use Cases Personal Brand Building: Automate daily LinkedIn content for thought leaders and consultants. Agency Content Management: Manage multiple client content calendars from a single workflow. Content Repurposing: Adapt the workflow to generate content for Twitter, Instagram, or newsletters. Possible Variations Platform Swap: Replace the LinkedIn node with Twitter, Facebook, or Slack nodes. Research Source: Swap Perplexity for a Google Search API or RSS feed reader. Image Model: Use DALL-E 3 or Stable Diffusion instead of gpt-image-1. Review Workflow: Add a Slack notification node to alert you when posts are ready for review. Multi-Platform Publishing: Duplicate the publishing pipeline for different social networks. Content Calendar: Add a calendar node to schedule posts for specific dates and times.

23 nodes

Auto-Generate Social Posts from YouTube via Dumpling AI

🧠 Automate Social Media Content Creation from YouTube Videos This powerful workflow automatically generates platform-specific social media posts (Instagram, Facebook, LinkedIn) from YouTube videos. It takes a topic from a Google Sheet, searches for relevant YouTube videos using Dumpling AI, selects the best match with GPT-4o, fetches the transcript, and creates tailored posts with matching AI-generated images — all saved back to your Google Sheet. Perfect for content creators, social media managers, and marketers who want to repurpose YouTube content efficiently. The workflow runs on a schedule, processes one topic at a time, and marks topics as completed to avoid duplication. It combines the power of Dumpling AI for YouTube search and image generation, OpenAI's GPT-4o for intelligent content selection and copywriting, and Google Sheets for data management. 📋 Node-by-Node Breakdown Trigger Search Schedule (Schedule Trigger) — No auth required. Runs the workflow on a configurable interval (default: every hour). You can adjust the schedule in the node settings. Get Unsearched Topic from Google Sheet (Google Sheets) — OAuth2 (Google Sheets). Reads the first unsearched topic from the "YouTube Topics" sheet. Uses a filter to find rows where "Searched?" column is empty, and returns only the first match. Search YouTube via Dumpling AI (HTTP Request) — Header Auth (Dumpling AI API key). Sends a POST request to Dumpling AI's YouTube search endpoint with the topic as query. Returns video results matching the search term. Filter + Sort YouTube Videos (Code) — No auth. Custom JavaScript that extracts video data from the API response, filters for video type, sorts by published date (newest first), and returns the 3 most recent videos. Prepare Video List for AI (Aggregate) — No auth. Combines all video items into a single array for processing by the AI node. Select Best Video with GPT-4o (OpenAI) — API Key auth (OpenAI). Uses GPT-4o to analyze the search results and select the most relevant video based on the original topic and current date. Returns the best match in structured JSON format. Get Transcript (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Fetches the YouTube transcript for the selected video using Dumpling AI's transcript endpoint. Generate Posts with GPT-4o (OpenAI) — API Key auth (OpenAI). Takes the transcript and generates three platform-specific posts (Instagram, Facebook, LinkedIn) with matching image prompts. Each post is tailored to the platform's style and audience. Generate Instagram Image (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Creates an AI-generated image for the Instagram post using FLUX.1-pro model. Generate Facebook Image (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Creates an AI-generated image for the Facebook post. Generate LinkedIn Image (Dumpling AI) (HTTP Request) — Header Auth (Dumpling AI API key). Creates an AI-generated image for the LinkedIn post. Format Instagram Post (Set) — No auth. Structures the Instagram post data with platform name, content text, and image URL. Format Facebook Post (Set) — No auth. Structures the Facebook post data similarly. Format LinkedIn Post (Set) — No auth. Structures the LinkedIn post data similarly. Save Instagram Post to Sheet (Google Sheets) — OAuth2 (Google Sheets). Appends the formatted Instagram post to the "Social Media Post" sheet. Save Facebook Post to Sheet (Google Sheets) — OAuth2 (Google Sheets). Appends the formatted Facebook post to the same sheet. Save LinkedIn Post to Sheet (Google Sheets) — OAuth2 (Google Sheets). Appends the formatted LinkedIn post to the same sheet. Merge Post Results (Merge) — No auth. Combines the three post results into a single output for the final update step. Update Topic Status in Sheet (Google Sheets) — OAuth2 (Google Sheets). Marks the original topic as "Searched?" = "Yes" in the YouTube Topics sheet to prevent reprocessing. 🔧 Setup Instructions Required Accounts & Credentials: Google Account — For Google Sheets access. Create OAuth2 credentials in n8n for Google Sheets. Dumpling AI Account — Sign up at app.dumplingai.com and get your API key. Add as Header Auth credential in n8n. OpenAI Account — Get your API key from platform.openai.com. Add as API Key credential in n8n. Required Google Sheets: YouTube Topics sheet with columns: , Social Media Post sheet with columns: , , 💡 Use Cases & Variations Primary Use Cases: Content repurposing for social media managers Automated content calendar creation YouTube-to-social-media content pipeline Brand consistency across platforms Adaptation Ideas: Add more platforms (Twitter/X, TikTok, Pinterest) Schedule posts directly to social media using n8n integrations Add human review step before posting Use different AI models for image generation Add email newsletter content generation Include video thumbnail generation Add analytics tracking for post performance

20 nodes

Contact Form to Slack & Email Notification Workflow

This workflow automates the process of capturing contact form submissions from your website and immediately notifying your team via Slack while also sending a confirmation email to the submitter. It's designed to help businesses respond faster to leads and inquiries without manual intervention. Workflow Steps Form Submission on Website (No auth) — This node creates a simple web form that collects Name, Email, and Phone from visitors. The form is embedded on your website using the provided webhook URL. No authentication is required as it's a public-facing form. Slack (OAuth2) — Sends a formatted message to your designated Slack channel (e.g., #leads) containing the submitted details. Requires a Slack app with bot token and appropriate channel permissions. Send Email - Gmail (OAuth2) — Sends a thank-you email to the submitter using Gmail API. Requires OAuth2 credentials for a Google account. Send Email - Outlook (OAuth2) — Sends the same thank-you email via Microsoft Outlook API. Requires OAuth2 credentials for a Microsoft account. Setup Instructions Slack: Create a Slack app with chat:write scope, install it to your workspace, and add the bot to your target channel. Gmail: Enable Gmail API in Google Cloud Console, create OAuth2 credentials, and authorize the workflow. Outlook: Register an app in Azure AD, grant Mail.Send permission, and configure OAuth2 credentials. Form: Copy the webhook URL from the Form Submission node and embed it as the form action in your HTML form. Use Cases & Variations Lead capture: Replace Slack with CRM nodes (HubSpot, Salesforce) to create contacts automatically. Multi-channel notifications: Add SMS via Twilio or push notifications via Telegram. Conditional routing: Use IF nodes to route different form responses to different Slack channels or email templates. Data enrichment: Add HTTP Request nodes to enrich lead data (e.g., company info from email domain).

5 nodes

Ready to automate with n8n?

Get affordable managed n8n hosting with 24/7 support.