Budi SJ
I’m a Product Designer who also works as an Automation Developer. With a background in product design and systems thinking, I build user-centered workflows. My focus is on helping teams and businesses work more productively through impactful automation systems.
Templates by Budi SJ
Automated local business lead generator with AI, social media & WhatsApp links
Automated Local Business Lead Generator with AI, Social Media & WhatsApp Links This workflow automates the process of generating and managing local business leads by scraping Google Maps data, analyzing business information with AI, and creating personalized outreach messages. The system searches for local businesses based on keywords and locations, extracts their contact information and reviews, then generates professional outreach messages tailored to each business. Results are stored in Google Sheets and notifications are sent via Telegram. 📊 Google Sheets Template Use this template: Local Business Lead Generator 🔑 Key Features 🔍 Searches Google Maps for local businesses using SerpAPI based on keywords and location parameters 📋 Collects comprehensive business information including name, address, rating, reviews, phone numbers, and websites 🤖 Uses OpenRouter's LLM to analyze business data and generate personalized outreach messages 🌐 Analyzes business websites to provide targeted improvement suggestions 📱 Automatically detects Instagram and TikTok profiles from business websites 🗣️ Generates messages in the local language based on country code settings 📊 Organizes and stores all collected data in Google Sheets with proper categorization 🚀 Sends real-time updates and lead summaries via Telegram bot 💬 Automatically creates WhatsApp links for easy business communication --- 🔧 Requirements SerpAPI Account + API Key – For Google Maps business data extraction OpenRouter Account + API Key – For AI-powered message generation and analysis Telegram Bot + API Token – For notifications and bot interactions Google Sheets – Connected to n8n for data storage Google Sheets Template – Pre-configured with proper column structure --- 🎁 Benefits Fully automated lead generation and outreach system Saves time and increases efficiency for local business marketing High personalization improves engagement and response rate Scalable for any niche or location
By Budi SJAutomated stock news alerts with Google RSS, Gemini & Telegram notifications
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🎯 Purpose This workflow helps you automatically monitor stock related news, extract the main content, summarize it using a LLM (via OpenRouter), and send real time alerts to Telegram and store them in Google Sheets. ⚙️ How It Works Trigger A Cron node triggers the workflow every 15 minutes (adjustable). RSS Feed node checks latest articles from Google Alerts RSS. The workflow filters duplicates using Google Sheets as a log. The article URL is sent to Jina AI Readability API to extract the main body text. The content is summarized using a model from OpenRouter (e.g., Gemini, Claude, GPT-4). You can customize the prompt to suit your tone and analysis needs. The result is appended to a Google Sheets file. Sends the title, summary, and reccomendation to Telegram chat. 🧾 Google Sheets Template Create a Google Sheet using this template: Stock Alert 🧰 Requirements Telegram Bot + your Chat ID OpenRouter account and API key Jina AI account for content extraction Google Account with access to Google Sheets Google Alerts RSS feed 🛠 Setup Instructions Install required credentials: Add OpenRouter API key to n8n credentials. Add Telegram Bot Token and Chat ID. Add Google Sheets credentials. Add Jina AI credentials. Create or copy the Google Sheet using the link above. Go to Google Alerts, create alerts, and copy the RSS feed URL. Replace placeholder API keys and URLs. Adjust Telegram Chat ID. 🔐 Security Note All sensitive credentials (e.g., API keys, personal chat IDs) have been removed from this template. Please replace them using the n8n credentials manager before activating the workflow.
By Budi SJMulti platform content generator from YouTube using AI & RSS
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Multi Platform Content Generator from YouTube using AI & RSS This workflow automates content generation by monitoring YouTube channels, extracting transcripts via AI, and creating platform-optimized content for LinkedIn, X/Twitter, Threads, and Instagram. Ideal for creators, marketers, and social media managers aiming to scale content production with minimal effort. ✨ Key Features 🔔 Automated YouTube Monitoring via RSS feed 🧠 AI-Powered Transcript Extraction using Supadata API ✍️ Multi-Platform Content Generation with OpenRouter AI 🎯 Platform Optimization based on tone and character limits 📬 Telegram Notification for easy preview 📊 Centralized Data Management via Google Sheets > 🗂️ All video data, summaries, and generated content are tracked and stored in a single, centralized Google Sheets template > This ensures full visibility, easy access, and smooth collaboration across your team. --- ⚙️ Workflow Components 🧭 Channel Monitoring Schedule Trigger: Initiates workflow periodically Google Sheets (Read): Pulls YouTube channel URLs HTTP Request + HTML Parser: Extracts channel IDs from URLs RSS Reader: Fetches latest video metadata 🧾 Content Processing Supadata API: Extracts transcript from YouTube video OpenRouter AI: Summarizes transcript + generates content per platform Conditional Check: Prevents duplicate content by checking existing records 📤 Multi-Platform Output LinkedIn: Story-driven format (≤ 1300 characters) X/Twitter: Short, punchy copy (≤ 280 characters) Threads: Friendly, conversational Instagram: Short captions for visual posts 🗃️ Data Management Google Sheets (Write): Stores video metadata + generated posts Telegram Bot: Sends content preview ID Tracking: Avoids reprocessing using video ID --- 🔐 Required Credentials Google Sheets OAuth2 Supadata API OpenRouter API Telegram Bot Token & Chat ID --- 🎁 Benefits ⌛ Save Time: Automates transcript + content generation 🔊 Consistent Tone: Adjust AI prompts for brand voice 📡 Multi-Platform Ready: One video → multiple formats 📂 Centralized Logs via Google Sheets: Easily track, audit, and collaborate 🚀 Scalable: Handle many channels with ease
By Budi SJCreate sales orders with Web POS interface, AI reports, Telegram alerts & sheets
Smart POS System with Live Updates to Telegram & Sheets This Smart POS (Point of Sale) System template provides a lightweight yet powerful sales management solution. It features a modern web based interface for placing orders, with real time integration to Google Sheets and instant Telegram notifications, enhanced by AI-generated reports. Ideal for small businesses, mobile vendors, or anyone who needs a quick and smart POS system. ✨ Key Features 🖥️ Modern web interface with product catalog and search 🛒 Cart system with quantity, price, and discount handling 🆔 Unique Sales ID generation for every transaction 📊 Google Sheets integration to store product and sales data 🤖 AI-generated sales summary via OpenRouter 🚀 Instant Telegram notifications for new orders --- 🔧 Requirements A Google Sheet to store products and sales data 👉 Use this Google Sheets template to get started Telegram Bot Token and User ID (Create a bot via @BotFather) OpenRouter API Key (Sign up at openrouter.ai and use the LLM model) --- ⚙️ Setup Instructions Set Up Your Google Sheets Use the template and fill in product details in the products tab Configure Telegram Bot Create a bot via BotFather Obtain your Bot Token and Chat ID (message the bot once to get ID) Set Up AI Agent In the AI agent node, replace the placeholder with your actual OpenRouter API Key --- 🚀 Deploy the Workflow Activate the workflow in n8n Open the webhook URL to access the POS interface Enter product orders and customer details Submit the order Receive an instant Telegram notification with AI-generated sales summary Data is automatically saved to Google Sheets for tracking and analysis
By Budi SJPersonalized weather assistant with Google Calendar, WeatherAPI, Gemini & Telegram
Personalized Weather Assistant with Google Calendar, WeatherAPI, AI & Telegram This workflow automates the delivery of a personalized daily agenda by combining events from Google Calendar with real-time local weather conditions. Using AI-powered summarization and Telegram integration, users receive a friendly and motivating message every morning everything needed to plan the day effectively. Perfect for professionals or individuals who want an overview of their schedule and weather in one place. 🛠️ Key Features Triggered automatically every morning by schedule Fetches Google Calendar events for today and tomorrow Retrieves weather conditions (temperature, humidity, wind, UV index) using WeatherAPI based on event location Uses AI Agent to generate a concise, human-friendly agenda summary Sends the summary via Telegram bot If no location is available, delivers a simplified agenda without weather 🔧 Requirements Google Calendar OAuth2 credentials connected to n8n WeatherAPI key (weatherapi.com) Telegram Bot Token and user chat_id OpenRouter API Key (openrouter.ai) 🧩 Setup Instructions Timezone Adjust timezone in the Set Timezone node Google Calendar Add Google Calendar OAuth2 credentials Set your primary calendar ID in the Get many events node WeatherAPI Replace the API key in the HTTP Request node with your WeatherAPI key OpenRouter Create credentials in n8n and connect them to the OpenRouter Chat Model nodes Telegram Add your bot token and chat_id to both Telegram nodes Deploy Activate the workflow You’ll start receiving personalized daily Telegram messages
By Budi SJAnalyze YouTube comments sentiment & keywords with Gemini AI and Telegram reporting
YouTube Comment Sentiment & Keyword Extractor Template Google Sheets: Click here to open This workflow automatically retrieves comments from YouTube videos listed in Google Sheets, analyzes sentiment and keywords using an LLM, stores the results, then generates an aggregate summary and sends a report to Telegram. --- ✨ Key Features Automated Scheduling – Runs the process at regular intervals. Google Sheets Integration – Fetches a list of videos and stores analysis results directly in Google Sheets. YouTube Comment Retrieval – Retrieves top-level comments (up to 100 per video; can be extended with pagination). Comment Parsing – Flattens the API response into one item per comment. AI Sentiment & Keyword Analysis – Powered by an LLM model to extract: Sentiment (positive, neutral, negative) Sentiment score (-1 to 1) Keywords (cleaned from stopwords, emojis, hashtags) Language (ISO 639-1, 2-letter code) Data Normalization – Ensures LLM output is consistent and safe to write to the sheet. Telegram Reporting – Sends a concise report for each video directly to a Telegram chat. --- 🔐 Required Credentials Google Sheets OAuth2 API – Read & write access to the spreadsheet. YouTube Data API Key – To fetch comments via commentThreads. OpenRouter API Key – To access the LLM model. Telegram Bot API – To send reports via a Telegram bot. --- 🎁 Benefits End-to-End Automation – From comment retrieval to reporting, no manual steps required. No Duplication – Each comment is uniquely tracked by comment_id. Data Transparency – Raw and analyzed data stored neatly in Google Sheets. Actionable Insights – Sentiment and keyword summaries ready for content strategy decisions. Scalable – Can be extended for pagination, reply comment analysis, or additional metrics. Cross-Platform – Direct Telegram integration for easy monitoring on any device.
By Budi SJImport research papers from Telegram to Zotero with AI abstract summaries
Automatically Import Research Papers using DOI URL from Telegram to Zotero This workflow allows you to automatically import research papers into your Zotero library by simply sending a DOI link through Telegram. It fetches metadata from reliable sources such as Crossref, DataCite, and Unpaywall, enriches the bibliographic details, attaches the best available full-text PDF when possible, and generates a concise summary of the abstract using an LLM before sending it back to Telegram. ✨ Key Features Telegram Integration – Send a DOI link via Telegram bot to trigger the workflow. DOI Parsing – Automatically detects and extracts DOI or arXiv identifiers from user messages. Metadata Fetching – Retrieves bibliographic information from Crossref, DataCite, and Unpaywall. Smart PDF Finder – Locates the best available PDF (publisher link, open access, or arXiv). Zotero Integration – Creates a Zotero parent item with complete metadata and attaches the PDF link when available. Abstract Summarization – Uses a basic LLM chain to generate a short and clear summary of the abstract. Telegram Feedback – Sends the title, URL, and abstract summary back to the user in Telegram. 🔑 Required Credentials Telegram API – To connect the workflow with your Telegram bot. Zotero API Key – To create and update items in your Zotero library. OpenRouter API Key – To enable the LLM for generating abstract summaries. (Optional) Email for Unpaywall API requests (recommended for stable access). 💡 Benefits Save time by automating manual research paper imports. Ensure high-quality metadata by combining multiple sources (Crossref, DataCite, Unpaywall). Get instant summaries of abstracts directly in Telegram for quick understanding. Keep your Zotero library organized with accurate titles, abstracts, authors, and tags. Quickly attach available full-text PDFs without manual searching. Improve your academic workflow by managing references and summaries directly from Telegram.
By Budi SJBrand DNA generator using JotForm, Google Search, Gemini AI & Notion
Automated Brand DNA Generator Using JotForm, Google Search, AI Extraction & Notion The Brand DNA Generator workflow automatically scans and analyzes online content to build a company’s Brand DNA profile. It starts with input from a form, then crawls the company’s website and Google search results to gather relevant information. Using AI-powered extraction, the system identifies insights such as value propositions, ideal customer profiles (ICP), pain points, proof points, brand tone, and more. All results are neatly formatted and automatically saved to a Notion database as a structured Brand DNA report, eliminating the need for manual research. 🛠️ Key Features Automated data capture, collects company data directly from form submissions and Google search results. Uses AI-powered insight extraction with LLMs to extract and summarize brand-related information from website content. Fetches clean text from multiple web pages using HTTP requests and a content extractor. Merges extracted data from multiple sources into a single Brand DNA JSON structure. Automatically creates a new page in Notion with formatted sections (headings, paragraphs, and bullet points). Handles parsing failures and processes multiple pages efficiently in batches. 🔧 Requirements JotForm API Key, to capture company data from form submissions. SerpAPI Key, to perform automated Google searches. OpenRouter / LLM API, for AI-based language understanding and information extraction. Notion Integration Token & Database ID, to save the final Brand DNA report to Notion. 🧩 Setup Instructions Connect your JotForm account and select the form containing the fields Company Name and Company Website. Add your SerpAPI Key. Configure the AI model using OpenRouter or LLM. Enter your Notion credentials and specify the databaseId in the Create a Database Page node. Customize the prompt in the Information Extractor node to modify the tone or structure of AI analysis (Optional). Activate the workflow, then submit data through the JotForm to test automatic generation and Notion integration. 💡 Final Output A complete Brand DNA Report containing: Company Description Ideal Customer Profile Pain Points Value Proposition Proof Points Brand Tone Suggested Keywords All generated automatically from the company’s online presence and stored in Notion with no manual input required.
By Budi SJ