Agents & Automations

Automatically generate engaging LinkedIn posts by extracting data from Google Sheets, processing it with Perplexity AI and ChatGPT, and posting directly to LinkedIn.

How it works This workflow automates the transformation of standard product images into professional product photography featuring human models. It uses AI to analyze product images, create tailored photography prompts, and generate high-quality enhanced versions. Set up steps You'll need an OpenAI API key and access to gpt-image-1 (verify your organization). Set up a Google Sheets spreadsheet with columns: Image-URL, Prompt, Output. Create a Google Drive folder to store the generated images. Requirements - OpenAI API access (for image generation and analysis) - Google Sheets and Google Drive accounts - Basic product images (URLs) as input The spreadsheet must contain a column named Image-URL with links to the product images. This workflow automatically: - Reads product image URLs from your Google Sheet - Downloads the images for processing - Analyzes each image to understand what product it contains - Creates specialized photography prompts ensuring each product is shown with a human model - Generates professional product photography using OpenAI's image generation capabilities - Uploads results to Google Drive and updates your spreadsheet with links Extra You can also use the included simple image generation workflow to directly create images via prompt without product image input. This option lets you quickly generate images through the OpenAI API using just text prompts.

Siri Power Up Mode The "Siri Power Up Mode" n8n workflow blueprint enables users to activate custom AI-driven automations through Siri voice commands by integrating Apple Shortcuts with n8n workflows. This setup allows Siri to capture user input and send it to n8n, where an AI agent processes the request and performs actions such as generating responses, updating applications, or triggering other workflows.

Workflow Description: Automated Content Publishing for WordPress This n8n workflow automates the entire process of content generation, image selection, and scheduled publishing to a self-hosted WordPress website. It is designed for bloggers, marketers, and businesses who want to streamline their content creation and posting workflow. 🌟 Features ✅ AI-Powered Content Generation Uses ChatGPT to generate engaging, market-ready blog articles. Dynamically incorporates high-search volume keywords. ✅ Automated Image Selection Searches for relevant stock images from Pexels. Embeds images directly into posts. (Optional) Supports Featured Image from URL (FIFU) plugin for WordPress. ✅ Scheduled & Randomized Posting Automatically schedules posts at predefined intervals. Supports randomized delay (0-6 hours) for natural publishing. ✅ WordPress API Integration Uses WordPress REST API to directly publish posts. Configures featured images, categories, and metadata. Supports SEO-friendly meta fields. ✅ Flexible & Customizable Works with any WordPress website (self-hosted). Can be modified for other CMS platforms. 🔧 How It Works 1️⃣ Trigger & Scheduling Automatically runs at preset times or on-demand. Supports cron-like scheduling. 2️⃣ AI Content Generation Uses a well-crafted prompt to generate high-quality blog posts. Extracts relevant keywords for both SEO and image selection. 3️⃣ Image Fetching from Pexels Searches and retrieves high-quality images. Embeds image credits and ensures proper formatting. 4️⃣ WordPress API Integration Sends post title, content, image, and metadata via HTTP Request. Can include custom fields, categories, and tags. 5️⃣ Randomized Delay Before Publishing Ensures natural posting behavior. Avoids bulk publishing issues. 📌 Requirements Self-hosted WordPress website with REST API enabled. FIFU Plugin (optional) for external featured images. n8n Self-Hosted or Cloud Instance. 🚀 Who Is This For? ✅ Bloggers who want to automate content publishing. ✅ Marketing teams looking to scale content production. ✅ Business owners who want to boost online presence. ✅ SEO professionals who need consistent, optimized content. 💡 Ready to Automate? 👉 Click here to get this workflow! (Replace with Purchase URL)

This workflow shows how you can get your OpenAI assistant to call an n8n workflow as a tool. Since you can put almost any functionality in an n8n workflow, this means you can give your assistant access to almost any data source. Note that to use this template, you need to be on n8n version 1.19.4 or later.

Workflow Overview This workflow automates the creation and management of a custom OpenAI Assistant for a travel agency ("Travel with us"), leveraging Google Drive for document storage. How It Works 1. Create the OpenAI Assistant - Node: OpenAI - Action: Creates a custom assistant named "Travel with us" Assistant using the gpt-4o-mini model. - Instructions: Respond only using the provided document (e.g., agency-specific info). Stay friendly, brief, and focused on travel-related queries. Ignore irrelevant questions politely. - Credentials: Requires OpenAI API key. 2. Upload Agency Document - Google Drive Node: - Action: Downloads a Google Doc as a PDF. - OpenAI2 Node: - Action: Uploads the PDF to OpenAI with purpose: "assistants". - Output: Generates a file_id. 3. Update the Assistant with the Document - OpenAI Node: - Action: Updates the assistant to include the uploaded file. 4. Chat Interaction - Chat Trigger: - Activates when a message is received ("When chat message received"). - OpenAI Assistant Node: - Action: Uses the updated assistant to respond to user queries. - Memory: Window Buffer Memory retains chat context for coherent conversations. Set Up Steps - Prepare the Document: Store your travel agency guide in Google Drive (e.g., as a Google Doc). Update the Google Drive node with your document’s ID. - Configure Credentials: - Google Drive: Connect via OAuth2 (googleDriveOAuth2Api). - OpenAI: Add your API key to all OpenAI nodes. - Customize the Assistant: Modify the instructions in the OpenAI node to reflect your agency’s needs. Ensure the document includes FAQs, policies, and travel info. - Test the Workflow: Trigger manually ("Test workflow") to create the assistant and upload the file. Send a chat message (e.g., "What are your travel packages?") to test responses. Dependencies - Google Drive Account: To store and retrieve the agency document. - OpenAI API Access: For assistant creation and file uploads.

This n8n workflow demonstrates how to automate image captioning tasks using Gemini 1.5 Pro - a multimodal LLM which can accept and analyse images. This is a really simple example of how easy it is to build and leverage powerful AI models in your repetitive tasks. How it works For this demo, we'll import a public image from a popular stock photography website, Pexel.com, into our workflow using the HTTP request node. With multimodal LLMs, there is little to preprocess other than ensuring the image dimensions fit within the LLM's accepted limits. Though not essential, we'll resize the image using the Edit image node to achieve fast processing. The image is used as an input to the basic LLM node by defining a "user message" entry with the binary (data) type. The LLM node has the Gemini 1.5 Pro language model attached, and we'll prompt it to generate a caption title and text appropriate for the image it sees. Once generated, the generated caption text is positioned over the original image to complete the task. We can calculate the positioning relative to the number of characters produced using the code node. An example of the combined image and caption can be found here: https://res.cloudinary.com/daglih2g8/image/upload/f_auto,q_auto/v1/n8n-workflows/l5xbb4ze4wyxwwefqmncRequirements - Google Gemini API Key - Access to Google Drive Customising the workflow Not using Google Gemini? n8n's basic LLM node supports the standard syntax for image content for models that support it - try using GPT4o, Claude, or LLava (via Ollama). Google Drive is only used for demonstration purposes. Feel free to swap this out for other triggers such as webhooks to fit your use case.

Automated Financial Tracker: Telegram Invoices to Notion with AI Summaries & Reports Tired of manually logging every expense? Streamline your financial tracking with this powerful n8n workflow! Snap a photo of your invoice in Telegram, and let AI (powered by Google Gemini) automatically extract the details, record them in your Notion database, and even send you a quick summary. Plus, get scheduled weekly reports with charts to visualize your spending. Automate your finances, save time, and gain better insights with this easy-to-use template! Transform your expense tracking from a chore into an automated breeze. Try it out! Overview: This workflow revolutionizes how you track your finances by automating the entire process from invoice capture to reporting. Simply send a photo of an invoice or receipt to a designated Telegram chat, and this workflow will: - Extract Data with AI: Utilize Google Gemini's capabilities to perform OCR on the image, understand the content, and extract key details like item name, quantity, price, total, date, and even attempt to categorize the expense. - Store in Notion: Automatically log each extracted transaction into a structured Notion database. - Instant Feedback: Send a summary of the processed transaction back to your Telegram chat. - Scheduled Reporting: Generate and send a visual summary of your expenses (e.g., weekly spending by category) as a chart to your preferred Telegram chat or group. This workflow is perfect for individuals, freelancers, or small teams looking to effortlessly manage their expenses without manual data entry. Key Features & Benefits: - Effortless Expense Logging: Just send a picture – no more typing! - AI-Powered Data Extraction: Leverages Google Gemini for intelligent invoice processing. - Centralized Data in Notion: Keep all your financial records neatly organized in a Notion database. - Automated Categorization: AI helps in categorizing your expenses (e.g., Food & Beverage, Transportation). - Instant Summaries: Get immediate confirmation and a summary of what was recorded. - Visual Reporting: Receive scheduled charts (e.g., bar charts of spending by category) directly in Telegram. - Customizable: Easily adapt the workflow to your specific needs, categories, and reporting preferences. - Time-Saving: Drastically reduces the time spent on manual financial administration. How It Works (Workflow Breakdown): The workflow is divided into two main parts: Part 1: Real-time Invoice Processing & Logging - Telegram Trigger: Activates when a new photo is sent to the configured Telegram chat. - Get Photo Info: Retrieves the details of the received photo. - Get Image Info: Prepares the image data. - AI Data Extraction: The image data is sent to the Google Gemini Chat Model. A specific prompt instructs the AI to extract details (date, ID, name, quantity, price, total, category, tax) in a JSON array format and provide a summary message. The categories include Food & Beverage, Transportation, Utilities, Shopping, Healthcare, Entertainment, Housing, and Education. - Parse AI Output: Structures the AI's JSON output for easier handling. - Split Transactions: If an invoice contains multiple items, this node splits them into individual records. - Record to Notion: Each transaction item is added as a new page/entry in your specified Notion database. - Send Telegram Summary: The summary message generated by the AI is sent back to the original Telegram chat. Part 2: Scheduled Financial Reporting - Schedule Trigger: Runs at a predefined interval (e.g., every week) to generate reports. - Get Recent Data from Notion: Fetches transaction data from the Notion database for a specific period (e.g., the past week). - Summarize Data: Aggregates the data, for example, by summing up the 'total' amount for each 'category'. - Prepare Chart Data: Transforms the summarized data into a JSON format suitable for generating a chart (e.g., labels for categories, data for spending amounts). - Generate Chart: Uses the QuickChart node to create a visual chart (e.g., a bar chart) from the prepared data. - Send Chart to Telegram: Sends the generated chart image to a specified Telegram chat ID or group. Setup Instructions: - Credentials: - Telegram: Create a Telegram bot and get its API token. - Google Gemini (PaLM) API: You'll need an API key for Google Gemini. - Notion: Create a Notion integration and get the API key. Create a Notion database with properties corresponding to the data you want to save. - Configure Telegram Trigger: Add your Telegram Bot API token. - Configure Google Gemini Node: Select or add your Google Gemini API credentials. - Configure Notion Nodes: Select your target Notion Database ID and map the properties from the workflow. - Configure Schedule Trigger: Set your desired schedule (e.g., every Monday at 9 AM). - Test: Send an image of an invoice to your Telegram bot and check if the data appears in Notion and if you receive a summary message. Sticky Note Text for Your n8n Template: - Existing High-Level Sticky Notes: - Auto Notes Transaction with Telegram and Notion database - Schedule report to send on channel or private message - Specific Sticky Notes to Add: - On Telegram Trigger: 📸 INVOICE INPUT 📸 - Near Google Gemini: 🤖 AI MAGIC HAPPENS HERE 🧠 - On Parse To your object: ✨ STRUCTURING AI DATA ✨ - On Record To Notion Database: 📝 SAVING TO NOTION 📝 - On Sendback to chat: 💬 TRANSACTION SUMMARY 💬 - On Schedule Trigger: 🗓️ REPORTING SCHEDULE 🗓️ - On Get Recent Data from Notions: 📊 FETCHING DATA FOR REPORT 📊 - On Summarize Transaction Data: ➕ SUMMARIZING SPENDING ➕ - On Convert Data to JSON chart payload: 🎨 PREPARING CHART DATA 🎨 - On Generate Chart: 📈 GENERATING VISUAL REPORT 📈 - On Send Chart Image: 📤 SENDING REPORT TO TELEGRAM 📤 General Sticky Note: - 🔑 CREDENTIALS NEEDED 🔑 - 💡 CUSTOMIZE ME! 💡

Workflow Description This workflow is designed for sales and revenue teams using Gong and Salesforce to track and analyze sales calls. It helps automate the extraction, filtering, and preprocessing of Gong call data for further AI analysis. What problem is this solving? Sales teams often generate large amounts of call data, but not all calls are relevant for deeper analysis. This workflow filters calls based on predefined criteria, extracts relevant metadata, and formats the data before passing it to an AI processing pipeline. What this workflow does - Triggers on new Gong calls synced to Salesforce every hour. - Filters calls based on opportunity stage (Discovery or Meeting Booked). - Retrieves Gong call details via API. - Formats call data into a structured JSON object for AI processing. - Passes the structured data to a Gong Call Preprocessor workflow for further insights. Setup 1. Ensure that you have connected Salesforce and Gong APIs with valid credentials. 2. Modify the Salesforce query in Get all custom Salesforce Gong Objects to match your organization’s requirements. 3. Set the schedule trigger interval in the Run Hourly node if needed. 4. Connect this workflow to an AI processing workflow to analyze call transcripts. Workflow Templates: - CallForge - 01 - Filter Gong Calls Synced to Salesforce by Opportunity Stage - CallForge - 02 - Prep Gong Calls with Sheets & Notion for AI Summarization - CallForge - 03 - Gong Transcript Processor and Salesforce Enricher - CallForge - 04 - AI Workflow for Gong.io Sales Calls - CallForge - 05 - Gong.io Call Analysis with Azure AI & CRM Sync - CallForge - 06 - Automate Sales Insights with Gong.io, Notion & AI - CallForge - 07 - AI Marketing Data Processing with Gong & Notion - CallForge - 08 - AI Product Insights from Sales Calls with Notion How to customize - Change filtering logic: Adjust the opportunity stage filter (Check if Opportunity Stage is Meeting Booked or Discovery) to match your sales process. - Modify data formatting: Add or remove fields in the Format call into correct JSON Object node to customize the output. - Adjust trigger frequency: Change the Run Hourly node to run at a different interval if required.

Who this is for The Google Trend Data Extract & Summarization workflow is ideal for trend researchers, digital marketers, content strategists, and AI developers who want to automate the extraction, summarization, and distribution of Google Trends data. This end-to-end solution helps transform trend signals into human-readable insights and delivers them across multiple channels. It is built for: - Market Researchers - Tracking trends by topic or region - Content Strategists - Identifying content opportunities from trending data - SEO Analysts - Monitoring search volume and shifts in keyword popularity - Growth Hackers - Reacting quickly to real-time search behavior - AI & Automation Engineers - Creating automated trend monitoring systems What problem is this workflow solving? Google Trends data can provide rich insights into user interests, but the raw data is not always structured or easily interpretable at scale. Manually extracting, cleaning, and summarizing trends from multiple regions or categories is time-consuming. This workflow solves the following problems: - Automates the conversion of markdown or scraped HTML into clean textual input - Transforms unstructured data into structured format ready for processing - Uses AI summarization to generate easy-to-read insights from Google Trends - Distributes summaries via email and webhook notifications - Persists responses to disk for archiving, auditing, or future analytics What this workflow does - Receives input: Sets a URL for the data extraction and analysis. - Uses Bright Data’s Web Unlocker to extract content from relevant site. - Markdown to Textual Data Extractor: Converts markdown content into plaintext using n8n’s Function or Markdown nodes. - Structured Data Extract: Parses the plaintext into structured JSON suitable for AI processing. - Summarize Google Trends: Sends structured data to Google Gemini with a summarization prompt to extract key takeaways. - Send Summary via Gmail: Composes an email with the AI-generated summary and sends it to a designated recipient. - Persist to Disk: Writes the AI structured data to disk. - Webhook Notification: Sends the summarized response to an external system (e.g., Slack, Notion, Zapier) using a webhook. How to customize this workflow to your needs - Update Source: Update the workflow input to read from Google Sheet or Airbase etc. - Gemini Prompt Tuning: Customize prompts to extract summaries like: - Summarize the most significant trend shifts - Generate content ideas from the trending search topics - Email Personalization: Configure Gmail node to: - Use dynamic subject lines like: Weekly Google Trends Summary – {{date}} - Send to multiple stakeholders or mailing lists - File Storage Customization: Save with timestamps, e.g., trends_summary_2025-04-29.json - Extend to S3 or cloud drive integrations - Webhook Use Cases: Send summary to: - Internal dashboards - Slack channels - Automation tools like Make, Zapier etc.

Who this is for This workflow is for salespeople who want to quickly and efficiently follow up with their leads. What this workflow does This workflow starts every time a new reply is received in lemlist. It then classifies the response using OpenAI and creates the correct follow-up task. The follow-up tasks currently include: - Slack alerts for each new reply from a lead - Tagging interested leads in lemlist - Unsubscribing leads when they request it The Slack alerts include: - Lead email address - Sender email address - Reply type (positive, not interested, etc.) - A preview of the reply Setup To set this template up, simply follow the sticky steps in it. How to customize this workflow to your needs - Adjust the follow-up tasks to your needs. - Change the Slack notifications to your needs.

This n8n template takes a video and extracts frames from it, which are used with a multimodal LLM to generate a script. The script is then passed to the same multimodal LLM to generate a voiceover clip. This template was inspired by processing and narrating a video with GPT's visual capabilities and the TTS API. How it works: 1. Video is downloaded using the HTTP node. 2. A Python code node is used to extract the frames using OpenCV. 3. A loop node is used to batch the frames for the LLM to generate partial scripts. 4. All partial scripts are combined to form the full script, which is then sent to OpenAI to generate audio from it. 5. The finished voiceover clip is uploaded to Google Drive. Requirements: - OpenAI for LLM - Ideally, a mid-range (16GB RAM) machine for acceptable performance! Customizing this workflow: - For larger videos, consider splitting them into smaller clips for better performance. - Use a multimodal LLM that supports video fully, such as Google's Gemini.

This n8n workflow demonstrates a simple approach to improve chat UX by staggering an AI Agent's reply for users who send in a sequence of partial messages and in short bursts. How it works Twilio webhook receives user's messages which are recorded in a message stack powered by Redis. The execution is immediately paused for 5 seconds and then another check is done against the message stack for the latest message. The purpose of this check lets us know if the user is sending more messages or if they are waiting for a reply. The execution is aborted if the latest message on the stack differs from the incoming message and continues if they are the same. For the latter, the agent receives the buffered messages up to that point and is able to respond to them in a single reply. Requirements - A Twilio account and SMS-enabled phone number to receive messages. - Redis instance for the messages stack. - OpenAI account for the language model. Customising the workflow This workflow should work for other common messaging platforms such as WhatsApp and Telegram. Is 5 seconds too long or too short? Adjust the wait threshold to suit your customers.

About the workflow The workflow reads every reply that is received from a cold email campaign and qualifies if the lead is interested in a meeting. If the lead is interested, a deal is made in Pipedrive. You can add as many email inboxes as you need! Setup: - Add credentials to the Gmail, OpenAI, and Pipedrive Nodes. - Add an in_campaign field in Pipedrive for persons. In Pipedrive, click on your credentials at the top right, go to company settings > Data fields > Person, and click on add custom field. Single option [TRUE/FALSE]. - If you have only one email inbox, you can delete one of the Gmail nodes. - If you have more than two email inboxes, you can duplicate a Gmail node as many times as you like. Just connect it to the Get email node, and you are good to go! - In the Gmail inbox nodes, select Inbox under label names and uncheck Simplify.

Who is this for? Content creators, digital marketers, and social media managers who want to automate the creation of short-form videos for platforms like TikTok, YouTube Shorts, and Instagram Reels without extensive video editing skills. What problem does this workflow solve? Creating engaging short-form videos consistently is time-consuming and requires multiple tools and skills. This workflow automates the entire process from ideation to publishing, significantly reducing the manual effort needed while maintaining content quality. What this workflow does This all-in-one solution transforms ideas into fully produced short-form videos through a 5-step process: 1. Generate video captions from ideas stored in a Google Sheet. 2. Create AI-generated images using Flux and the OpenAI API. 3. Convert images to videos using Kling's API. 4. Add voice-overs to your content with Eleven Labs. 5. Complete the video production with Creatomate by adding templates, transitions, and combining all elements. The workflow handles everything from sourcing content ideas to rendering the final video, and even notifies you on Discord when videos are ready. Setup (Est. time: 20-30 minutes) Before getting started, you'll need: - n8n installation (tested on version 1.81.4) - OpenAI API Key (free trial credits available) - PiAPI (free trial credits available) - Eleven Labs (free account) - Creatomate API Key (free trial credits available) - Google Sheets API enabled in Google Cloud Console - Google Drive API enabled in Google Cloud Console - OAuth 2.0 Client ID and Client Secret from your Google Cloud Console Credentials How to customize this workflow to your needs - Adjust the Google Sheet structure to include additional data like video length, duration, style, etc. - Modify the prompt templates for each AI service to match your brand voice and content style. - Update the Creatomate template to reflect your visual branding. - Configure notification preferences in Discord to manage your workflow. This workflow combines multiple AI technologies to create a seamless content production pipeline, saving you hours of work per video and allowing you to focus on strategy rather than production.

n8n automation that publishes to 9 social platforms daily! This workflow uses Blotato API to publish to social platforms and Google Drive/Sheets to grab the videos you want to post.

Purpose This workflow adds the capability to build a RAG on living data. In this case, Notion is used as a Knowledge Base. Whenever a page is updated, the embeddings get upserted in a Supabase Vector Store. It can also be fairly easily adapted to PGVector, Pinecone, or Qdrant by using a custom HTTP request for the latter two. DemoHow it works A trigger checks every minute for changes in the Notion Database. The manual polling approach improves accuracy and prevents changes from being lost between cached polling intervals. Afterwards, every updated page is processed sequentially. The Vector Database is searched using the Notion Page ID stored in the metadata of each embedding. If old entries exist, they are deleted. All blocks of the Notion Database Page are retrieved and combined into a single string. The content is embedded and split into chunks if necessary. Metadata, including the Notion Page ID, is added during storage for future reference. A simple Question and Answer Chain enables users to ask questions about the embedded content through the integrated chat function. Prerequisites To set up a new Vector Store in Supabase, follow this guide. Prepare a simple Database in Notion with each Database Page containing at least a title and some content in the blocks section. You can of course also connect this to an existing Database of your choice. Setup Select your credentials in the nodes which require those. If you are on an n8n cloud plan, switch to the native Notion Trigger by activating it and deactivating the Schedule Trigger along with its subsequent Notion Node. Choose your Notion Database in the first Node related to Notion. Adjust the chunk size and overlap in the Token Splitter to your preference. Activate the workflow. How to use Populate your Notion Database with useful information and use the chat mode of this workflow to ask questions about it. Updates to a Notion Page should quickly reflect in future conversations.

Leverage the power of ChatGPT and Google Sheets to automate responses for business emails, improve workflow, save time, and enhance customer communications for better results.

Who is this for? This workflow is designed for HR professionals, employer branding teams, talent acquisition strategists, market researchers, and business intelligence analysts who want to monitor, understand, and act upon employee sentiment and company perception on Glassdoor. It's ideal for organizations that value real-time feedback, are tracking employer brand perception, or need summarized insights for leadership reporting without sifting through thousands of raw reviews. What problem is this workflow solving? Manually reviewing and analyzing Glassdoor reviews is tedious, subjective, and not scalable, especially for larger companies or those with many subsidiaries. This workflow: - Automates review collection by making a Glassdoor company request via the Bright Data Web Scrapper API. - Uses Google Gemini to summarize the content. - Sends an actionable summary to HR dashboards, leadership teams, or alert systems via the Webhook notification. What this workflow does - Makes an HTTP Request to Glassdoor via the Bright Data Web Scrapper API. - Polls the BrightData Glassdoor for the completion of the request. - Downloads the Glassdoor response when a new snapshot is ready. - Sends the prompt to Google Gemini for summarization. - Delivers the summarized insights (strengths, weaknesses, sentiment, patterns) to a configured webhook or dashboard endpoint. Setup 1. Sign up at Bright Data. 2. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. 3. In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication). 4. The Value field should be set with the Bearer XXXXXXXXXXXXXX. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker Token. 5. A Google Gemini API key (or access through Vertex AI or proxy). 6. A webhook or endpoint to receive the summary (e.g., Slack, Notion, or custom HR dashboard). How to customize this workflow to your needs - Change Summary Focus by updating the Summarization of Glassdoor Response node summarization methods and prompts to extract specific insights: - Cultural feedback - Leadership issues - Compensation comments - Exit motivation - Update the HTTP Request to Glassdoor node with a specific Glassdoor Company information that you are looking for. - Format the output to produce a customized summary to Markdown or HTML for rich delivery. - Integrate with HR Systems: - BambooHR - Workday - SAP SuccessFactors via API. - Google Sheets or Airtable.

Learning something new? Endlessly searching to find the best resources? This workflow finds top community-recommended learning resources on any topic from Hacker News, delivered to your inbox. How it works User submits a topic they want to learn via a simple form. The workflow searches for relevant "Ask HN" posts on Hacker News and extracts top-level comments. An LLM analyzes the comments and identifies the best learning resources. A personalized email is sent to the user with a Markdown formatted list of top recommendations, categorized by resource type (e.g., book, course, article) and difficulty level. Set up steps 1. Add your Google Gemini API credentials. You'll need to create a project and enable the Generative Language API. 2. Add your SMTP credentials for sending emails. 3. Customize the Form and email subject (optional). 4. Activate the workflow. Fork it, tweak it, have fun!

Automated AI Content Creation & Instagram Publishing from Google Sheets This n8n workflow automates the creation and publishing of social media content directly to Instagram, using ideas stored in a Google Sheet. It leverages AI (Google Gemini and Replicate Flux) to generate concepts, image prompts, captions, and the final image, turning your content plan into reality with minimal manual intervention. Think of this as the execution engine for your content strategy. It assumes you have a separate process (whether manual entry, another workflow, or a different tool) for populating the Google Sheet with initial post ideas (including Topic, Audience, Voice, and Platform). This workflow takes those ideas and handles the rest, from AI generation to final publication. What does this workflow do? This workflow streamlines the content execution process by: - Automatically fetching unprocessed content ideas from a designated Google Sheet based on a schedule. - Using Google Gemini to generate a platform-specific content concept (specifically for a 'Single Image' format). - Generating two distinct AI image prompt options based on the concept using Gemini. - Writing an engaging, platform-tailored caption (including hashtags) using Gemini, based on the first prompt option. - Generating a visual image using the first prompt option via the Replicate API (using the Flux model). - Publishing the generated image and caption directly to a connected Instagram Business account. - Updating the status in the Google Sheet to mark the idea as completed, preventing reprocessing. Who is this for? - Social Media Managers & Agencies: Automate the execution of your content calendar stored in Google Sheets. - Marketing Teams: Streamline content production from planned ideas and ensure consistent posting schedules. - Content Creators & Solopreneurs: Save significant time by automating the generation and publishing process based on your pre-defined ideas. - Anyone using Google Sheets to plan social media content and wanting to automate the creative generation and posting steps with AI. Benefits - Full Automation: From fetching planned ideas to Instagram publishing, automate the entire content execution pipeline. - AI-Powered Generation: Leverage Google Gemini for creative concepts, prompts, and captions, and Replicate for image generation based on your initial topic. - Content Calendar Execution: Directly turn your Google Sheet plan into published posts. - Time Savings: Drastically reduce the manual effort involved in creating visuals and text for each planned post. - Consistency: Maintain a regular posting schedule by automatically processing your queue of ideas. - Platform-Specific Content: AI prompts are designed to tailor concepts, prompts, and captions for the platform specified in your sheet (e.g., Instagram or LinkedIn). How it Works 1. Scheduled Trigger: The workflow starts automatically based on the schedule you set (e.g., every hour, daily). 2. Fetch Idea: Reads the next row from your Google Sheet where the 'Status' column indicates it's pending (e.g., '0'). It only fetches one idea per run. 3. Prepare Inputs: Extracts Topic, Audience, Voice, and Platform from the sheet data. 4. AI Concept Generation (Gemini): Creates a single content concept suitable for a 'Single Image' post on the target platform. 5. AI Prompt Generation (Gemini): Develops two detailed, distinct image prompt options based on the concept. 6. AI Caption Generation (Gemini): Writes a caption tailored to the platform, using the first image prompt and other context. 7. Image Generation (Replicate): Sends the first prompt to the Replicate API (Flux model) to generate the image. 8. Prepare for Instagram: Formats the generated image URL and caption. 9. Publish to Instagram: Uses the Facebook Graph API in three steps: - Creates a media container by uploading the image URL and caption. - Waits for Instagram to process the container. - Publishes the processed container to your feed. 10. Update Sheet: Changes the 'Status' in the Google Sheet for the processed row (e.g., to '1') to mark it as complete. Prerequisites - Active n8n instance (Cloud or Self-Hosted). - Google Account with access to Google Sheets. - Google Sheets API Credentials (OAuth2): Configured in n8n. - A Google Sheet structured with columns like Topic, Audience, Voice, Platform, Status (or similar). Ensure your 'pending' and 'completed' statuses are defined (e.g., '0' and '1'). - Google Cloud Project with the Vertex AI API enabled. - Google Gemini API Credentials: Configured in n8n (usually via Google Vertex AI credentials). - Replicate Account and API Token. - Replicate API Credentials (Header Auth): Configured in n8n. - Facebook Developer Account. - Instagram Business Account connected to a Facebook Page. - Facebook App with necessary permissions: instagram_basic, instagram_content_publish, pages_read_engagement, pages_show_list. - Facebook Graph API Credentials (OAuth2): Configured in n8n with the required permissions. Setup 1. Import the workflow JSON into your n8n instance. 2. Configure Schedule Trigger: Set the desired frequency (e.g., every 30 minutes, every 4 hours) for checking new ideas in the sheet. 3. Configure Google Sheets Nodes: - Select your Google Sheets OAuth2 credentials for both Google Sheets nodes. - In 1. Get Next Post Idea..., enter your Spreadsheet ID and Sheet Name. Verify the Status filter matches your 'pending' value (e.g., 0). - In 7. Update Post Status..., enter the same Spreadsheet ID and Sheet Name. Ensure the Matching Columns (e.g., Topic) and the Status value to update match your 'completed' value (e.g., 1). 4. Configure Google Gemini Nodes: Select your configured Google Vertex AI / Gemini credentials in all Google Gemini Chat Model nodes. 5. Configure Replicate Node (4. Generate Image...): Select your Replicate Header Auth credentials. The workflow uses black-forest-labs/flux-1.1-pro-ultra by default; you can change this if needed. 6. Configure Facebook Graph API Nodes (6a, 6c): - Select your Facebook Graph API OAuth2 credentials. - Crucially, update the Instagram Account ID in the Node parameter of both Facebook Graph API nodes (6a and 6c). The template uses a placeholder (17841473009917118); replace this with your actual Instagram Business Account ID. 7. Adjust Wait Node (6b): The default wait time might be sufficient, but if you encounter errors during publishing (especially with larger images/videos in the future), you might need to increase the wait duration. 8. Activate the workflow. 9. Populate your Google Sheet: Ensure you have rows with your content ideas and the correct 'pending' status (e.g., '0'). The workflow will pick them up on its next scheduled run. This workflow transforms your Google Sheet content plan into a fully automated AI-powered Instagram publishing engine. Start automating your social media presence today!