AppStoneLab Technologies LLP
Dive into the digital era with a trusted partner. From idea to execution, we transform visions into interactive realities. Let's shape the future, together.
Templates by AppStoneLab Technologies LLP
Create comprehensive research reports with Jina AI & Gemini 2.5 Flash
Automated AI Research Assistant: From Query to Polished Report with Jina & Gemini Turn a single research question into a comprehensive, multi-source report with proper citations. This workflow automates the entire research process by leveraging the web-crawling power of Jina AI and the advanced reasoning capabilities of Google's Gemini models. Simply input your query, and this AI-powered assembly line will search the web, scrape relevant sources, summarize the content, draft a structured research paper, and finally, evaluate and polish the report for accuracy and formatting. โจ Key Features ๐ Dynamic Web Search: Kicks off by searching the web with Jina AI based on your initial query. ๐ Multi-Source Content Scraping: Automatically reads and extracts content from the top 10 search results. ๐ง AI-Powered Summarization: Uses a Gemini agent to intelligently summarize each webpage, retaining the core information. โ๏ธ Automated Report Generation: A specialized "Generator Agent" synthesizes the summarized data into a structured research paper, complete with an executive summary, introduction, discussion, and conclusion. โ Citation & Quality Verification: A final "Evaluator Agent" meticulously checks the generated report for citation accuracy, logical flow, and markdown formatting, delivering a polished final document. ๐Rate-Limit Ready: Includes a configurable Wait node to ensure stable execution when dealing with multiple API calls. ๐ What This Workflow Does This workflow is designed to be your personal research assistant. It addresses the time-consuming process of gathering, reading, and synthesizing information from multiple online sources. Instead of spending hours manually searching, reading, and citing, you can delegate the entire task to this workflow and receive a well-structured and cited report as the final output. It's perfect for students, researchers, content creators, and analysts who need to quickly compile information on any given topic. โ๏ธ How It Works (Step-by-Step) Initiate with a Query: The workflow starts when you send your research question or topic to the Chat Trigger node. Search the Web: The user's query is passed to the Jina AI node, which performs a web search and returns the top 10 most relevant URLs. Scrape, Summarize, Repeat: The workflow then loops through each URL: Read Content: The Jina AI node scrapes the full text content from the URL. Summarize: A Summarizer Agent powered by Google Gemini reads the scraped content and the original user query, then generates a concise summary. Wait: A one-second pause helps to avoid hitting API rate limits before processing the next URL. Aggregate the Knowledge: Once the loop is complete, a Code node gathers all 10 individual summaries into a single, neatly structured list. Draft the Research Report: This aggregated data is fed to the Generator Agent. Following a detailed prompt, this Gemini-powered agent writes a full research report, structuring it with headings and adding inline citations for every piece of information it uses. Evaluate and Finalize: The generated draft is passed to the final Evaluator Chain. This agent acts as a quality control supervisor. It verifies that all claims are correctly cited, refines the content for clarity and academic tone, and polishes the markdown formatting to produce the final, ready-to-use report. ๐ How to Use This Workflow Credentials: Click on Use template, then configure your credentials for the following nodes: Jina AI: You will need a Jina AI API key for the Search web and Read URL content nodes. Get your key from here: JinaAI API Key Google Gemini: You will need a Google Gemini API key for the Summarizer Model, Generator Model, and Evaluator Model nodes. Get your key from here: Gemini API Key Activate Workflow: Make sure the workflow is active in your n8n instance. Start Research: Send a chat message with your research topic to the webhook URL provided in the When chat message received node. Get Your Report: Check the output of the final node, Evaluator Chain, to find your completed and polished research report. Nodes Used Chat Trigger Jina AI Code (Python) Split in Batches (Looping) Wait AI Agent Basic LLM Chain Google Gemini Chat Model
Festival social media automation with Gemini AI for X/Twitter & Facebook
๐ Festival Social Media Automation with Gemini AI for X/Twitter & Facebook Transform your festival marketing with this comprehensive automation workflow that creates and posts culturally authentic social media content across multiple platforms daily. โ๏ธ What this workflow does This workflow automatically: Fetches festival data from Google Sheets based on today's date Generates AI-powered prompts for both image creation and social media content Creates stunning festival images using Google Gemini 2.0 Flash Preview Produces platform-specific content optimized for X (Twitter) and Facebook Posts automatically with proper image attachments and error handling โจ Key Features ๐ฏ Intelligent Content Generation AI-powered prompt generation tailored to each festival's cultural context Platform-specific content optimization (character limits, hashtag strategies) Culturally sensitive and authentic messaging ๐จ Visual Content Creation Automated image generation using Google Gemini 2.0 Flash Preview Festival-themed graphics with vibrant, culturally appropriate designs Optimized for social media engagement ๐ฒ Multi-Platform Publishing Simultaneous posting to X (Twitter) and Facebook Platform-specific formatting and optimization Built-in error handling and backup posting methods โฐ Fully Automated Daily execution at 8:00 AM Date-based festival data retrieval Zero manual intervention required ๐ฑ Apps and Integrations Google Sheets - Festival calendar and data storage Google Gemini 2.0 Flash Preview - AI content and image generation X (Twitter) - Social media posting Facebook Graph API - Facebook page posting Schedule Trigger - Daily automation ๐ ๏ธ๐๏ธ Setup Instructions ๐ Google Sheets Configuration Create a Google Sheets document with columns: Date, Name of the Festival, Description Format dates as DD/MM/YYYY Connect your Google Sheets credential in n8n ๐ค Google Gemini API Setup Obtain a Google AI Studio API key from Google AI Studio Configure the Google Gemini credential in n8n Ensure you have access to Gemini 2.0 Flash Preview ๐๏ธX (Twitter) Credentials Setup Important: Due to X API limitations, you'll need TWO separate OAuth2 credentials: X API For Image Upload (Generic OAuth2): Create a new OAuth2 credential with these settings: Grant Type: PKCE Authorization URL: https://x.com/i/oauth2/authorize Access Token URL: https://api.x.com/2/oauth2/token Scope: media.write offline.access tweet.read users.read Note: Cannot combine media.write with tweet.write in the same credential For Tweet Posting (X OAuth2): Use the predefined X OAuth2 credential Configure with scopes: tweet.write offline.access tweet.read users.read ๐Facebook Graph API Setup Create a Facebook App and get your access token from Meta for Developers Configure the Facebook Graph API credential Update the node with your Facebook page ID ๐ฌ How to Use Populate your Google Sheets with festival data for upcoming dates Activate the workflow - it will run automatically daily at 8:00 AM Monitor the execution - check logs for successful posts or any errors Customize content by modifying the prompt generation logic if needed ๐ Workflow Components ๐ Data Flow Daily Trigger โ Get Today's Date โ Fetch Festival Data Generate AI Prompts โ Create Image & Content Process Media โ Merge Data โ Post to Platforms ๐ก๏ธ Error Handling Backup HTTP posting method for X if primary method fails Continue execution even if individual platform posting fails Comprehensive error logging for troubleshooting ๐จ Customization Options โ๏ธ Content Personalization Modify the prompt generation logic for different content styles Adjust platform-specific character limits and hashtag strategies Customize image generation prompts for different visual styles ๐ Platform Extension Add Instagram, LinkedIn, or other social media platforms Implement additional content formats (Stories, Reels, etc.) Create platform-specific posting schedules ๐ Data Sources Connect to different data sources (Airtable, Notion, CMS) Add support for multiple festival categories Implement content approval workflows ๐ก Best Practices ๐ Content Quality Regularly review and update your festival database Monitor AI-generated content for cultural sensitivity Test different prompt styles for optimal engagement ๐ API Management Monitor API usage limits for all connected services Implement rate limiting for high-volume posting Set up alerts for credential expiration โฐ Scheduling Consider time zones for optimal posting times Implement staggered posting across platforms Add weekend/holiday scheduling logic ๐ง Troubleshooting โ ๏ธ Common Issues Image upload fails: Check OAuth2 credentials and API limits Content generation errors: Verify Gemini API key and model availability Date matching issues: Ensure date format consistency in Google Sheets โก๏ธ Performance Tips Optimize image generation prompts for faster processing Use structured output parsing for consistent results Implement content caching for repeated festivals ๐ฏ Use Cases Cultural Organizations - Automate festival announcements and celebrations Event Management Companies - Scale social media presence across multiple events Tourism Boards - Promote local festivals and cultural events Marketing Agencies - Manage multiple client festival campaigns Community Organizations - Engage audiences with regular cultural content โญ๏ธ Benefits Time Savings - Eliminate manual social media posting Consistency - Maintain regular posting schedule Cultural Authenticity - AI-generated content respects cultural context Multi-Platform Reach - Simultaneous posting increases visibility Scalability - Handle unlimited festivals with zero additional effort This workflow transforms festival marketing from a time-consuming manual process into a fully automated, culturally intelligent system that engages audiences across multiple platforms while maintaining authenticity and relevance.
Automate WooCommerce customer support with Gemini & GPT via Telegram & Gmail
๐ค AI Support Bot for WooCommerce with Gemini & GPT (Telegram & Gmail) Managing customer support across multiple platforms like email and chat can be a huge time sink. Answering the same questions about order status repeatedly takes your focus away from growing your business. This workflow solves that problem by deploying a 24/7 conversational AI agent to act as your first line of support for your WooCommerce store. This AI-powered bot can handle customer inquiries from both Telegram and Gmail, understand conversational follow-ups, and use a tool to fetch live order data directly from your WooCommerce store. It's designed to be reliable, with a primary/fallback AI model setup, and robust enough to prevent the common pitfalls of email automation like infinite reply loops. How It Works โ๏ธ The workflow operates in a clear, logical sequence: ๐ข Multi-Channel Ingestion: The workflow starts when it receives a message from one of two sources: Telegram: An instant webhook trigger fires for every new message. Gmail: A polling trigger checks your inbox every minute for new, unread emails. ๐ Data Normalization: All incoming requests are merged and processed by a Set node. This crucial step transforms the platform-specific data into a universal format that the rest of the workflow can understand (e.g., platform, senderid, querytext). ๐ง AI Processing: The standardized query is sent to a LangChain Agent. This agent is the "brain" of the operation. It uses Conversational Memory to understand the context of the conversation (like when a user provides an order ID in a follow-up message). ๐ ๏ธ Tool Usage: Based on its prompt, the AI Agent determines if it has enough information to use its one available tool: Get an order in WooCommerce. If a valid Order ID is present, it calls the tool to fetch live order details. ๐ฎ Response & Routing: The agent formulates a natural language response. A Switch node then inspects the platform field and routes the response to the correct channel. โ Cleanup: For the Gmail path, two final actions occur in parallel: the reply is sent, and the original incoming email is marked as 'Read'. This is a critical step to prevent the workflow from re-triggering on the same email in an infinite loop. Nodes Used ๐ This workflow uses a combination of standard nodes and AI nodes to achieve its goal: Telegram Trigger: To receive messages from Telegram in real-time. Gmail Trigger: To poll for new unread emails. Merge: To combine inputs from multiple triggers. Set: To normalize data into a consistent format. LangChain Agent: The core AI "brain" that orchestrates the logic, memory, and tools. Google Gemini & OpenAI: Used as the primary and fallback language models for the agent. WooCommerce Tool: The tool the AI agent uses to fetch order data. Switch: To route the final reply to the correct platform. Telegram: To send the final response to Telegram. Gmail: To reply to emails and mark them as read. Prerequisites ๐ To use this workflow, you will need: An active n8n instance (self-hosted or cloud). A Telegram Bot account and its API token. A Gmail account with OAuth2 credentials configured in n8n. A WooCommerce store with API credentials (Consumer Key and Secret). An OpenAI API key. A Google AI (Gemini) API key. Usage ๐ Follow these steps to set up the workflow: Download the Workflow: Import the workflow JSON file into your n8n instance. Configure Credentials: Telegram: Select your Telegram API credentials in the Fetch user query and Send Telegram Response nodes. Gmail: Select your Gmail OAuth2 credentials in the Fetch support mail, Send Response via Mail, and Mark received mail as read nodes. WooCommerce: Select your WooCommerce API credentials in the Get an order in WooCommerce node. AI Models: Select your OpenAI and Google AI credentials in the Fallback Model and Primary Model nodes, respectively. Activate Telegram Webhook: Open the Fetch user query (Telegram Trigger) node. Copy the Webhook URL. Register this URL with your Telegram bot using the /setWebhook command in the BotFather chat. Customize AI Prompt (Optional): Open the WooCommerce Customer support Agent1 node. You can edit the prompt in the Text field to change the AI's personality, rules, or language. Activate the Workflow: Save the workflow and toggle the "Active" switch ON. Your multi-channel AI support agent is now live\! Send a message to your Telegram bot or a new, unread email to your connected Gmail account to test it out. Resources ๐ n8n Documentation n8n Community Forum LangChain in n8n