Neal Mcleod
Workflows by Neal Mcleod
Automate Facebook group problem-solving content with GPT-4 and Apify
# 🧠 FB Group Problem Solver - Auto - Generate Helpful Posts **For:** Business Owners, Community managers, coaches, consultants, and business owners who want to build authentic relationships in Facebook groups without spending hours scrolling and crafting responses. **Pain Point Solved:** Tired of manually browsing Facebook groups to find engagement opportunities? This workflow automatically discovers what your community is struggling with and writes genuine, helpful posts that position you as a trusted problem-solver. ## How It Works This workflow runs on autopilot to: 1. Scan your target Facebook groups for recent posts 2. Identify the most common problems and pain points 3. Analyze the community's language and communication style 4. Generate authentic, value-packed posts that solve real problems 5. Save ready-to-publish content to your Google Sheet ## What You'll Need - Google Sheets account (for group URLs and post storage) - PAID Apify account with Facebook Groups Scraper actor - OpenAI API key (GPT-4 recommended) - n8n instance (self-hosted or cloud) ## Quick Setup 1. **Import workflow** and connect your Google Sheets 2. **Add your Apify API key** and configure the Facebook scraper 3. **Insert OpenAI API keys** in the three AI nodes 4. **List your FB groups** in the input sheet (URL, Name, Niche) 5. **Test manually**, then schedule to run daily/weekly ## Results Get 2 post variations for each identified problem, written in the group's natural tone and style. Posts are non-promotional, genuinely helpful, and designed to spark engagement while building trust. **Time saved:** 3-5 hours per week of manual group monitoring and content creation
Transform viral Instagram Reels into original scripts with AI, Perplexity & Apify
## How it works Please guys, stop staring at a blank page. This workflow turns viral Instagram trends into original scripts for your channel automatically. * **Scrapes Trends:** Finds viral reels in your niche using Apify. * **Transcribes:** Downloads the video and converts the audio to text. * **Researches:** Uses Perplexity to find facts and add depth to the topic. * **Writes:** Generates a fresh, unique script based on the viral structure using AI. * **Saves:** meaningful content directly to your Google Sheet, ready for filming. ## Set up steps * **Apify:** You need an account to run the Instagram scraper. * **API Keys:** Have your OpenAI (for writing/transcription) and Perplexity (for research) keys ready. * **Google Sheet:** Create a sheet with headers for `URL`, `Transcript`, and `Final Script`. * **Credentials:** Enter your keys into the node credentials in n8n. * **Test:** Start with a low limit (e.g., 1-2 items) to verify the flow. ## Who is this for? * **Content Creators:** Beat writer's block and post more consistently. * **Social Media Managers:** Scale research without hiring a team. * **Agencies:** Rapidly repurpose trends for multiple clients.
Send automated invoice payment reminders with Gmail, Google Sheets and Twilio
This workflow streamlines accounts receivable management by automatically monitoring invoices in Google Sheets and sending scheduled payment reminders. It is designed for businesses using Gmail and Google Sheets that need a scalable alternative to complex accounting software. **How it works** 1. **Watches for invoices:** Triggers daily or via form submission to check for new entries. 2. **First Follow-up (Day 7):** Checks payment status one week after the invoice date. If unpaid, it sends a friendly email (and optional SMS). 3. **Second Follow-up (Day 9):** Re-checks status and sends a firmer reminder if funds are still not received. 4. **Final Notice (Day 12):** Sends a final urgent reminder before closing the cycle. 5. **Smart Stopping:** The workflow checks the 'Payment Status' column before every single message to ensure clients who have already paid are never disturbed. **Setup time:** About 20 minutes. **Prerequisites:** A Google Sheet with columns for Date, Email, and Payment Status.