HumationHuman + Automation
Back to Catalog

💬 Daily WhatsApp group summarizer – GPT-4o, Google Sheets & Evolution API

Amanda BenksAmanda Benks
2232 views
2/3/2026
AWSS3TriggerFile UploadMetadata
Official Page

Hey! I’m Amanda ❤️

I made this little workflow with care for people like you who are part of busy WhatsApp groups and want a simple way to keep track of everything.

It connects to Evolution API, collects all the group messages throughout the day, stores them in Google Sheets, and uses GPT-4o to generate a daily summary. The summary is saved as a document in Google Drive — ready to read, share, or archive.

It’s perfect for teams, communities, classes, or any group that talks a lot but doesn’t want to miss important info.

What it does

  • Collects WhatsApp group messages using Evolution API
  • Saves the messages in Google Sheets (organized by date)
  • Creates a clean, structured summary using GPT-4o
  • Saves the summary in Google Drive as a doc
  • Can run daily at a set time (fully automated)

How to set it up

  1. Connect your Evolution API and provide the group ID
  2. Use this Google Sheets template
  3. Connect Google Sheets and Google Drive in n8n
  4. Add your OpenAI API key
  5. (Optional) Adjust the AI prompt for a custom tone or structure

✅ Works on both n8n Cloud and Self-hosted
🔐 All credentials stay safe in n8n

Want to customize this for your group or business?

❤️ Buy Workflows: https://iloveflows.gumroad.com
💬 Hire My Services: +5517991557874 (WhatsApp)

Tradução em Português (pt-br):

Oi! Eu sou a Amanda 💬

Se você participa de grupos movimentados no WhatsApp e quer transformar tudo isso em resumos diários organizadinhos, esse fluxo foi feito com todo carinho pra você!

Ele conecta com a API da Evolution, coleta as mensagens trocadas em grupos, armazena tudo no Google Sheets, e no fim do dia gera um resumo completo usando GPT-4o. Esse resumo é salvo como documento no seu Google Drive — pronto pra ser lido, compartilhado ou arquivado.

Ideal pra equipes, comunidades, projetos colaborativos ou até grupos de estudos 📚

O que o fluxo faz

  • Monitora e salva conversas do grupo no Google Sheets
  • Gera resumos diários com IA (formato estruturado e pronto pra leitura)
  • Salva o resumo como documento no seu Google Drive
  • Funciona com qualquer grupo conectado à sua conta Evolution
  • Pode ser agendado pra rodar automaticamente todo fim de dia

Como configurar

  1. Conecte sua API Evolution e informe o ID do grupo
  2. Use essa planilha modelo para armazenar as mensagens
  3. Conecte sua conta do Google (Sheets + Drive)
  4. Adicione sua chave da OpenAI
  5. Personalize o prompt do resumo (opcional)

✅ Compatível com n8n Cloud e Auto-hospedado
🔐 Tudo seguro, simples e sem complicações

Quer adaptar esse fluxo pro seu sistema?

❤️ Buy Workflows: https://iloveflows.gumroad.com
💬 Hire My Services: +5517991557874 (WhatsApp)

Daily WhatsApp Group Summarizer with GPT-4o, Google Sheets, and Evolution API

This n8n workflow automates the process of summarizing daily WhatsApp group conversations using OpenAI's GPT-4o, storing the summaries in Google Sheets, and optionally posting them to a Google Drive document. It's designed to keep members informed without having to read through lengthy chat histories.

What it does

  1. Triggers Daily: The workflow is scheduled to run daily, typically in the morning.
  2. Fetches WhatsApp Messages: It makes an HTTP request to the Evolution API to retrieve all messages from a specified WhatsApp group for the previous day.
  3. Filters Messages: It filters out system messages and ensures only relevant chat messages are processed.
  4. Prepares Messages for AI: The collected messages are formatted into a single string, suitable for summarization by an AI model.
  5. Summarizes with GPT-4o: The formatted messages are sent to OpenAI's GPT-4o model to generate a concise summary of the day's conversation.
  6. Stores in Google Sheets: The generated summary, along with the date and group ID, is appended as a new row in a designated Google Sheet.
  7. Optional Google Drive Update: If configured, the summary is also appended to a specific Google Drive document.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • Evolution API Account: An account with Evolution API to access WhatsApp group messages. You'll need API credentials (URL and API Key).
  • OpenAI API Key: An API key for OpenAI (specifically for GPT-4o).
  • Google Account: A Google account with access to Google Sheets and optionally Google Drive.
    • Google Sheets Credential: An n8n credential configured for Google Sheets.
    • Google Drive Credential (Optional): An n8n credential configured for Google Drive.
  • WhatsApp Group ID: The ID of the WhatsApp group you want to summarize.
  • Google Sheet ID: The ID of the Google Sheet where summaries will be stored.
  • Google Drive File ID (Optional): The ID of the Google Drive document where summaries will be appended.

Setup/Usage

  1. Import the Workflow: Import the provided JSON into your n8n instance.
  2. Configure Credentials:
    • HTTP Request (Evolution API): Update the "HTTP Request" node with your Evolution API URL and API Key.
    • OpenAI Chat Model: Configure the "OpenAI Chat Model" node with your OpenAI API Key.
    • Google Sheets: Set up a Google Sheets credential and select it in the "Google Sheets" node.
    • Google Drive (Optional): Set up a Google Drive credential and select it in the "Google Drive" node.
  3. Update Node Parameters:
    • Edit Fields (Group ID): In the "Edit Fields" node, replace the placeholder YOUR_WHATSAPP_GROUP_ID with the actual ID of your WhatsApp group.
    • Google Sheets: In the "Google Sheets" node, replace YOUR_GOOGLE_SHEET_ID with the ID of your Google Sheet.
    • Google Drive (Optional): In the "Google Drive" node, replace YOUR_GOOGLE_DRIVE_FILE_ID with the ID of your Google Drive document.
  4. Activate the Workflow: Enable the workflow to start running on its schedule.
  5. Adjust Schedule (Optional): The "Schedule Trigger" node is configured to run daily. You can adjust the cron expression to change the frequency or time of execution as needed.

This workflow provides an efficient way to keep track of important discussions in busy WhatsApp groups, leveraging AI for intelligent summarization and Google services for data storage and sharing.

Related Templates

Automate Reddit brand monitoring & responses with GPT-4o-mini, Sheets & Slack

How it Works This workflow automates intelligent Reddit marketing by monitoring brand mentions, analyzing sentiment with AI, and engaging authentically with communities. Every 24 hours, the system searches Reddit for posts containing your configured brand keywords across all subreddits, finding up to 50 of the newest mentions to analyze. Each discovered post is sent to OpenAI's GPT-4o-mini model for comprehensive analysis. The AI evaluates sentiment (positive/neutral/negative), assigns an engagement score (0-100), determines relevance to your brand, and generates contextual, helpful responses that add genuine value to the conversation. It also classifies the response type (educational/supportive/promotional) and provides reasoning for whether engagement is appropriate. The workflow intelligently filters posts using a multi-criteria system: only posts that are relevant to your brand, score above 60 in engagement quality, and warrant a response type other than "pass" proceed to engagement. This prevents spam and ensures every interaction is meaningful. Selected posts are processed one at a time through a loop to respect Reddit's rate limits. For each worthy post, the AI-generated comment is posted, and complete interaction data is logged to Google Sheets including timestamp, post details, sentiment, engagement scores, and success status. This creates a permanent audit trail and analytics database. At the end of each run, the workflow aggregates all data into a comprehensive daily summary report with total posts analyzed, comments posted, engagement rate, sentiment breakdown, and the top 5 engagement opportunities ranked by score. This report is automatically sent to Slack with formatted metrics, giving your team instant visibility into your Reddit marketing performance. --- Who is this for? Brand managers and marketing teams needing automated social listening and engagement on Reddit Community managers responsible for authentic brand presence across multiple subreddits Startup founders and growth marketers who want to scale Reddit marketing without hiring a team PR and reputation teams monitoring brand sentiment and responding to discussions in real-time Product marketers seeking organic engagement opportunities in product-related communities Any business that wants to build authentic Reddit presence while avoiding spammy marketing tactics --- Setup Steps Setup time: Approx. 30-40 minutes (credential configuration, keyword setup, Google Sheets creation, Slack integration) Requirements: Reddit account with OAuth2 application credentials (create at reddit.com/prefs/apps) OpenAI API key with GPT-4o-mini access Google account with a new Google Sheet for tracking interactions Slack workspace with posting permissions to a marketing/monitoring channel Brand keywords and subreddit strategy prepared Create Reddit OAuth Application: Visit reddit.com/prefs/apps, create a "script" type app, and obtain your client ID and secret Configure Reddit Credentials in n8n: Add Reddit OAuth2 credentials with your app credentials and authorize access Set up OpenAI API: Obtain API key from platform.openai.com and configure in n8n OpenAI credentials Create Google Sheet: Set up a new sheet with columns: timestamp, postId, postTitle, subreddit, postUrl, sentiment, engagementScore, responseType, commentPosted, reasoning Configure these nodes: Brand Keywords Config: Edit the JavaScript code to include your brand name, product names, and relevant industry keywords Search Brand Mentions: Adjust the limit (default 50) and sort preference based on your needs AI Post Analysis: Customize the prompt to match your brand voice and engagement guidelines Filter Engagement-Worthy: Adjust the engagementScore threshold (default 60) based on your quality standards Loop Through Posts: Configure max iterations and batch size for rate limit compliance Log to Google Sheets: Replace YOURSHEETID with your actual Google Sheets document ID Send Slack Report: Replace YOURCHANNELID with your Slack channel ID Test the workflow: Run manually first to verify all connections work and adjust AI prompts Activate for daily runs: Once tested, activate the Schedule Trigger to run automatically every 24 hours --- Node Descriptions (10 words each) Daily Marketing Check - Schedule trigger runs workflow every 24 hours automatically daily Brand Keywords Config - JavaScript code node defining brand keywords to monitor Reddit Search Brand Mentions - Reddit node searches all subreddits for brand keyword mentions AI Post Analysis - OpenAI analyzes sentiment, relevance, generates contextual helpful comment responses Filter Engagement-Worthy - Conditional node filters only high-quality relevant posts worth engaging Loop Through Posts - Split in batches processes each post individually respecting limits Post Helpful Comment - Reddit node posts AI-generated comment to worthy Reddit discussions Log to Google Sheets - Appends all interaction data to spreadsheet for permanent tracking Generate Daily Summary - JavaScript aggregates metrics, sentiment breakdown, generates comprehensive daily report Send Slack Report - Posts formatted daily summary with metrics to team Slack channel

Daniel ShashkoBy Daniel Shashko
679

Generate Funny AI Videos with Sora 2 and Auto-Publish to TikTok

This automation creates a fully integrated pipeline to generate AI-powered videos, store them, and publish them on TikTok — all automatically. It connects OpenAI Sora 2, and Postiz (for TikTok publishing) to streamline content creation. --- Key Benefits ✅ Full Automation – From text prompt to TikTok upload, everything happens automatically with no manual intervention once set up. ✅ Centralized Control – Google Sheets acts as a simple dashboard to manage prompts, durations, and generated results. ✅ AI-Powered Creativity – Uses OpenAI Sora 2 for realistic video generation and GPT-5 for optimized titles. ✅ Social Media Integration – Seamlessly posts videos to TikTok via Postiz, ready for your audience. ✅ Scalable & Customizable – Can easily be extended to other platforms like YouTube, Instagram, or LinkedIn. ✅ Time-Saving – Eliminates repetitive steps like manual video uploads or caption writing. --- How it works This workflow automates the end-to-end process of generating AI videos and publishing them to TikTok. It is triggered either manually or on a recurring schedule. Trigger & Data Fetch: The workflow starts by checking a specified Form for new entries. It looks for rows where a video has been requested (a "PROMPT" is filled) but not yet generated (the "VIDEO" column is empty). AI Video Generation: For each new prompt found, the workflow sends a request to the Fal.ai Sora 2 model to generate a video. It then enters a polling loop, repeatedly checking the status of the generation request every 60 seconds until the video is "COMPLETED". Post-Processing & Upload: Once the video is ready, the workflow performs several actions in parallel: Fetch Video & Store: It retrieves the final video URL, downloads the video file Generate Title: It uses the OpenAI GPT-4o-mini model to analyze the original prompt and generate an optimized, engaging title for the video. Publish to TikTok: The video file is uploaded to Postiz, a social media scheduling tool, which then automatically publishes it to a connected TikTok channel, using the AI-generated title as the post's caption. --- Set up steps To make this workflow functional, you need to complete the following configuration steps: Prepare the Google Sheet: Create a Form with at least "PROMPT", "DURATION", and "VIDEO" fields. Configure Fal.ai for Video Generation: Create an account at Fal.ai and obtain your API key. In both the "Create Video" and "Get status" HTTP Request nodes, set up the "Header Auth" credential. Set the Name to Authorization and the Value to Key YOURAPIKEY. Set up TikTok Publishing via Postiz: Create an account on Postiz and connect your TikTok account to get a Channel ID. Obtain your Postiz API key. In the "Upload Video to Postiz" and "TikTok" (Postiz) nodes, configure the API credentials. In the "TikTok" node, replace the placeholder "XXX" in the integrationId field with your actual TikTok Channel ID from Postiz. (Optional) Configure AI Title Generation: The "Generate title" node uses OpenAI. Ensure you have valid OpenAI API credentials configured in n8n for this node to work. --- Need help customizing? Contact me for consulting and support or add me on Linkedin. Header 2

DavideBy Davide
24772

Automate bank statement and invoice reconciliation with GPT and Google Sheets

🟢 Manual Trigger Workflow starts manually to initiate the reconciliation process on demand. 📄 Fetch Invoices & Bank Statements Retrieves invoice data and bank statement data from Google Sheets for comparison. 🔀 Merge Data Combines both datasets into a single structured dataset for processing. 🧩 Format Payload for AI Function node prepares and structures the merged data into a clean JSON payload for AI analysis. 🤖 AI Reconciliation AI Agent analyzes the invoice and bank statement data to identify matches, discrepancies, and reconciled entries. 🧮 Parse AI Output Parses the AI response into a structured format suitable for adding back to Google Sheets. 📊 Update Sheets Adds the reconciled data and reconciliation results into the target Google Sheet for recordkeeping. 🧾 Prerequisites ✅ OpenAI API Credentials Required for the AI Reconciliation node to process and match transactions. Add your OpenAI API key in n8n → Credentials → OpenAI. ✅ Google Sheets Credentials Needed to read invoice and bank statement data and to write reconciled results. Add credentials in n8n → Credentials → Google Sheets. ✅ Google Sheets Setup The connected spreadsheet must contain the following tabs: Invoices – for invoice data Bank_Statement – for bank transaction data Reconciled_Data – for storing the AI-processed reconciliation output ✅ Tab Structure & Required Headers Invoices Sheet Columns: Invoice_ID Invoice_Date Customer_Name Amount Status Bank_Statement Sheet Columns: Transaction_ID Transaction_Date Description Debit/Credit Amount Reconciled_Data Sheet Columns: Invoice_ID Transaction_ID Matched_Status Remarks Confidence_Score ⚙️ n8n Environment Setup Ensure all nodes are connected correctly and the workflow has permission to access the required sheets. Test each fetch and write operation before running the full workflow.

Chintan PrajapatiBy Chintan Prajapati
447