Blog

  • Building Custom Telegram Bots with PostgreSQL and Firestore

    I recently worked on a project where we built custom Telegram Bots that assist business owners by pulling live reports from their PostgreSQL database or Firestore directly into a private chat. Here’s a high-level overview of the tech stack we used:

    n8n workflows to connect to PostgreSQL and FirestoreVector DBs for cachingWebhooks to trigger custom alertsA Debian 12/AWS setup to run the bot

    The workflow involved creating a custom bot using n8n, which would pull data from the PostgreSQL database or Firestore using the Vector DBs for caching. We then used webhooks to trigger custom alerts and notifications.

    Here’s an example code snippet that demonstrates how to connect to a PostgreSQL database using n8n:

    const { n8n } = require('n8n');async function main() {  const database = new n8n.Database('postgresql://user:password@host:port/database');  const data = await database.execute('SELECT * FROM table');  return data;}main().catch((error) => {  console.error(error);});

    If you’re interested in building custom Telegram Bots with PostgreSQL and Firestore, I’d be happy to help. Contact me for more information.

    Tags: #CustomTelegramBots #PostgreSQL #Firestore #ShahiRaj

    Category: Dev Log

  • Building the AI Doctor Appointment Agent: A Technical Deep Dive

    I’m thrilled to share my experience building the AI Doctor Appointment Agent, a cutting-edge solution that’s revolutionizing the healthcare industry.

    At the core of this agent lies a powerful n8n workflow, which integrates with Google Calendar and Vector DBs for seamless patient scheduling. The entire system is hosted on AWS Mumbai, ensuring scalability and reliability.

    One of the key features of this agent is its ability to manage webhooks, allowing patients to book appointments via WhatsApp/Telegram in real-time. This has been a game-changer in reducing the stress of constant interruptions and enhancing the overall patient experience.

    When building this agent, I focused on creating a scalable and maintainable architecture. The result is a solution that’s not only efficient but also easy to integrate with existing healthcare systems.

    Want to learn more about the tech stack behind the AI Doctor Appointment Agent? Check out my developer log for a detailed overview.

  • Building a Silent Operations Engine with Custom n8n Workflows

    As a developer, I’ve always been fascinated by the potential of n8n workflows to automate repetitive tasks. Recently, I built a custom n8n workflow that’s become the backbone of our silent operations engine.

    Using n8n’s robust API and webhooks, I created a system that automatically routes e-commerce updates and syncs WhatsApp leads to our database. This not only reduces manual labor but also empowers our team to handle increased volumes without additional staff.

    But what’s most impressive is the scalability of our custom workflows. Hosted on a Debian 12/AWS production server, our system can handle 10x the volume without any issues.

    Want to learn more about building custom n8n workflows? Check out our developer resources and start building your own silent operations engine.

    #ShahiRaj #n8n #CustomDev

  • Building the Instant Lead-to-Sheet Magic: A Technical Deep Dive

    I recently worked on a project that utilized the power of AI to revolutionize the way we handle visiting cards. Introducing the ‘Instant Lead-to-Sheet’ magic, powered by our AI Visiting Card Scanner.

    Using n8n as the workflow automation tool, we integrated Vector DBs for efficient data parsing and Webhooks for seamless data transfer to Google Sheets or CRM via AWS Mumbai.

    With this setup, we achieved under 3-second data parsing and transfer, making it an ideal solution for sales teams looking to streamline their workflow.

    Check out the code repository and see how we built the Instant Lead-to-Sheet magic.

  • Building the Zero-Admin Sunday Experience: A Developer’s Journey

    I’ve been experimenting with building an AI Personal Assistant Bot on Telegram/WhatsApp, and the results have been incredible. By leveraging Debian 12 as the underlying OS, I’ve been able to create a seamless experience for users.

    The bot captures ‘random’ weekend ideas, organizes Monday priorities, and tracks spends in real-time, all while running silently in the background.

    My goal was to empower users to be present with their families while the digital assistant takes care of administrative tasks. With this bot, I’ve achieved just that.

    By focusing on automation and streamlining administrative tasks, I’ve been able to create a truly unique experience for users. Want to see how I built this? Check out the code or DM ‘ASSIST’ for more info.

  • Building the ‘Digital Archive’ Assistant

    I recently worked on a project to build a Custom RAG AI Agent that acts as a digital archive assistant for companies. The goal was to create a system that could search through a large amount of private company data, hosted securely on AWS Mumbai, and provide instant answers to team members.

    The tech stack involved using n8n for workflow automation, Vector DBs for efficient data storage, and Webhooks for seamless integration. The AI agent was trained to read and understand the context of various documents, making it a valuable tool for research and decision-making.

    One of the key challenges was ensuring the security and integrity of the data. We used AWS IAM roles to control access and ensure that only authorized team members could access the data.

    With the ‘Digital Archive’ assistant, teams can now focus on high-priority tasks, knowing that their company data is always accessible and up-to-date.

    Want to learn more about building your own Custom RAG AI Agent? Get in touch with our team.

  • Building the Internal Expert: A Technical Deep Dive

    As a developer, I’m always excited to talk about building solutions that make a real impact. Our AI Support Widget is one such solution that can transform your support team’s efficiency and performance.

    By leveraging your own knowledge base and a secure Debian 12 setup, we can absorb 70% of routine queries instantly. This means that your human agents can focus on the complex, high-value customer issues that require their expertise.

    So, how do we do it? We use a combination of n8n, Vector DBs, and Webhooks to create a seamless experience for both customers and support agents. Check out our tech stack

  • Building an AI Visiting Card Scanner: A Technical Deep Dive

    As a developer, I was tasked with building an AI Visiting Card Scanner that could read business cards and sync the data to a user’s Excel/CRM in under 3 seconds. Here’s a technical deep dive into the architecture and implementation of this project.

    We used n8n as our workflow automation tool, Vector DB for our database, and Webhooks for communication between services.

    The AI Visiting Card Scanner uses a combination of OCR (Optical Character Recognition) and machine learning algorithms to extract data from business cards. The extracted data is then sent to the user’s Excel/CRM via AWS Mumbai.

    Want to learn more about the technical details of this project? Reach out to me and I’ll be happy to share more.

  • Building the @MisriCalendarBot: A Technical Overview

    In this post, we’ll take a technical dive into the @MisriCalendarBot, exploring its architecture, APIs, and implementation details.

    We’ll cover the following topics:

    • The API integration with @MumineenORG for namaz timings
    • The implementation of the Dawoodi Bohra Hijri calendar events
    • The weather API integration for the latest forecast

    By the end of this post, you’ll have a deeper understanding of the technical aspects of the @MisriCalendarBot.

  • Building the ‘Founder’s Freedom’ Assistant: A Technical Deep Dive

    I’m excited to share with you my latest project, the ‘Founder’s Freedom’ Assistant, an AI Personal Assistant Bot built using n8n, Vector DBs, and Webhooks.

    The assistant is designed to run on our AWS Mumbai infrastructure and provides lifestyle assistance by organizing thoughts, tracking expenses, and setting priorities. The bot is built using a combination of AWS services and custom code, allowing for seamless integration and scalability.

    I’ll be sharing more about the technical details of the project, including the architecture, code logic, and implementation results, in future posts. Stay tuned!

    Learn more about the ‘Founder’s Freedom’ Assistant and how it can empower you to be 100% present with your family.