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.)
Tags
Gmail
Google SheetsWHTTP RequestRelated workflows
See all Gmail→WHandle NPS survey replies and routing with OpenAI, Gmail, and Google Sheets
Quick Overview This workflow runs every 6 hours to read new NPS responses from Google Sheets, uses OpenAI to draft a personalized reply, sends it via Gmail, routes respondents by NPS segment, logs promoter quotes back to Google Sheets, alerts support on detractors, and marks each row as processed. How it works Runs on a schedule every 6 hours and reads NPS response rows from a Google Sheets document. Filters the sheet to keep only rows where Status equals “new” to avoid reprocessing. Validates required fields, parses the 0–10 NPS score, and classifies each response as Promoter, Passive, or Detractor. Calls the OpenAI Chat Completions API to generate a warm, personalized email body based on the score segment and the customer’s comment. Sends the generated reply to the customer via Gmail and then routes the workflow by segment. For promoters, appends the customer comment as a quote to a “promoter-quotes” tab in Google Sheets and marks the original row as Processed; for passives, it marks the row as Processed. For detractors, sends an alert email to your support team via Gmail and then updates the original Google Sheets row status to Processed. Setup Create credentials for Google Shee
WHandle NPS survey responses with OpenAI, Gmail, and Google Sheets
Quick Overview This workflow runs every 6 hours to read new NPS survey responses from Google Sheets, generates a personalized reply with OpenAI, and sends the email via Gmail. It then routes promoters, passives, and detractors for follow-up actions and marks each response as processed. How it works Runs on a schedule every 6 hours. Reads NPS responses from a Google Sheets tab and keeps only rows where Status equals "new". Validates required fields, parses the 0–10 NPS score, and classifies each response as Promoter, Passive, or Detractor. Sends the response context to OpenAI (Chat Completions) to generate a concise, personalized email body and builds a segment-specific subject line. Sends the personalized reply to the respondent using Gmail. For promoters, appends the comment as a quote to a separate Google Sheets testimonials tab and updates the original row’s Status to "Processed". For passives, updates the original Google Sheets row’s Status to "Processed", and for detractors, emails an alert to a support inbox via Gmail and then updates Status to "Processed". Setup Add credentials for Google Sheets, Gmail, and OpenAI in n8n. Replace YOUR_NPS_SHEET_ID with your Google Sheets doc
WTriage and route support emails with Gemini, Gmail, Sheets and Slack
Quick Overview This workflow monitors unread Gmail support emails, uses Google Gemini to classify and summarize each message and draft a reply, logs the ticket details to Google Sheets, creates a Gmail draft response, and sends a Slack alert when the ticket is marked high priority. How it works Triggers every minute when a new unread email arrives in Gmail. Adds brand context and support guidelines, then builds a prompt that asks Google Gemini to return a JSON classification, priority, summary, and suggested reply. Sends the prompt to the Google Gemini API and parses the returned JSON into structured ticket fields. Appends the ticket details (sender, subject, category, priority, summary, and suggested reply) to a Google Sheets tab. Creates a Gmail draft reply in the original thread using the suggested response text. Sends a Slack message to a chosen channel when the ticket priority is high. Setup Connect credentials for Gmail, Google Gemini (PaLM) API, Google Sheets, and Slack. Update the brand name and support guidelines values used to guide Gemini’s response. Select the target Google Sheets spreadsheet and the “Tickets” sheet (and ensure your header columns match the fields you w