Telegram User Registration Workflow

This n8n workflow provides a robust and flexible system for managing user registrations via Telegram. It allows for conditional logic to determine if a user is new or already registered, updates a Google Sheet with registration data, and sends appropriate confirmation messages back to the user on Telegram.

What it does

1. Triggers on External Execution: The workflow is designed to be triggered by another n8n workflow, making it a modular component in a larger automation system.
2. Processes User Data: It receives user information, likely from a Telegram bot interacting with users.
3. Applies Conditional Logic: An "If" node evaluates the incoming user data to determine if the user is already registered or is a new registrant.
4. Updates Google Sheets: Based on the conditional check, it either adds new user registration details or updates existing user information in a specified Google Sheet.
5. Sends Telegram Messages: It sends tailored messages back to the user on Telegram, confirming their registration or acknowledging their existing registration.
6. Prepares Data: A "Set" node is used to manipulate and prepare data fields before they are sent to Google Sheets or Telegram, ensuring data consistency and formatting.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to host and execute the workflow.
• Telegram Bot: A configured Telegram Bot with an API token to send and receive messages.
• Google Sheets Account: Access to a Google Sheet where user registration data will be stored and managed.
• Google Sheets Credentials: Configured Google Sheets OAuth 2.0 or API Key credentials in n8n.
• Telegram Credentials: Configured Telegram API credentials (Bot Token) in n8n.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, click "Workflows" in the left sidebar.
   • Click "New" and then "Import from JSON".
   • Paste the JSON content or upload the file.
2. Configure Credentials:
   • Locate the "Google Sheets" node and configure your Google Sheets credentials. You'll likely need to set up an OAuth 2.0 credential for n8n to access your spreadsheets.
   • Locate the "Telegram" node and configure your Telegram Bot API Token credentials.
3. Specify Google Sheet Details:
   • In the "Google Sheets" node, specify the Spreadsheet ID and Sheet Name where user data should be stored.
   • Ensure the sheet has appropriate headers (e.g., User ID, Username, Registration Date) that match the data being sent from the "Edit Fields" (Set) node.
4. Configure Conditional Logic:
   • Review the "If" node to understand the conditions it uses to differentiate between new and existing users. Adjust these conditions as necessary based on your data structure (e.g., checking for a user_id in the Google Sheet).
5. Customize Telegram Messages:
   • Modify the messages in the "Telegram" nodes (both for new and existing users) to fit your desired communication style.
6. Integrate with a Trigger Workflow:
   • This workflow is designed to be triggered by another workflow using the "Execute Workflow Trigger" node. You will need a separate workflow (e.g., a Telegram Trigger workflow) that captures incoming messages and then calls this workflow, passing the necessary user data.
   • Ensure the calling workflow passes the relevant user information (e.g., chat_id, username, first_name) in a format that this workflow can process.
7. Activate the Workflow: Once configured, activate the workflow in n8n.