Template description
Overview
This n8n workflow is designed to extract specific interests from messages in a Telegram chat and retrieve related information using the Facebook Graph API. It aims to provide a streamlined solution for parsing and analyzing user-provided interests within the Telegram platform.
Features
- Interest Extraction: Automatically identifies and extracts interests from messages that start with the hashtag "#interest".
- Data Retrieval: Utilizes the Facebook Graph API to retrieve information related to the extracted interests.
- Structured Outputs: Presents the retrieved data in an organized format for further analysis and review.
Requirements
- Operational instance of n8n (self-hosted or cloud version).
- Basic understanding of n8n workflows and nodes.
Setup and Configuration
- Import Workflow: Load the provided JSON workflow into your n8n instance.
- Configure Telegram Trigger Node: Ensure the Telegram trigger node is set up with the appropriate credentials and webhook ID.
- Configure and Test Nodes: Adjust node parameters as necessary and test the workflow to ensure proper functionality.
How it Works
- Telegram Trigger: Listens for incoming messages in a specified Telegram chat.
- Check Message Contents: Verifies if the message begins with the specified hashtag and is from the designated chat ID.
- Extract Message: Extracts the content of the message for further processing.
- Split Message: Splits the extracted message to identify the interest and remaining content.
- Connect to Graph API: Utilizes the Facebook Graph API to search for information related to the extracted interest.
- Split Interests into a Table: Organizes the retrieved data into a structured table format.
- Get Variables: Maps the retrieved data to create a new JSON object containing specific fields related to the interest.
- Create a Spreadsheet: Generates a spreadsheet file in CSV format based on the retrieved and formatted data.
- Send the Spreadsheet File: Sends the generated spreadsheet file back to the original Telegram chat.
Customization
- Modify the filtering conditions and fields to suit specific requirements.
- Adjust the frequency of the trigger node based on preference.
Best Practices
- Regularly test the workflow to ensure consistent performance.
- Stay informed about any changes to external APIs that might affect the workflow's functionality.
Contributing
Your feedback and contributions are highly valued. Feel free to adapt, modify, and share enhancements with the n8n community.
Share Template
More Marketing workflow templates
+4
OpenAI GPT-3: Company Enrichment from website content
Enrich your company lists with OpenAI GPT-3 ↓
You’ll get valuable information such as:
Market (B2B or B2C)
Industry
Target Audience
Value Proposition
This will help you to:
add more personalization to your outreach
make informed decisions about which accounts to target
I've made the process easy with an n8n workflow.
Here is what it does:
Retrieve website URLs from Google Sheets
Extract the content for each website
Analyze it with GPT-3
Update Google Sheets with GPT-3 data
Lucas Perret
+5
Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel
How it works:
The workflow starts by sending a request to a website to retrieve its HTML content.
It then parses the HTML extracting the relevant information
The extracted data is storted and converted into a CSV file.
The CSV file is attached to an email and sent to your specified address.
The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use.
Set-up steps:
Change the website to scrape in the "Fetch website content" node
Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node)
Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).
Mihai Farcas
+5
Personalize marketing emails using customer data and AI
This workflow uses AI to analyze customer sentiment from product feedback. If the sentiment is negative, AI will determine whether offering a coupon could improve the customer experience.
Upon completing the sentiment analysis, the workflow creates a personalized email templates. This solution streamlines the process of engaging with customers post-purchase, particularly when addressing dissatisfaction, and ensures that outreach is both personalized and automated.
This workflow won the 1st place in our last AI contest.
Note that to use this template, you need to be on n8n version 1.19.4 or later.
n8n Team
