小林幸一
Templates by 小林幸一
Extract & analyze Amazon reviews with Apify, Gemini AI & save to Google Sheets
Template Description 📝 Template Title Analyze Amazon product reviews with Gemini and save to Google Sheets 📄 Description This workflow automates the process of analyzing customer feedback on Amazon products. Instead of manually reading through hundreds of reviews, this template scrapes reviews (specifically targeting negative feedback), uses Google Gemini (AI) to analyze the root causes of dissatisfaction, and generates specific improvement suggestions. The results are automatically logged into a Google Sheet for easy tracking, and a Slack notification is sent to keep your team updated. This tool is essential for understanding "Voice of Customer" data efficiently without manual data entry. 🧍 Who is this for Product Managers looking for product improvement ideas. E-commerce Sellers (Amazon FBA, D2C) monitoring brand reputation. Market Researchers analyzing competitor weaknesses. Customer Support Teams identifying recurring issues. ⚙️ How it works Data Collection: The workflow triggers the Apify actor (junglee/amazon-reviews-scraper) to fetch reviews from a specified Amazon product URL. It is currently configured to filter for 1 and 2-star reviews to focus on complaints. AI Analysis: It loops through each review and sends the content to Google Gemini. The AI determines a sentiment score (1-5), categorizes the issue (Quality, Design, Shipping, etc.), summarizes the complaint, and proposes a concrete improvement plan. Formatting: A Code node parses the AI's response to ensure it is in a clean JSON format. Storage: The structured data is appended as a new row in a Google Sheet. Notification: A Slack message is sent to your specified channel to confirm the batch analysis is complete. 🛠️ Requirements n8n (Self-hosted or Cloud) Apify Account: You need to rent the junglee/amazon-reviews-scraper actor. Google Cloud Account: For accessing the Gemini (PaLM) API and Google Sheets API. Slack Account: For receiving notifications. 🚀 How to set up Apify Config: Enter your Apify API token in the credentials. In the "Run an Actor" node, update the startUrls to the Amazon product page you want to analyze. Google Sheets: Create a new Google Sheet with the following header columns: sentiment_score, category, summary, improvement. Copy the Spreadsheet ID into the Google Sheets node. AI Prompt: The "Message a model" node contains the prompt. It is currently set to output results in Japanese. If you need English output, simply translate the prompt text inside this node. Slack: Select the channel where you want to receive notifications in the Slack node.
By 小林幸一Create AI newsletters with GPT-4o, human approval workflow, and SendGrid
Generate AI newsletters from form inputs and send via SendGrid Streamline your email marketing process with this AI-powered "Human-in-the-Loop" workflow. It allows you to generate high-quality, targeted newsletters from a simple form input, review them via email, and automatically distribute them to your subscribers upon approval. Who is this for? Digital marketers, content creators, community managers, and small business owners who want to maintain consistent communication with their audience but need to reduce the time spent on drafting and formatting emails. What does this workflow do? Input Collection: Starts with a user-friendly n8n Form where you input the newsletter topic, target audience, and sender details. Data Logging: Automatically saves the form responses to a Google Sheet for your records. AI Generation: Uses OpenAI (GPT-4o) to draft a catchy subject line and valuable body content formatted in Markdown based on your inputs. Approval Process: Sends a "Review Request" email to your inbox (via Gmail). This email contains a preview of the newsletter and a special link to approve it. Execution Wait: The workflow pauses and waits for you to click the approval link. Distribution: Once approved, it converts the Markdown to HTML and sends the final newsletter to your subscriber list using SendGrid. Requirements OpenAI API Key: To utilize GPT-4o for content generation. Google Cloud Account: Required for the Google Sheets (logging) and Gmail (approval notifications) nodes. SendGrid Account: Required for sending the final newsletter to your subscribers. n8n version: Ensure you are using a version that supports the LangChain nodes. How to set up Configure Credentials: Set up your credentials for OpenAI, Google (Sheets & Gmail), and SendGrid within n8n. Subscriber List: Open the Workflow Configuration node (Set node). Replace the placeholder with your comma-separated list of subscriber emails. Google Sheets: Create a Google Sheet with columns for topic, target, sender, and admin_email. Update the Store Form Responses node with your Document ID and Sheet Name. Sender Verification: In the SendGrid node, ensure the "From Email" matches a verified sender identity in your SendGrid account. Test: Click "Test Workflow," fill out the Form Trigger URL, and check your email for the approval draft. Click the link in the email to finish the process. How to customize Change the AI Model: You can swap the OpenAI model node for Anthropic (Claude) or a local LLM if preferred. Adjust the Prompt: Edit the system message in the Generate Newsletter Content agent node to change the tone or structure of the newsletter. Swap Email Providers: If you don't use SendGrid or Gmail, simply replace these nodes with the email service of your choice (e.g., Mailchimp, Outlook, AWS SES).
By 小林幸一