Quick Overview This workflow runs weekly to pull Google Jobs results via SerpApi, uses Google Gemini to extract operational pain points and an automation opportunity from each posting, logs them to Google Sheets, and writes a frequency-ranked pain-point summary to a summary tab. How it works Runs weekly on a schedule. Sets the target job role, location, and Google Sheets tab name to use for this run. Queries Google Jobs through SerpApi and splits the response into one item per job posting. Sends each posting’s title, company, and description to Google Gemini and parses the returned JSON into structured fields. Appends each analyzed posting (company, title, pain points, automation opportunity, and collection date) as a new row in Google Sheets. Reads all rows from the same Google Sheets tab, counts how often each pain-point phrase appears, and sorts the list by frequency. Appends the ranked pain-point frequency list to a Google Sheets "summary" tab. Setup Add a SerpApi API key and update the SerpApi request parameters in the HTTP request step (or store the key in an n8n credential).
Tags
Google SheetsWHTTP RequestRelated workflows
See all AI Automation→WRun LinkedIn outreach with Google Gemini, Apify, Google Sheets, and PhantomBuster
Quick overview This workflow collects a plain-English LinkedIn audience description via an n8n form, uses Google Gemini to generate a search URL, pulls matching leads from Apify, writes five personalized icebreakers to Google Sheets, and drip-launches a PhantomBuster agent every 15 minutes. How it works Receives a form submission with a plain-English description of your target LinkedIn audience. Uses Google Gemini to turn the audience description into a JSON response containing an Apollo-style search URL, then parses and extracts the searchUrl value. Calls the Apify API to run an actor and return up to 100 lead records matching the configured filters. Limits processing to the first five leads to control outreach volume. Uses Google Gemini to generate a short, unique connection-message icebreaker for each lead based on their profile fields. Appends or updates each lead in Google Sheets with contact details, LinkedIn URLs, and the generated icebreaker. Waits 15 minutes per lead and then triggers a PhantomBuster agent via HTTP request to start the outreach action. Setup Create and add credentials for Google Gemini (PaLM API) and update the model selection if needed. Add an Apify API t
Draft personalized cold emails from Google Sheets using Gemini and HubSpot
Quick overview This workflow batch-processes leads from Google Sheets, researches each person and company using Tavily plus Google Gemini, drafts a personalized cold email, then creates/updates the contact in HubSpot with a research note and a saved email draft before marking the lead as Done in the sheet. How it works Runs manually and sets a batch size that controls how many leads to process per run. Reads leads from Google Sheets, skips rows already marked as Done, and normalizes the selected batch into clean lead fields. Processes the batch one lead at a time and uses Tavily search (last 60 days) with Google Gemini to extract the most recent public activity, pain points, and a personalization hook. Cleans and parses the research JSON so it can be reused reliably downstream. Uses Google Gemini to draft a 90–120 word cold outreach email (subject and body) that incorporates the research and offers a free “Automated LinkedIn Post Creator” n8n workflow. Creates or reuses the HubSpot contact, logs a HubSpot note with the research and drafted email, and saves the email as a HubSpot engagement in DRAFT status. Updates the matching row in Google Sheets (by Email) to set Status to “Done
Handle WhatsApp customer service chats with Google Gemini and Google Sheets
Quick Overview This workflow handles WhatsApp customer service via OpenWA, using Google Gemini and a Google Sheets knowledge base to answer personal chats, while routing conversations to a human queue in Google Sheets when escalation is needed. How it works Triggers on OpenWA WhatsApp events and ignores message reactions except for specific ✅/☑ reactions used to re-enable AI handling. Normalizes incoming event fields and processes only personal chats (IDs ending with @c.us) that are not sent by your own WhatsApp account. Checks a Google Sheets “Session Chat” list to decide whether the conversation is currently handled by a human, and only continues to AI when no active human session is found. Uses a Google Gemini chat model with short-term memory and a Google Sheets “Database Company” tool to draft a friendly Indonesian response based only on the sheet data. If the AI response does not contain the #admin escalation token, it sends the reply back to the customer via OpenWA. If the AI response contains #admin, it appends the chat to the Google Sheets “Session Chat” sheet to flag it for human follow-up. When a ✅/☑ reaction is received for a chat, it finds and deletes the corresponding