Skip to main content

Export Dialogflow intents with priority levels to Google Sheets via Telegram

n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

What does this workflow do?

This workflow exports the names of all Dialogflow intents from your agent, together with their priority levels, directly into a Google Sheets spreadsheet.
It is triggered via Telegram and includes visual indicators (emojis) for priority levels.

📜 Overview

  • 🔔 Activation:
    Triggered when a validated user sends the keyword (e.g. "backup") via Telegram.

  • 📥 Data Retrieval:
    Fetches all intents of the specified Dialogflow agent using the Dialogflow API.

  • ⚙️ Processing:

    • Transforms each intent into an n8n-compatible item.
    • Extracts the displayName and priority of each intent.
    • Assigns an emoji and descriptive label based on priority tier:
      🔴 Highest, 🟠 High, 🔵 Normal, 🟢 Low, 🚫 Ignore.

  • 📑 Storage:
    Appends each intent (name, priority number, emoji, and description), along with current date and time, to a Google Sheets document.

  • 📩 Notification:
    Sends a single confirmation message to the Telegram user once insertion is complete (using Execute Once).

🛠️ How to install and configure

  1. Import the workflow: Upload the .json into your n8n instance.

  2. Connect Telegram:
    Add your Telegram bot credentials and configure the node Validación de usuario por ID with your Telegram ID.

  3. Configure Dialogflow:
    Authenticate using a Google Service Account API Credential.
    Then, in the Obtiene datos de los intents node, replace the example project ID (TU_PROJECT_ID) with your actual Dialogflow agent's project ID.

  4. Connect Google Sheets:
    Authorize Google Sheets via OAuth2 and select your destination document/sheet in the node Añadir fila en la hoja.

  5. Customize trigger keyword:
    Adjust the command text (default "backup") if needed.

  6. Activate workflow:
    Ensure the webhook is correctly set up in Telegram before enabling the workflow.

👥 Who is this for?

  • 🤖 Bot administrators who need quick backups of Dialogflow intent names.

  • 🌐 Teams managing multilingual or multi-intent agents wanting priority oversight.

  • 💻 Development teams needing an automated way to audit or version intent configurations regularly.

💡 Use Cases

  • ⚙️ Backup intents periodically to monitor changes over time.

  • 📊 Visualize priority assignment in a spreadsheet for analysis or team discussion.

  • 📖 Document conversational structure for onboarding or knowledge transfer.