Rully Saputra
Specializing in software engineering with over 5 years of hands-on experience. In addition to my expertise in web development, I also have experience in creating Hybrid mobile apps.
Categories
Templates by Rully Saputra
Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing
Who’s it for This workflow is ideal for marketing teams, growth analysts, and business owners who need regular Google Analytics insights without manually digging through data. It’s also perfect for organizations that want to ensure positive performance updates reach stakeholders quickly while negative trends get immediate attention from the internal team. How it works / What it does The workflow runs weekly on a set schedule, pulls key performance metrics from Google Analytics, and aggregates the data into a clean summary. An AI Agent (powered by Google Gemini and connected to Simple Memory for historical context) analyzes the data, generates actionable insights, and classifies the sentiment as Positive, Negative, or Neutral. Positive sentiment → Automatically emailed to stakeholders via Gmail. Negative sentiment → Sent instantly to a designated Telegram group for faster response. This ensures wins are celebrated, and issues are addressed promptly. How to set up Configure the Schedule Trigger for your preferred reporting day/time. Connect the Google Analytics node with your property ID and metrics/dimensions. Set up the AI Agent with Google Gemini/others model API credentials. Connect Gmail and Telegram accounts to their respective nodes. Adjust sentiment routing rules. Requirements Google Analytics account with API access Google Gemini API key Gmail account with OAuth connection Telegram bot token and group chat ID How to customize the workflow Modify the AI prompt to include custom KPIs or industry-specific recommendations. Change the schedule frequency (daily, monthly, or on-demand). Add Neutral sentiment handling (e.g., log to Google Sheets). Extend with Slack, Discord, or other notification channels.
By Rully SaputraAutomated product review monitoring with sentiment analysis via Decodo, Gemini & Telegram
Decodo-powered review aggregation to Google Sheets with Gemini analysis and Telegram alerts Who’s it for This template is designed for e-commerce owners, marketplace sellers, product teams, and CX/reputation managers who need an automated way to monitor product reviews. It’s ideal for anyone tracking Amazon listings or other URLs and wants AI-powered sentiment, summaries, and alerts without manual scraping. What it does This workflow automatically retrieves product URLs from Google Sheets, scrapes reviews using Decodo (community node), formats the extracted data, and analyzes it using Gemini AI. It produces both sentiment classification and a concise review summary. Results are saved to a Google Sheets log, and the workflow sends a Telegram alert whenever new reviews are processed. The entire pipeline runs on a schedule, ensuring continuous and fully automated monitoring. How it works A scheduled trigger starts the workflow. Google Sheets provides the list of product URLs. Each URL is processed through Decodo to extract user reviews. A Code node formats the raw review data. Gemini performs sentiment analysis and summarization. Results are appended to a Google Sheets review log. A Telegram message delivers a real-time summary and sentiment snapshot. Sign up for Decodo — get better pricing here Requirements Decodo API credentials (self-hosted community node) Google Sheets API Key Gemini AI credentials Telegram Bot + Chat ID n8n self-hosted (required for Decodo community node) How to set up Add your Decodo credentials to the Decodo node. Update both Google Sheets nodes with your document ID and sheet names. Insert your Gemini API key. Provide your Telegram Bot token and Chat ID. Adjust the schedule interval to your preference. Run the workflow once to validate mappings and output fields. How to customize Modify the Code node to change how reviews are formatted. Extend Gemini prompts for deeper analysis (keywords, categories, toxicity). Add filters to trigger alerts only on negative sentiment. Append additional metadata (timestamps, product IDs) to the Sheets log. Add email, Slack, or other communication channels. Disclaimer (Community Node) This workflow uses a community node (Decodo) and therefore works only on self-hosted n8n instances. Be sure to install and trust the package before using it.
By Rully SaputraAuto-generate sales insights from Sheets using Gemini and notify teams instantly
Daily Sales Metrics Auto-Insight with Gemini, Google Sheets, Calendar, Telegram, Trello and Gmail Who’s it for This workflow is ideal for sales managers, operations teams, and business owners who need daily automated sales summaries and team notifications. It eliminates the hassle of manually gathering, analyzing, and reporting daily sales data, providing instant insights and proactive notifications to keep your team aligned. How it works / What it does This advanced workflow automates the entire daily sales reporting pipeline with actionable team alerts: Webhook captures new sales entries in real-time. The data is logged into Google Sheets. It retrieves all rows to compile current sales metrics. A custom node concatenates the data into an AI-friendly format. The Google Gemini Chat Model generates concise sales insights. HTML tags are cleaned up with a Remove HTML Tags node. The insights are classified (Good, Bad, Very Bad) using AI. Based on the classification: -- Teams are alerted via Telegram group messages. -- For negative insights, a Trello card backlog is created for follow-up. -- A Google Calendar meeting is scheduled automatically to discuss issues. An email summary is also sent out via Gmail to ensure no update is missed How to set up Import the workflow into your n8n instance. Configure the Webhook URL in your data source (POS, CRM, etc.). Connect Google Sheets, Google Gemini API, Trello, Telegram, and Google Calendar. Adjust classification logic inside the Classify Insight node if needed. Customize the message templates for email and Telegram. Test the workflow with sample data to validate automation flow. Requirements n8n account with active workflows. Google Sheets API credentials. Google Gemini API access. Telegram Bot Token & Group ID. Trello API Key & Token. Google Calendar API setup. Gmail or SMTP credentials for email notifications. How to customize the workflow Adjust the Concat Sales Data node if you want to include more fields or different data formats. Modify the Gemini prompt for personalized insight summaries. Change the classification thresholds (Good, Bad, Very Bad) based on your business KPIs. Update the notification messages in Telegram and Email nodes. Add or remove post-classification actions, like creating different task cards or sending escalations to other platforms (Slack, Microsoft Teams, etc.). Automate daily sales insights from Google Sheets using Gemini AI, classify results, and notify your team via email, Telegram, Trello, and Google Calendar instantly. Email Preview
By Rully SaputraMonitor core web vitals with Lighthouse, Gemini AI, Telegram alerts & Google Sheets
Automate Lighthouse report alerts to messenger and Google Sheets Who’s it for This workflow is ideal for developers, SEO specialists, performance engineers, and digital agencies who want to continuously monitor website performance using Core Web Vitals. It’s also perfect for product or infrastructure teams that need real-time alerts when a site underperforms and want a historical log of reports in Google Sheets. What it does This automation periodically fetches a Lighthouse report from the PageSpeed Insights API, checks whether any of the Core Web Vitals (CWV) scores fall below a defined threshold, and sends a notification to Telegram (or any other preferred messenger). It also logs the summarized report in a specific row within a Google Spreadsheet for long-term tracking and reporting. The CWV audit results are processed using JavaScript and passed through a summarization step using Gemini Chat, making the audit descriptions concise and actionable. How to set up Configure the Schedule Trigger node to run at your preferred frequency. Set your target URLs and API Key, then connect the HTTP Request node to Google PageSpeed Insights. Update the JavaScript Code node to filter and parse only CWV metrics. Define thresholds in the IF Node to trigger Telegram messages only when needed. Connect your Telegram (or other messenger) credentials. Set up the Google Sheets node by linking your account and choosing the sheet and range to log data. Requirements Google account with access to Google Sheets Telegram bot token or any preferred messenger API key for PageSpeed Insights Gemini Chat integration (optional for summarization, can be replaced or removed) How to customize the workflow Swap Telegram for Slack, Discord, or email by replacing the Send Notification node. Adjust the CWV thresholds or include other Lighthouse metrics by modifying the IF Node and JavaScript logic. Add multiple URLs to monitor by introducing a loop or extending the schedule with different endpoints. Replace the Gemini Chat model with OpenAI, Claude, or your custom summarizer if needed.
By Rully SaputraAi-powered bug tracking with GitHub issues and Telegram alerts using Gemini
Create GitHub issues from webhook input and send alerts to Telegram This workflow streamlines bug tracking by using a webhook to collect issue reports, automatically classifying and summarizing them with Gemini AI, then sending critical issues to GitHub and real-time notifications to Telegram. Optional manager approval is built in for low-priority reports. 🧑💻 Who’s it for This workflow is ideal for: Engineering teams needing automated issue tracking from multiple systems QA testers or customer support agents who log bugs via custom tools DevOps teams monitoring logs or error reports in real time Teams using GitHub for issue tracking and Telegram (or any messenger) for notifications ⚙️ How it works Webhook Trigger – Listens for incoming POST requests containing bug or task data. AI-Powered Classification – Uses the Gemini model to classify bugs as High or Low severity. Optional Approval – If severity is Low, it waits for a manager’s approval before proceeding. Bug Summary Generation – Passes through a filter and sends the input to Gemini to generate a clean summary. Create GitHub Issue – Submits the summarized issue to your GitHub repository. Telegram Notification – Sends a formatted message to a Telegram group or manager, depending on the path. 🛠️ How to set up Replace the GitHub node with your repo credentials and target repo. Set up the Telegram bot token and chat ID in the Telegram node. Customize the Gemini prompts for your preferred classification and summary logic. Define the conditions for “High” vs “Low” severity based on your data. 📋 Requirements A GitHub account with a personal access token (with repo access) A Telegram bot token and group chat ID Google Gemini API credentials (or your preferred AI model integration) 🔧 How to customize the workflow Swap Telegram with another messaging platform like Slack, Discord, or Microsoft Teams. Adjust classification rules to match your business logic. Change approval flow to notify a different person or add additional logic before sending to GitHub. Extend the webhook input format to support richer data, such as user info or system metadata.
By Rully SaputraAutomated SEO watchlist: continuous audits with Decodo, Gemini & Google Sheets
Automated SEO Watchlist: Continuous Audits Powered by Decodo, Gemini and Google Sheets Automate continuous SEO audits with Decodo and Gemini AI — live data, smart insights, and Google Sheets tracking with team alerts. Who’s it for This workflow is designed for SEO specialists, marketing teams, agencies, and website owners who want an effortless, automated way to monitor SEO health. It’s perfect for ongoing audits, content monitoring, and proactive SEO management — without the manual workload. How it works / What it does Every five days, the workflow: Reads a list of URLs from Google Sheets. Uses Decodo to fetch live on-page data — titles, meta descriptions, headings, schema, links, and Core Web Vitals. Passes that data to Gemini AI for an advanced SEO analysis and scoring based on key factors (content, metadata, links, speed, and structure). Parses results via a Structured Output Parser for clean JSON output. Stores findings in Google Sheets and sends a Telegram alert when the audit completes. Why Decodo matters Decodo is the backbone of this workflow. It powers the real-time page inspection, ensuring Gemini AI has complete, accurate data to analyze. Decodo transforms static audits into live, intelligent monitoring — making your SEO insights far more actionable and reliable. How to set up Connect your Decodo API credentials. Add your Google Sheets URL list. Configure your Telegram bot credentials. Enable the workflow — it runs automatically every 5 days. Requirements Decodo API credentials Google Sheets OAuth connection Telegram Bot token n8n instance (Cloud or Self-hosted) How to customize the workflow Change the trigger interval in the Schedule Trigger node. Modify the SEO Analyzer (LLM Chain) weights for different scoring. Extend the Store Result node to integrate with dashboards or databases. Adjust the AI prompt for additional SEO checks (e.g., backlinks, readability, image optimization). ✅ Highlights Automated SEO auditing Real-time data from Decodo Smart analysis powered by Gemini AI Structured reporting in Google Sheets Team notifications via Telegram
By Rully SaputraAutomated Amazon price monitoring & alerts with Decodo, Google Sheets & Telegram
Sign up for Decodo — get better pricing here Who’s it for This workflow is designed for e-commerce operators, pricing analysts, retail founders, and procurement teams who need reliable, automated price intelligence without manual tracking. If you manage competitive pricing across Amazon or multiple product URLs stored in Google Sheets, this workflow gives you consistent monitoring and automated alerts. What it does This automation checks product prices on a schedule, scrapes real-time Amazon data using Decodo, compares it with your baseline price, and routes alerts depending on whether the price increases, stays normal, or drops. High increases trigger Telegram alerts and automatically create a Google Calendar meeting. Price drops send a rich HTML email to stakeholders. All items are processed in controlled batches to avoid rate limits. How it works Reads product URLs + baseline prices from Google Sheets Uses Decodo to extract current Amazon price, title, and product data Calculates percentage difference via Code node Routes items through the Switch node (High / Normal / Low) Sends alerts or emails accordingly Loops continuously until all rows are processed Requirements Google Sheets, Gmail, Google Calendar, and - Telegram credentials Active Decodo API credentials A sheet containing URL + baseline columns How to customize You can adjust alert thresholds, add more channels (Slack, WhatsApp, Notion), change batch size, modify email templates, or extend the Google Sheet with additional product metadata. The routing logic is easily expandable for more pricing scenarios.
By Rully SaputraClassify & process IT requests with Jotform, Gemini AI and Google Workspace
Who’s it for This workflow is perfect for IT departments, helpdesk teams, or internal service units that manage incoming support requests through Jotform. It automates ticket handling, classification, and response—saving time and ensuring consistent communication. How it works When a new IT service request is submitted through Jotform, this workflow automatically triggers in n8n. The submitted details (name, department, category, comments, etc.) are structured and analyzed using Google Gemini AI to summarize and classify the issue’s priority level (P0–P2). P0 (High): Urgent issues that send an immediate Telegram alert. P1 (Medium) / P2 (Low): Logged in Google Sheets for tracking and reporting. After classification, the workflow sends a confirmation email to the requester via Gmail, providing a summary of their submission and current status. How to set up Connect your Jotform account to the Jotform Trigger node. Add your Google Sheets, Gmail, and (optionally) Telegram credentials. Map your Jotform fields in the “Set” node (Full Name, Department, Category, etc.). Test by submitting a form response. Requirements Jotform account and published IT request form Google Sheets account Gmail account (for replies) Optional: Telegram bot for real-time alerts n8n account (cloud or self-hosted) How to customize the workflow Adjust AI classification logic in the Priority Classifier node. Modify email templates for tone or format. Add filters or additional routing for different departments. Extend to integrate with your internal ticketing or Slack systems.
By Rully SaputraAutomate job matching with Gemini AI, Decodo scraping & resume analysis to Telegram
AI Job Matcher with Decodo, Gemini AI & Resume Analysis Sign up for Decodo — get better pricing here Who’s it for This workflow is built for job seekers, recruiters, founders, automation builders, and data engineers who want to automate job discovery and intelligently match job listings against resumes using AI. It’s ideal for anyone building job boards, candidate matching systems, hiring pipelines, or personal job alert automations using n8n. What this workflow does This workflow automatically scrapes job listings from SimplyHired using Decodo residential proxies, extracts structured job data with a Gemini AI agent, downloads resumes from Google Drive, extracts and summarizes resume content, and surfaces the most relevant job opportunities. The workflow stores structured results in a database and sends real-time notifications via Telegram, creating a scalable and low-maintenance AI-powered job matching pipeline. How it works A schedule trigger starts the workflow automatically Decodo fetches job search result pages from SimplyHired Job card HTML is extracted from the page A Gemini AI agent converts raw HTML into structured job data Resume PDFs are downloaded from Google Drive Resume text is extracted from PDF files A Gemini AI agent summarizes key resume highlights Job and resume data are stored in a database Matching job alerts are sent via Telegram How to set up Add your Decodo API credentials Add your Google Gemini API key Connect Google Drive for resume access Configure your Telegram bot Set up your database (Google Sheets by default) Update the job search URL with your keywords and location Requirements Self-hosted n8n instance Decodo account (community node) Google Gemini API access Google Drive access Telegram Bot token Google Sheets or another database > Note: This template uses a community node (Decodo) and is intended for self-hosted n8n only. How to customize the workflow Replace SimplyHired with another job board or aggregator Add job–resume matching or scoring logic Extend the resume summary with custom fields Swap Google Sheets for PostgreSQL, Supabase, or Airtable Route notifications to Slack, Email, or Webhooks Add pagination or multi-resume processing
By Rully SaputraDecodo-powered AI research paper extraction & summarization with ChatGPT
Sign up for Decodo — get better pricing here Overview This workflow automatically collects the latest AI research papers using Decodo, extracts and summarizes PDFs with AI, stores insights in Google Sheets, and notifies users via Telegram. It turns complex academic research into structured, readable knowledge with zero manual effort. Who’s this for This template is ideal for: AI researchers and ML engineers tracking new papers Founders and product teams monitoring AI trends Content writers and analysts creating research-based content Educators, students, and newsletter creators Anyone who wants automated, summarized research without reading full papers. How it works / What it does A schedule trigger starts the workflow automatically Decodo fetches the latest AI research listings from arXiv reliably and at scale Article titles and PDF links are extracted and structured Each paper PDF is downloaded and converted to text An AI summarization chain generates concise, human-readable summaries Results are saved to Google Sheets as a research database A Telegram message notifies users when new summaries are available --- How to set up Add your Decodo API credentials (required) Connect your OpenAI / ChatGPT-compatible model for summarization Connect Google Sheets and choose your target spreadsheet Add your Telegram bot credentials and chat ID Adjust the schedule trigger if needed, then activate the workflow --- Requirements n8n (self-hosted required due to community node usage) Decodo community node (web extraction) OpenAI or compatible AI model credentials Google Sheets account Telegram bot access ⚠️ Disclaimer: This workflow uses a community node and is supported on self-hosted n8n only. --- How to customize the workflow Change the arXiv category to track different research domains Modify the AI prompt to adjust summary length or tone Replace Google Sheets with another database or knowledge base Disable Telegram notifications if not needed Extend the workflow for SEO blogs, newsletters, or RAG pipelines
By Rully SaputraAnalyze brand competitors using Decodo, Gemini, Telegram and Google Sheets
Analyze brand competitors using Decodo, Gemini, Telegram, and Google Sheets Sign up for Decodo — get better pricing here Who’s it for This workflow is built for content researchers, SEO teams, marketers, educators, and analysts who want to discover and analyze Brand competitor content at scale. It’s especially useful if you need structured insights from pages based on a search query, without manually opening or reviewing each result. How it works / What it does This workflow turns a simple keyword into structured, actionable insights. It starts when a user submits a query through a form. Decodo is used as the core technology to perform a Google search and return relevant organic results. Decodo retrieves the page content, which is cleaned and converted into plain text. An AI agent powered by Gemini analyzes the content to generate clear key points and key takeaways. The extracted insights, along with the source title and link, are saved to Google Sheets for easy review and analysis. A short summary is also sent to Telegram, making it easy to monitor results in real time. How to set up Add your Decodo API credentials. Connect your Google Gemini API credentials. Connect Google Sheets OAuth. Update the target Google Sheet and worksheet. Submit a keyword to start the analysis. Requirements Decodo API account Google Gemini API credentials Google Sheets OAuth credentials n8n self-hosted instance > This workflow uses Decodo community nodes and is intended for self-hosted n8n environments. How to customize the workflow Change the Decodo search query to target different topics or niches. Limit or batch results by adjusting the split and loop logic. Modify the AI prompt to extract different insights. Replace Google Sheets with another database or workspace tool. Add filters, alerts, or scoring logic for advanced analysis.
By Rully Saputra