Quick overview This workflow collects up to five FAQ questions and answers from an n8n Form, converts each entry to an MP3 using OpenAI text-to-speech, uploads the files to Google Drive, logs links in Google Sheets, and emails a summary with listen and download links via Gmail. How it works Receives an n8n Form submission containing the requester’s email, a FAQ category, and up to five question-and-answer pairs. Splits the submitted FAQ pairs into individual items, generating a TTS script and a safe MP3 filename for each valid question and answer. Calls the OpenAI Audio Speech API (tts-1) to generate an MP3 file for each FAQ script. Uploads each generated MP3 to a specified Google Drive folder. Builds Google Drive view and direct-download URLs for each uploaded file and appends the FAQ details and links to a Google Sheets tab. Aggregates all processed FAQs into a single HTML summary and sends it to the submitter via Gmail with listen and download links. Setup Add an OpenAI API credential for the HTTP request to the OpenAI Audio Speech endpoint.
Tags
Gmail
Google Drive
Google SheetsWHTTP RequestRelated workflows
See all Gmail→WSync HubSpot Contacts with LinkedIn URLs, Detect Changes & Send Gmail Alerts
Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI. Who’s this for? This workflow is perfect for Ops-minded folks in Customer Success, Marketing, and Sales – especially if you’re juggling CSV lists, CRM updates, and team-wide reporting. Whether you're a CS ops lead syncing product usage, or a RevOps manager updating contact records, this will save you hours. 🧠 Why it matters Manually importing CSVs into HubSpot is a headache: ❌ Copy-paste errors ❌ Mismatched fields ❌ Wasted time formatting every upload This workflow does the heavy lifting for you: ✅ Pulls fields dynamically from your HubSpot instance ✅ Preps and maps CSV data in minutes ✅ Syncs with Google Sheets to keep your source of truth aligned 🔄 What the workflow actually does Pulls live field names from HubSpot’s API (no guesswork) Indexes and organizes your CSV for import Processes & transforms raw data (optional filters, cleanup, etc.) Dynamically maps CSV fields to HubSpot fields Executes the upload and logs results ⚙️ How to get started Prerequisites: HubSpot private app token Google Sheets API credentials Access to an n8n instance (cloud or self-hosted) Setup in 3 steps: Impo
WMove data between JSON and spreadsheets
This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.
WMonitor Server Uptime & Get Email Alerts with Google Sheets
🌐 Web Server Monitor & Alert System This automation pings web servers at regular intervals, logs their status, and sends email alerts if a server goes down. It’s perfect for maintaining visibility over server uptime — without complex monitoring tools. 🧠 How It Works This workflow performs minute-by-minute checks on all listed servers in a Google Sheet and: ✅ Logs all reachable servers in an “Alive” log. 🔻 Sends an email alert if a server is unreachable. 📄 Logs failed servers in a “Down” sheet with timestamps. 🧩 Key Components ⏰ 1. Schedule Trigger Runs the workflow every minute for real-time monitoring. 📄 2. Web Servers List (Google Sheets) Pulls server IPs or hostnames from a Google Sheet named Server_List. Each row = one server to monitor. This makes adding/removing servers effortless — just update the sheet. 🌐 3. Servers Alive Check (HTTP Request) Performs an HTTP GET request to each server (e.g., http://your-server.com). If the request fails, it automatically triggers the error path (handled via continueOnFail). ✅ 4. Web Server Alive Log (Google Sheets) Records successful pings in Server_Status_Alive with: Timestamp Server IP Status = Alive This log can be used for uptim