AI Workflows
Artificial Intelligence tools and workflows
Automate Text-Based Image Creation with DummyJSON API
Effortlessly generate custom text-based images using the DummyJSON API and n8n's HTTP Request node. Ideal for marketers and content creators looking to automate image creation without design tools.
n8n$3.99Extract and Structure Hair Documents to Google Sheets using Typhoon OCR and Llama 3.1
 **Note:** This template requires a community node and works **only on self-hosted** n8n installations. It uses the Typhoon OCR Python package and custom command execution. Make sure to install required dependencies locally. --- ## Who is this for? This template is for developers, operations teams, and automation builders in Thailand (or any Thai-speaking environment) who regularly process PDFs or scanned documents in Thai and want to extract structured text into a Google Sheet. ### It is ideal for: * Local government document processing * Thai-language enterprise paperwork * AI automation pipelines requiring Thai OCR --- ## What problem does this solve? Typhoon OCR is one of the most accurate OCR tools for Thai text. However, integrating it into an end-to-end workflow usually requires manual scripting and data wrangling. ### This template solves that by: * Running Typhoon OCR on PDF files * Using AI to extract structured data fields * Automatically storing results in Google Sheets --- ## What this workflow does 1. **Trigger**: Run manually or from any automation source 2. **Read Files**: Load local PDF files from a `doc/` folder 3. **Execute Command**: Run Typhoon OCR on each file using a Python command 4. **LLM Extraction**: Send the OCR markdown to an AI model (e.g., GPT-4 or OpenRouter) to extract fields 5. **Code Node**: Parse the LLM output as JSON 6. **Google Sheets**: Append structured data into a spreadsheet --- ## Setup ### 1. **Install Requirements** * Python 3.10+ * `typhoon-ocr`: `pip install typhoon-ocr` * Install [Poppler](https://github.com/oschwartz10612/poppler-windows/releases/) and add to system PATH (needed for `pdftoppm`, `pdfinfo`) ### 2. **Create folders** * Create a folder called `doc` in the same directory where n8n runs (or mount it via Docker) ### 3. **Google Sheet** Create a Google Sheet with the following column headers: | book_id | date | subject | detail | signed_by | signed_by2 | contact | download_url | | -------- | ---- | ------- | ------ | ---------- | ----------- | ------- | ------------- | You can use this [example Google Sheet](https://docs.google.com/spreadsheets/d/1h70cJyLj5i2j0Ag5kqp93ccZjjhJnqpLmz-ee5r4brU) as a reference. ### 4. **API Key** Export your `TYPHOON_OCR_API_KEY` and `OPENAI_API_KEY` in your environment (or set inside the command string in `Execute Command` node). --- ## How to customize this workflow * Replace the LLM provider in the `Basic LLM Chain` node (currently supports OpenRouter) * Change output fields to match your data structure (adjust the prompt and Google Sheet headers) * Add trigger nodes (e.g., Dropbox Upload, Webhook) to automate input --- ## About Typhoon OCR [Typhoon](https://docs.opentyphoon.ai/en/) is a multilingual LLM and toolkit optimized for Thai NLP. It includes `typhoon-ocr`, a Python OCR library designed for Thai-centric documents. It is open-source, highly accurate, and works well in automation pipelines. Perfect for government paperwork, PDF reports, and multilingual documents in Southeast Asia. ---
n8n$4.99Enable AI-Powered Conversational Access to Supabase/PostgreSQL Databases
This workflow allows users to interact with a Supabase/PostgreSQL database using an AI agent, facilitating dynamic SQL query generation and data analysis without manual SQL scripting.
n8n$9.99Automate TikTok Video Transcription with RapidAPI and Google Sheets
# TikTok Transcript Generator ## Overview This automated workflow extracts transcripts from TikTok videos by reading video URLs from a Google Sheet, calling the **API via [TikTok Transcript Generator](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**, cleaning the subtitle data, and updating the sheet with transcripts. It efficiently handles batches, errors, and rate limits to provide a seamless transcription process. ## Key Features - **Batch processing:** Reads and processes multiple TikTok video URLs from Google Sheets. - **Automatic transcript generation:** Uses the **[TikTok Transcript Generator API on RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**. - **Clean subtitle output:** Removes timestamps and headers for clear transcripts. - **Error handling:** Marks videos with no available transcript. - **Rate limiting:** Implements wait times to avoid API throttling on **[RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**. - **Seamless Google Sheets integration:** Updates the same sheet with transcript results and statuses. ## API Used - **[TikTok Transcript Generator API](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)** ## Google Sheet Columns | Column Name | Description | |----------------|-----------------------------------------------| | Video Url | URL of the TikTok video to transcribe | | Transcript | Generated transcript text (updated by workflow) | | Generated Date | Date when the transcript was generated (YYYY-MM-DD) | ## Workflow Nodes Explanation | Node Name | Type | Purpose | |-------------------------|-----------------------|-----------------------------------------------------------------------| | When clicking “Execute workflow” | Manual Trigger | Manually starts the entire transcription workflow. | | Google Sheets2 | Google Sheets (Read) | Reads TikTok video URLs and transcript data from Google Sheets. | | Loop Over Items | Split In Batches | Processes rows in smaller batches to control execution speed. | | If | Conditional Check | Filters videos needing transcription (URL present, transcript empty). | | HTTP Request | HTTP Request | Calls the **TikTok Transcript Generator API on [RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)** to fetch transcripts. | | If1 | Conditional Check | Checks for valid API responses (handles 404 errors). | | Code | Code (JavaScript) | Cleans and formats raw subtitle text by removing timestamps. | | Google Sheets | Google Sheets (Update)| Updates the sheet with cleaned transcripts and generation dates. | | Google Sheets1 | Google Sheets (Update)| Updates sheet with “No transcription available” message on error. | | Wait | Wait | Adds delay between batches to avoid API rate limits on **[RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**. | ## Challenges Resolved - **Manual Transcription Effort:** Eliminates the need to manually transcribe TikTok videos, saving time and reducing errors. - **API Rate Limits:** Introduces batching and wait periods to avoid exceeding API usage limits on **[RapidAPI](https://rapidapi.com/PrineshPatel/api/tiktok-transcript-generator)**, ensuring smooth execution. - **Incomplete or Missing Data:** Filters out videos already transcribed and handles missing transcripts gracefully by logging appropriate messages. - **Data Formatting Issues:** Cleans raw subtitle data to provide readable, timestamp-free transcripts. - **Data Synchronization:** Updates transcripts back into the same Google Sheet row, maintaining data consistency and ease of access. ## Use Cases - Content creators wanting to transcribe TikTok videos automatically. - Social media analysts extracting text data for research. - Automation enthusiasts integrating transcript generation into workflows. ## How to Use 1. Prepare a Google Sheet with the columns: **Video Url**, **Transcript**, and **Generated Date**. 2. Connect your Google Sheets account in the workflow. 3. Enter your **RapidAPI** key for the TikTok Transcript Generator API. 4. Execute the workflow to generate transcripts. 5. View transcripts and generated dates directly in your Google Sheet. --- **Try this workflow to automate your TikTok video transcriptions efficiently!** Create your **free n8n account** and set up the workflow in just a few minutes using the link below: ☀️🌟 [Start Automating with n8n](https://n8n.partnerlinks.io/7fuarh1e6dz5) Save time, stay consistent, and grow your LinkedIn presence effortlessly!
n8n$14.99Automate YouTube Video Summaries and Key Lesson Extraction to Google Docs
This workflow automatically extracts transcripts from YouTube videos, summarizes them using AI, and saves the key lessons and interesting facts to a Google Doc. Ideal for learners and professionals who need quick insights from video content.
n8n$9.99Generate Personalized Cold Outreach Icebreakers with GPT-4 and Google Sheets
## Automated Personalized Email Icebreakers This workflow automates creating personalized email icebreakers. It reads leads from a Google Sheet, scrapes their company website, uses OpenAI to analyze the data and craft a unique opening line, and then saves that icebreaker back into the original sheet. ## How It Works - **Fetch Lead**: The workflow starts, loops through your leads, and pulls one from your Google Sheet. - **Scrape & Summarize**: It scrapes the lead's company website and uses a fast OpenAI model to summarize the key points about the company and the person. - **Generate Icebreaker**: This summary is then sent to a more powerful OpenAI model, which follows specific instructions to write a short, personalized icebreaker. - **Update Sheet**: The new icebreaker is saved back into the correct lead's row in your Google Sheet, using their email to match the record. --- ## Requirements - An n8n instance. - An OpenAI API key with available credits. - A Google account with a Sheet for your leads. - The Google Sheet must have columns for lead data (e.g., `Email`, `Website`, `Company Name`) and an empty column named `icebreaker`. - The `Email` column must be unique for each lead. --- ## Setup Instructions 1. **Add Credentials**: In n8n, add your OpenAI API key and connect your Google account via the **Credentials** menu. 2. **Configure Google Sheets Nodes**: Select each of the two Google Sheets nodes (`Client data` and `Add icebreaker to sheet`). In each, choose your credential, select your spreadsheet and the specific sheet name, and ensure the column mapping is correct. 3. **Configure OpenAI Nodes**: Select both OpenAI nodes (`Summarizing prospect data` and `Creating icebreaker`) and choose your OpenAI credential from the dropdown. 4. **Verify Update Node**: On the final `Add icebreaker to sheet` node, ensure the **Operation** is set to `Append Or Update` and the **Matching Columns** field is set to `Email`. --- ## Customization Options - **Trigger**: Change the manual start to an automatic trigger, like when a new row is added to the sheet or on a daily schedule (Cron). - **AI Prompt**: Modify the prompt in the Creating icebreaker node to change the tone, style, or length of the output. - **AI Model**: Experiment with different OpenAI models (like `gpt-4`) for a different balance of cost, speed, and quality. - **Data Source**: Replace Google Sheets with a CRM like HubSpot or a database like Postgres.
n8n$9.99Automate Appointment Qualification and Scheduling with AI and n8n Forms
Streamline your appointment scheduling process by using AI to qualify requests and automate scheduling with n8n forms. This workflow ensures that only relevant inquiries are scheduled, saving time and resources.
n8n$14.99Automate LinkedIn Profile Discovery and Cold Email Outreach
Streamline your LinkedIn profile searches and cold email outreach by automating the process with n8n, OpenAI, and Hunter. This workflow saves time by generating contact details and context from LinkedIn profiles, allowing for efficient communication with potential candidates or clients.
n8n$14.99AI-Powered Automated Job Search & Application
**Unleash the power of AI to automate your job search, tailor your applications, and boost your chances of landing your dream job!** This comprehensive workflow handles everything from finding relevant job postings to generating personalized resumes and cover letters. **Use cases are many:** * **Automate your entire job application process:** Spend less time searching and more time preparing for interviews. * **Tailor your resume and cover letter for every application:** Maximize your ATS compatibility and stand out to recruiters. * **Efficiently track your applications:** Keep all your job search activities organized in one place. * **Discover new job opportunities:** Leverage the Adzuna API to find relevant listings. --- **Good to know:** * **Free Adzuna API:** This workflow utilizes the free Adzuna API, making job search capabilities accessible without initial cost. * **OpenRouter Chat Model Costs:** AI model usage (for resume rewriting and cover letter generation) will incur costs based on the OpenRouter pricing model. Please check OpenRouter's official website for updated pricing information. * **Model Availability:** The AI models used may have geo-restrictions. If you encounter a model not found error, it might not be available in your country or region. --- **How it works:** 1. **Webhook Trigger:** The workflow is initiated via a webhook, allowing you to trigger it manually or integrate it with other systems (e.g., a form submission with your desired job title and resume). 2. **Resume Extraction:** Your uploaded resume (e.g., PDF) is automatically extracted into a readable text format. 3. **Job Search (Adzuna API):** Using the provided job title, the workflow queries the Adzuna API to fetch relevant job postings. 4. **Job Filtering:** Duplicate job listings are filtered out to ensure you receive unique opportunities. 5. **Job Info Extraction:** Key details like job description, company name, and job URL are extracted from each posting. 6. **Skills Extraction (AI):** An AI model (OpenRouter) analyzes the job description to identify the top skills and qualifications required. 7. **Resume Match Scoring (AI):** Your resume is compared against the extracted job skills by an AI model, generating a compatibility score (1-5). 8. **Conditional Resume & Cover Letter Generation:** If the resume match score is satisfactory (≥ 3): * **Tailored Resume Generation (AI):** An AI model rewrites your resume, specifically highlighting the skills and experience most relevant to the target job, in an ATS-friendly and human-readable JSON/HTML format. * **Personalized Cover Letter Generation (AI):** A custom cover letter is drafted by AI, uniquely tailored to the job description and your newly optimized resume, generated as well-formatted HTML. 9. **Google Sheets Integration:** The generated cover letter, tailored resume, job URL, and application status are automatically updated in your designated Google Sheet for easy tracking. 10. **Gmail Notification:** A personalized email containing the generated cover letter, tailored resume, and a direct link to the job posting on Adzuna is sent to your specified email address. 11. **Webhook Response:** A final text response is sent back via the webhook, summarizing the sent application materials. --- **How to use:** * **Manual Trigger:** The workflow is set up with a manual trigger (Webhook) for initial testing and demonstration. You can easily replace this with an n8n form, a scheduled trigger, or integrate it into your existing tools. * **Input:** Provide your desired job search keyword and your resume (e.g., as a PDF) to the webhook. * **Review & Apply:** Review the AI-generated cover letter and tailored resume sent to your email, then proceed to apply for the job using the provided Adzuna link. --- **Requirements:** * **n8n Instance:** A running n8n instance (self-hosted or cloud). * **Adzuna API Key:** A free Adzuna API key (easily obtainable from their developer portal). * **OpenRouter Account:** For AI model access (costs apply based on usage). * **Google Sheets Account:** To store and track your job applications. * **Gmail Account:** To send automated application emails. --- **Customizing this workflow:** This workflow is highly customizable. You can: * Integrate with other job boards (e.g., LinkedIn, Indeed) using their APIs. * Add more sophisticated AI models or custom prompts for even finer control over resume and cover letter generation. * Connect to other services for CRM, calendar management, or applicant tracking. * Implement different filtering criteria for job postings. * Expand the data stored in your Google Sheet (e.g., interview dates, feedback). Start automating your job search today and streamline your path to career success!
n8n$14.99Automate SEO-Optimized Blog Creation with AI and Vector Databases
This workflow automates the creation of SEO-optimized blog content using n8n, Scrapeless, and Pinecone. It leverages Retrieval-Augmented Generation (RAG) to gather and analyze high-performing content, storing it in a vector database for generating new blog posts.
n8n$14.99Automate Knowledge Base Updates with Notion and Supabase Vector Store
This workflow automates the process of updating a knowledge base by monitoring Notion pages for changes and upserting document embeddings into a Supabase vector store. It enables real-time question and answer capabilities on updated content.
n8n$24.99Automate Google AI Overview Extraction and SEO Analysis with n8n
Streamline the extraction of AI Overviews from Google Search and automate SEO recommendations using n8n. This workflow integrates with Google Sheets to store data and utilizes AI to generate actionable SEO guidelines.
n8n$14.99Automate Post-Meeting Tasks Using AI and Transcripts
This n8n workflow automates the organization of follow-up meetings by analyzing video transcripts with AI. It saves time by summarizing meetings and scheduling necessary follow-ups.
n8n$14.99Automate Stock News Monitoring and Alerts with Google RSS, OpenRouter, and Telegram
This workflow automates the process of monitoring stock-related news, extracting and summarizing content, and sending real-time alerts to Telegram while logging details in Google Sheets.
n8n$14.99Context-Aware Document Processing from Google Drive to Pinecone
This n8n workflow automates the extraction, processing, and storage of document content from Google Drive into Pinecone using context-based chunking. It enhances retrieval accuracy for RAG setups by ensuring each chunk retains meaningful context.
n8n$14.99Automate Sentiment Analysis for Product Reviews with Google Sheets and OpenAI
Automatically analyze and classify product reviews by sentiment using Google Sheets and OpenAI, streamlining feedback management and enhancing customer insights.
n8n$4.99Automate Image Creation and Editing with OpenAI's GPT-Image-1
Leverage OpenAI's GPT-Image-1 model to automate the generation and editing of images based on custom prompts. Ideal for creative workflows in marketing, design, and product visualization.
n8n$9.99Automated Document Q&A System with OpenAI, Pinecone, and Google Drive
This workflow automates the creation of a document-based Q&A system using OpenAI for embeddings, Pinecone for vector storage, and Google Drive for document retrieval. It supports natural language queries on stored documents.
n8n$14.99Automate SEO Article Creation and Publishing to WordPress with GPT-4 and PostgreSQL
This workflow automates the generation and publication of SEO-optimized articles on WordPress using GPT-4 and PostgreSQL for category management. It selects the least-used category, generates content, creates a placeholder image, and publishes the post with the correct category and featured image.
n8n$24.99Automated Document Analysis and Chatbot Integration via n8n
This workflow automates the process of analyzing uploaded documents and provides users with insights and a chatbot link via email. It utilizes Llama Cloud API, Google Gemini LLM, Pinecone vector database, and Gmail for a comprehensive content analysis experience.
n8n$24.99Automate Vintage Image Restoration with n8n and Gemini AI
Leverage n8n and Gemini AI to automate the restoration of vintage images by removing damage and filling in missing sections.
n8n$14.99Evaluation Metric Example: RAG Document Relevance
## AI evaluation in n8n This is a template for n8n's [evaluation feature](https://docs.n8n.io/advanced-ai/evaluations/overview). Evaluation is a technique for getting confidence that your AI workflow performs reliably, by running a test dataset containing different inputs through the workflow. By calculating a metric (score) for each input, you can see where the workflow is performing well and where it isn't. ## How it works This template shows how to calculate a workflow evaluation metric: **retrieved document relevance** (i.e., whether the information retrieved from a vector store is relevant to the question). The workflow takes a question and checks whether the information retrieved to answer it is relevant. To run this workflow, you need to insert documents into a vector data store, so that they can be retrieved by the agent to answer questions. You can do this by running the top part of the workflow once. The main workflow works as follows: - We use an evaluation trigger to read in our dataset. - It is wired up in parallel with the regular trigger so that the workflow can be started from either one. [More info](https://docs.n8n.io/advanced-ai/evaluations/tips-and-common-issues/#combining-multiple-triggers). - We make sure that the agent outputs the list data from the tools that it used. - If we're evaluating (i.e., the execution started from the evaluation trigger), we calculate the relevance metric using AI to compare the retrieved documents with the question. - We pass this information back to n8n as a metric. - If we're not evaluating, we avoid calculating the metric, to reduce cost.
n8n$14.99Automate Release Notes Generation and Distribution with GitHub, JIRA, and Google Gemini
Streamline your software release process by automatically generating and emailing professional release notes using GitHub, JIRA, and Google Gemini.
n8n$14.99Automate Passport Photo Validation Using AI Vision
This n8n workflow automates the validation of passport photos using AI vision models, ensuring compliance with UK government standards. It streamlines the process by leveraging multimodal LLMs to handle complex image validation tasks efficiently.
n8n$9.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work