Rakin Jakaria
Categories
Templates by Rakin Jakaria
Lead generation agent
Who this is for This workflow is for digital marketing agencies or sales teams who want to automatically find business leads based on industry & location, gather their contact details, and send personalized cold emails — all from one form submission. --- What this workflow does This workflow starts every time someone submits the Lead Machine Form. It then: Scrapes business data (company name, website, phone, address, category) using Apify based on business type & location. Extracts the best email address from each business website using Google Gemini AI. Stores valid leads in Google Sheets. Generates cold email content (subject + body) with AI based on your preferred tone (Friendly, Professional, Simple). Sends the cold email via Gmail. Updates the sheet with send status & timestamp. --- Setup To set this workflow up: Form Trigger – Customize the “Lead Machine” form fields if needed (Business Type, Location, Lead Number, Email Style). Apify API – Add your Apify Actor Endpoint URL in the HTTP Request node. Google Gemini – Add credentials for extracting email addresses. Google Sheets – Connect your sheet for storing leads & email status. OpenAI – Add your credentials for cold email generation. Gmail – Connect your Gmail account for sending cold emails. --- How to customize this workflow to your needs Change the AI email prompt to reflect your brand’s voice and offer. Add filters to only target leads that meet specific criteria (e.g., website must exist, email must be verified). Modify the Google Sheets structure to track extra info like “Follow-up Date” or “Lead Source”. Switch Gmail to another email provider if preferred. ---
By Rakin JakariaAmazon affiliate marketing automation
Who this is for This workflow is for Amazon affiliate marketers and social media managers who want to quickly turn product links into engaging Facebook posts with AI-generated captions and images — fully automated. --- What this workflow does This workflow starts every time a new Product Link is added to a connected Google Sheet. It then: Extracts the ASIN from the product link. Fetches product details from Amazon using RapidAPI. Generates a short, scroll-stopping Facebook caption with OpenRouter AI. Creates a product image prompt and sends it to Google Gemini for high-quality image generation. Uploads the creative directly to Facebook via the Facebook Graph API. Marks the Google Sheet row as “Done ✅” after posting. The Facebook post includes: Product image (AI-enhanced) Short, benefit-focused caption with emojis Affiliate link --- Setup To set this template up, follow the sticky notes inside the workflow and: Google Sheets → Connect your sheet and ensure the columns “Product Link” & “Facebook Upload” exist. RapidAPI → Add your API key in the “Amazon Product Details” node. OpenRouter → Add credentials for caption generation. Google Gemini → Add your API key for image generation. Facebook Graph API → Connect your Facebook account for posting. --- How to customize this workflow to your needs Change the Facebook caption prompt to match your tone or branding. Adjust the AI image generation prompt to fit your preferred photography style. Modify the Google Sheet update logic if you want to track additional info (e.g., posting date, engagement stats). Switch Facebook posting to Instagram or another platform by replacing the final API call.
By Rakin JakariaJob applying agent
Who this is for This workflow is for freelancers, job seekers, or service providers who want to automatically apply to businesses by scraping their website information, extracting contact details, and sending personalized job application emails with AI-powered content — all from one form submission. What this workflow does This workflow starts every time someone submits the Job Applier Form. It then: Scrapes the target business website to gather company information and contact details. Converts HTML content to readable markdown format for better AI processing. Extracts email addresses and creates a company summary using GPT-5 AI. Validates email addresses to ensure they contain proper formatting (@ symbol check). Accesses your experience data from a connected Google Sheet with your skills and portfolio. Generates personalized application emails (subject + body) using GPT-5 based on the job position and company info. Sends the application email automatically via Gmail with your name as sender. Provides confirmation through a completion form showing the AI's response. Setup To set this workflow up: Form Trigger – Customize the job application form fields (Target Business Website, Applying As dropdown with positions like Video Editor, SEO Expert, etc.). OpenAI GPT-5 – Add your OpenAI API credentials for both AI models used in the workflow. Google Sheets – Connect your sheet containing your working experience data, skills, and portfolio information. Gmail Account – Link your Gmail account for sending application emails automatically. Experience Data – Update the Google Sheet with your relevant skills, experience, and achievements for each job type. Sender Name – Modify the sender name in Gmail settings (currently set to "Jamal Mia"). How to customize this workflow to your needs Add more job positions to the dropdown menu (currently includes Video Editor, SEO Expert, Full-Stack Developer, Social Media Manager). Modify the AI prompt to reflect your unique value proposition and application style. Enhance email validation with additional checks like domain verification or email format patterns. Add follow-up scheduling to automatically send reminder emails after a certain period. Include attachment functionality to automatically attach your resume or portfolio to applications. Switch to different email providers or add multiple sender accounts for variety.
By Rakin JakariaYouTube trends finding agent
Who this is for This workflow is for content creators, digital marketers, or YouTube strategists who want to automatically discover trending videos in their niche, analyze engagement metrics, and get data-driven insights for their content strategy — all from one simple form submission. What this workflow does This workflow starts every time someone submits the YouTube Trends Finder Form. It then: Searches YouTube videos based on your topic and specified time range using the YouTube Data API. Fetches detailed analytics (views, likes, comments, engagement rates) for each video found. Calculates engagement rates and filters out low-performing content (below 2% engagement). Applies smart filters to exclude videos with less than 1000 views, content outside your timeframe, and hashtag-heavy titles. Removes duplicate videos to ensure clean data. Creates a Google Spreadsheet with all trending video data organized by performance metrics. Delivers the results via a completion form with a direct link to your analytics report. Setup To set this workflow up: Form Trigger – Customize the "YouTube Trends Finder" form fields if needed (Topic Name, Last How Many Days). YouTube Data API – Add your YouTube OAuth2 credentials and API key in the respective nodes. Google Sheets – Connect your Google Sheets account for automatic report generation. Engagement Filters – Adjust the 2% engagement rate threshold based on your quality standards. View Filters – Modify the minimum view count (currently 1000+) in the filter conditions. Regional Settings – Update the region code (currently "US") to target specific geographic markets. How to customize this workflow to your needs Change the engagement rate threshold to be more or less strict based on your niche requirements. Add additional filters like video duration, subscriber count, or specific keywords to refine results. Modify the Google Sheets structure to include extra metrics like "Channel Name", "Video Duration", or "Trending Score". Switch to different output formats like CSV export or direct email reports instead of Google Sheets.
By Rakin JakariaPersonal knowledgebase AI agent
How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger: The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2). It checks whether the link is already processed. Link Type Detection: The system identifies if the URL is from YouTube or a standard article. Data Retrieval: If it’s YouTube: Uses Apify to fetch the transcript. If it’s an article: Uses an HTTP Request node to fetch the webpage content. AI Summarization: The transcript or article content is passed to Google Gemini for refined summarization. Google Sheets Storage: The summary and title are appended to another sheet (Sheet1) for long-term storage, along with a “Stored” status update in Sheet2. Telegram Assistant: A Telegram Trigger listens for messages from the user. The assistant searches stored summaries in Google Sheets. If a match is found, it returns the result to the user on Telegram; otherwise, it politely apologizes. ---
By Rakin JakariaPersonal AI agent
--- Use cases are many: Manage your Gmail inbox, schedule calendar events, and handle contact details — all from one central AI-powered assistant. Perfect for freelancers managing clients, agency owners who need streamlined communication, or busy professionals who want a personal AI secretary handling their email and calendar. --- Good to know At time of writing, each Gemini request is billed per token. See Gemini Pricing for the latest info. The workflow requires Gmail, Calendar, Sheets, and Telegram integrations. Ensure you’ve set up OAuth2 credentials correctly before running. --- How it works Triggers: The workflow listens for new Gmail messages or Telegram commands. Smart AI Processing: Incoming emails are summarized, classified (Client, Sponsorship, or Not Business), and labeled automatically. Auto-Replies: Depending on classification, the assistant sends pre-written replies (e.g., client acknowledgment, sponsorship rates, or polite rejection). Calendar Management: Through natural language requests in Telegram, you can schedule, update, or delete calendar events with conflict-checking in place. Contact Handling: If you send an email to someone not yet in your database, the agent will prompt you for their email, add it to Google Sheets, and reuse it for future tasks. Memory: The AI maintains conversation context, so repeated tasks feel seamless and natural. --- How to use Send commands via Telegram like: “Schedule a meeting with Sarah on Monday at 3 PM” “Send an email to David about the proposal” Watch as the assistant checks your calendar, sends emails, and keeps your contacts updated — all automatically. --- Requirements Gmail account (with labels created for Client, Sponsorship Request, and Not Business*) Google Calendar for scheduling Google Sheets for contact management Google Gemini API key Telegram bot for live interaction --- Customising this workflow You can expand it to: Handle Slack or WhatsApp messages in addition to Telegram. Add more classification categories (e.g., Invoices, Personal, Leads). Extend auto-replies with dynamic templates stored in Google Sheets. Log all interactions to Notion or Airtable for a CRM-style history of communications. --- 👉 Rakin Jakaria
By Rakin JakariaAI invoice agent
--- 📄 AI Invoice Agent The AI Invoice Agent automates the invoice creation, email delivery, and status tracking process for client billing. It ensures invoices are generated, sent professionally, and updated in Google Sheets with minimal manual work. --- 🔹 How It Works Trigger Activated manually (Execute Workflow) when you want to process invoices. Fetch Invoices Reads client invoice data from a Google Sheet (Client Invoices). Filter Pending Invoices Passes through only invoices with Status = Pending. Prepare Invoice Data Collects and formats details: Invoice ID Client Name & Address Project Name Amount (USD) Invoice Date (today’s date) Due Date (7 days later) Loop Over Invoices Processes each invoice one by one. AI Email Draft Uses GPT-4.1-mini to generate a polite, professional email. Tone: friendly but business-oriented. Signed as Upward Engine Team. Extract Email Parts Separates subject and body from the AI output using an Information Extractor. Generate Invoice PDF Uses CraftMyPDF to create a formatted invoice PDF with: Company details (Upward Engine) Client details Invoice ID, Date, Due Date Amount due Footer message Send Email to Client Sends invoice email via Gmail, attaching the PDF invoice. Update Invoice Status Updates Google Sheets to mark the invoice as Completed. Saves Invoice ID, Date, Due Date, and updated status. Loop Continuation Continues until all pending invoices are processed. --- 🔹 Tools & Integrations Google Sheets → Stores client & invoice data Filter Node → Selects only Pending invoices GPT-4.1-mini (OpenAI) → Generates professional emails Information Extractor → Separates subject & body CraftMyPDF → Creates PDF invoices Gmail → Sends invoice emails with PDF attachments --- 🔹 Example Workflow ✅ Google Sheets: Invoice marked as Pending ➡️ AI generates email → “Invoice INV-1023 for Web Design Project – Due Sep 5” ➡️ PDF invoice created & attached ➡️ Email sent to client with subject + body ➡️ Status updated in Google Sheet → Completed --- ⚡ This agent ensures zero missed invoices, professional client communication, and up-to-date tracking — fully automated for agencies and small businesses. ---
By Rakin JakariaLanding page analyzing agent
Use Cases Analyze e-commerce product pages for conversion optimization, audit SaaS landing pages for signup improvements, or evaluate marketing campaign pages for better lead generation. Good to know At time of writing, Google Gemini API calls have usage costs. See Google AI Pricing for current rates. The workflow analyzes publicly accessible pages only - pages behind login walls or with restricted access won't work. Analysis quality depends on page content structure - heavily image-based pages may receive limited text-based recommendations. How it works User submits a landing page URL through the form trigger interface. The HTTP Request node fetches the complete HTML content from the target landing page. Content is converted from HTML to markdown format for cleaner AI processing and better text extraction. Google Gemini 2.5 Flash analyzes the page using expert CRO knowledge and 2024 conversion best practices. The AI generates specific, actionable recommendations based on actual page content rather than generic advice. Information Extractor processes the analysis into 5 prioritized improvement tips with relevant visual indicators. Results are delivered through a completion form showing concrete steps to improve conversion rates. How to use The form trigger is configured for direct URL submission but can be replaced with webhook triggers for integration into existing websites or apps. Multiple pages can be analyzed sequentially, though each requires a separate workflow execution. Recommendations focus on high-impact changes that don't require heavy development work. Requirements Google Gemini (PaLM) API account for AI-powered analysis Publicly accessible landing pages for analysis N8N instance with proper webhook configuration Customizing this workflow CRO analysis can be tailored for specific industries by modifying the AI system prompt - try focusing on e-commerce checkout flows, SaaS trial conversions, or local business lead capture forms. Add competitive analysis by incorporating multiple URL inputs and comparative recommendations.
By Rakin JakariaMeeting management agent
--- Use cases are many: Let users book, check, reschedule, or cancel meetings directly from Telegram. Perfect for solopreneurs, agencies, or teams who want an AI-powered assistant that prevents double-bookings, manages Google Calendar, and even sends email invites automatically. --- Good to know At time of writing, this workflow uses OpenAI GPT-4.1-mini for natural conversation handling. See OpenAI Pricing for updated info. This workflow relies on Google Calendar for scheduling — if the model says “conflict found,” it means an event already exists in that time slot. --- How it works Telegram Chat: A user types natural requests like “Book a meeting with Sarah tomorrow at 2 PM” or “Do I have meetings on Friday?”. AI Agent (OpenAI): Interprets the request, calculates dates (using Date & Time), and decides whether to create, update, or delete a meeting. Conflict Checking: Before booking, the agent checks Google Calendar for existing events to avoid overlaps. Meeting Management: Create: Adds new events with title, description, attendees. Update: Edits existing events. Delete: Cancels meetings if requested. Get: Lists all meetings for a date or time range. Notifications: Replies instantly on Telegram and, if needed, sends a Gmail email with meeting details. Memory: Keeps context of the conversation so users can speak naturally (“reschedule that meeting to 4 PM instead”). --- How to use Start a Telegram chat with the bot. Type a request in plain English (no need for structured inputs). The agent will confirm or suggest alternatives if a conflict exists. Meetings appear in Google Calendar and details can be emailed via Gmail. --- Requirements Telegram bot connected to n8n OpenAI API key (for AI-driven scheduling assistant) Google Calendar account (for event creation & conflict checking) Gmail account (for sending invites & confirmations) --- Customising this workflow Add support for multiple calendars (work, personal, shared). Change the conflict-resolution logic (e.g., auto-suggest nearest free slot). Include recurring meetings (weekly standups, monthly reviews). Add Slack or WhatsApp integration for multi-platform scheduling. Extend Gmail invites with calendar attachments (.ics files). --- 👉 Rakin Jakaria
By Rakin JakariaAutomated resume screening & response system with Gemini AI, Gmail and Sheets
--- Use cases are many: Automate resume screening, candidate scoring, and interview communication in one seamless pipeline. Perfect for HR teams hiring at scale, startups that need quick filtering of applicants, or enterprises like Samsung running multiple roles at once. --- Good to know At time of writing, each Gemini request is billed per token. See Gemini Pricing for the latest info. The workflow automatically sends acceptance or rejection emails to candidates — be sure to configure your Gmail account and email templates carefully. --- How it works Form Submission: Applicants fill out a custom form with their name, email, job role (Executive Assistant, IT Specialist, or Manager), and resume (PDF). Resume Processing: The PDF resume is extracted into text using the Extract from File node. AI Evaluation: Gemini-powered AI reviews the resume against the job role and generates: A score (0–10) A status (Accepted/Rejected) A personalized email (acceptance or rejection) Information Extraction: The AI output is structured into fields: Score, Status, Mail Subject, and Mail Body. Email Sending: The candidate automatically receives their personalized result via Gmail. Record Keeping: All candidate details (Name, Job, Score, Status, Email, Email Status) are stored in Google Sheets for tracking. --- How to use Share the generated form link with applicants. When they submit, the system handles scoring and sends an email instantly. HR teams can review all results directly in Google Sheets. --- Requirements Google Gemini API key (for resume evaluation) Gmail account with OAuth2 (for sending acceptance/rejection emails) Google Sheets (for candidate tracking) n8n form node (for application collection) --- Customising this workflow Add more job positions to the form dropdown. Adjust the acceptance threshold (e.g., accept at 8/10 instead of 7/10). Modify email templates for a more formal or branded tone. Extend the pipeline to trigger a Calendly invite for accepted candidates. Integrate with Slack or Teams to notify HR when a candidate is accepted. ---
By Rakin JakariaAutomate Gmail tasks with Gemini AI assistant and contact management
--- Use cases are many: Automate Gmail tasks such as sending, replying, labeling, deleting, and fetching emails — all with AI assistance. Perfect for YouTubers managing viewer emails, sales teams handling inquiries, freelancers responding to client requests, or professionals keeping their inbox organized. --- Good to know At time of writing, each Gemini request is billed per token. See Gemini Pricing for updated details. The workflow uses Gmail labels (e.g., youtube-viewers, sales-inquiry, meeting-request, potential-clients, collaboration-requests) for classification — make sure these exist in your Gmail account. --- How it works Chat Trigger: You interact with the agent via a chat interface (webhook). AI Agent: Gemini-powered assistant interprets your instructions (send, reply, label, delete, fetch emails). Email Actions: Based on your request, the assistant uses Gmail tools to act on emails (Send, Reply, Label, Delete, Get Many). Contact Lookup: If only a name is provided, the agent checks Google Sheets for the matching email address. If not found, it prompts you to add it. Memory: A buffer memory stores chat context so the assistant can maintain continuity across multiple interactions. Labeling: Emails can be auto-labeled for better organization (e.g., client inquiries, meeting requests). --- How to use Send commands like: “Reply to John’s email with a follow-up about the project.” “Label Sarah’s email as potential-client.” “Delete the latest spam email.” The Gmail Agent will handle the request instantly and keep everything logged properly. --- Requirements Gmail account connected with OAuth2 credentials Google Gemini API key for AI processing Google Sheets for contact management Pre-created Gmail labels for organization --- Customising this workflow Add new Gmail labels for your workflow (e.g., Invoices, Support Tickets*). Connect to a CRM (e.g., HubSpot, Notion, or Airtable) for syncing email data. Enhance AI replies with dynamic templates stored in Google Sheets. Extend chat commands to include batch actions (e.g., “Archive all emails older than 30 days”). ---
By Rakin Jakaria