OpenAI Workflows
5 Ergebnisse — ausschließlich quellenverknüpfte n8n-Referenzen
Route ecommerce review alerts from Gmail to Slack with OpenAI and Google Sheets
Quick Overview This workflow polls Gmail for unread ecommerce review notification emails, extracts key review details, checks Google Sheets to prevent duplicate processing, uses OpenAI to classify sentiment and urgency, posts routed alerts to Slack, and logs each processed review and its AI metadata back to Google Sheets. How it works Polls Gmail every minute for unread emails with the “Reviews” label. Extracts the message ID, received time, customer details, product name, star rating, and review text from the email content. Reads the existing review audit log from Google Sheets and skips processing if the message ID already exists or the review text is too short. Sends the review details to OpenAI to return a JSON classification with sentiment, urgency, themes, summary, suggested action, and a sentiment score. Routes the review based on sentiment and urgency, escalating low-star or high-urgency negative reviews and optionally notifying on positive reviews. Posts a formatted alert to the selected Slack channel when notification is enabled. Appends the review (including route, AI fields, and whether Slack was notified) to Google Sheets as an audit log. Setup Create a Gmail label (fo
Generate Content From Google Sheets to X with GPT-4
AI-Powered Social Media Content Automation 🧑💻 Who is this for? This workflow is perfect for social media managers, content creators, and digital marketers who want to save time by automating social media post generation and publishing across platforms. 📌 What problem does this solve? Manually generating and scheduling social media content is time-consuming and repetitive. This workflow automates content creation and publishing, allowing you to: Streamline content generation using AI Ensure consistent posting across social media platforms Track published posts in Google Sheets 🔍 What this workflow does: Fetches content ideas from a Google Sheet. Generates social media posts using OpenAI's GPT-4. Checks the target platform (e.g., Twitter/X, LinkedIn). Posts the content to the chosen social media platform. Updates the Google Sheet with the generated post and timestamp. 🛠️ Setup Guide: Connect Google Sheets: Ensure you have a Google Sheet with content ideas (columns: Idea, Status, Generated Post). Set up OpenAI API Key: Provide your OpenAI API key for GPT-4. Configure Social Media Accounts: Link your Twitter/X or other social media accounts using n8n's built-in nodes. Test the Wo
Qualify new leads in Google Sheets via OpenAI's GPT-4
This n8n workflow was developed to evaluate and categorize incoming leads based on certain criteria. The workflow is triggered by adding a new row in a Google Sheets document. The workflow uses the OpenAI node to process the lead information. The system query contains detailed qualification rules and the response format. The user message contains the data for the individual lead. The JSON response from the OpenAI node is then processed by the Edit Fields node to extract the response. This response is merged together with the original lead data by the Merge node. Finally, the Google Sheets node updates the original lead entry in the Google Sheets document with the qualification result ("qualified" or "not qualified") in a separate column. This allows for easy tracking and sorting of the qualified leads.
AI Customer feedback sentiment analysis
LOOM Walkthrough: https://www.loom.com/share/4fbe06872cb8483993e7792018594f08 How it works Create a form for customer feedback, have OpenAI classify the sentiment of the feedback (positive/neutral/negative) and store it in Google sheets! Set up steps Connect Google sheets Connect your OpenAi account (api key + org Id) Create a customer feedback form, use an existing one or use the one below as example. All set! Here is the example google sheet being used in this workflow: https://docs.google.com/spreadsheets/d/1omWdRbiT6z6GNZ6JClu9gEsRhPQ6J0EJ2yXyFH9Zng4/edit?usp=sharing. You can download it to your account.
WOpenAI GPT-3: Company Enrichment from website content
Enrich your company lists with OpenAI GPT-3 ↓ You’ll get valuable information such as: Market (B2B or B2C) Industry Target Audience Value Proposition This will help you to: add more personalization to your outreach make informed decisions about which accounts to target I've made the process easy with an n8n workflow. Here is what it does: Retrieve website URLs from Google Sheets Extract the content for each website Analyze it with GPT-3 Update Google Sheets with GPT-3 data