Automated Supplier Email Assistant with OpenAI & Google Sheets

This n8n workflow acts as an intelligent email assistant for busy professionals managing supplier communications. Users simply provide a natural language request, such as 'Send an email to my fruit supplier asking for a quote on 1 crate of mangoes.' The AI agent first queries a Google Sheets database to retrieve the supplier's contact details, then leverages OpenAI to generate a clear, professional email in a customizable tone. Finally, it sends the email directly via the connected Gmail account, streamlining the entire process without manual intervention.

Key benefits include significant time savings for procurement tasks, consistent professional communication, and reduced errors from manual data lookup or drafting. It's particularly valuable for small businesses, procurement teams, or healthcare administrators managing supplier relationships for patient-related supplies like medical equipment or pharmaceuticals.

Use cases span various industries: in healthcare patient management, it can request quotes or updates from medical suppliers; in retail, handle vendor orders; or in general business for routine supplier inquiries. Customization options include tweaking OpenAI prompts for tone, adding fields to Sheets (e.g., notes, location), or scaling to databases like Supabase. Requires OpenAI API, Google Sheets/Gmail OAuth, and n8n setup for seamless automation.