n8n templatesn8n templates

Telegram Keyword-Triggered Facebook Interest Tag Query and Report Generation

This workflow automatically receives specific keywords in Telegram, calls the Facebook Graph API to query relevant advertising interest tags, and generates a structured CSV report, which is then sent back to the designated Telegram group. It addresses the need for marketers and data analysts to quickly obtain interest tag information before launching campaigns, enhancing the efficiency and accuracy of data acquisition, and facilitating team collaboration and information sharing.

Workflow Diagram
Telegram Keyword-Triggered Facebook Interest Tag Query and Report Generation Workflow diagram

Workflow Name

Telegram Keyword-Triggered Facebook Interest Tag Query and Report Generation

Key Features and Highlights

This workflow automatically processes specific keywords (e.g., #interest) received in Telegram messages to invoke the Facebook Graph API for searching relevant advertising interest tags. It extracts and organizes detailed information about these interest tags, generates a structured CSV report, and automatically sends it back to a designated Telegram group. This creates a closed-loop system for rapid interest tag querying and data sharing.

Core Problem Addressed

It solves the pain point faced by marketers and data analysts who need to quickly obtain and filter Facebook advertising interest tag information before launching social media ad campaigns. The workflow eliminates the cumbersome manual API queries, improving data acquisition efficiency and accuracy.

Application Scenarios

  • Interest tag research prior to social media advertising campaigns
  • Market analysis and audience targeting data collection
  • Automated report generation and team sharing
  • Rapid response to interest tag query requests within Telegram groups

Main Process Steps

  1. Listen to Telegram Messages: Capture messages starting with "#interest" using the Telegram Trigger node;
  2. Validate Message Content: Verify that the message originates from a specified group and matches the keyword format;
  3. Extract Keywords and Query Content: Parse the message to separate the interest tag keyword and query text;
  4. Call Facebook Graph API: Use the extracted keyword to call the Facebook Ads Interest Search API and retrieve relevant interest data;
  5. Data Processing and Splitting: Convert the complex data structure returned by the API into tabular form;
  6. Variable Extraction and Organization: Extract key fields such as name, audience size, description, and path;
  7. Generate CSV Report: Create a CSV spreadsheet file from the organized data;
  8. Send Report to Telegram Group: Automatically send the generated report file back to the specified Telegram group for members to view and download.

Involved Systems or Services

  • Telegram: Message triggering and report file delivery
  • Facebook Graph API: Advertising interest tag data querying
  • n8n Built-in Nodes: Automation nodes for code execution, condition checking, and file generation

Target Users and Value

  • Digital Marketers: Simplify interest tag research workflows and quickly obtain precise data to support advertising strategies
  • Data Analysts: Automate data collection and report generation to enhance work efficiency
  • Community Managers: Facilitate direct query interaction within Telegram groups for easier team collaboration and information sharing
  • Product Managers and Business Decision Makers: Gain real-time insights into market interest trends to accelerate decision-making processes

By seamlessly integrating Telegram with the Facebook API, this workflow automates interest tag querying and data visualization, significantly enhancing data preparation efficiency and collaboration convenience before social media advertising campaigns.