n8n Procurement Strategy Automation: OpenAI + Webhook + Gmail

Turn Procurement Category Reviews into an Automated Strategy—Webhook to Email in Minutes

This n8n procurement strategy automation workflow automatically starts a category review via Webhook, gathers spend and supplier/market data through HTTP requests, uses OpenAI (gpt-4o-mini) to generate a structured category strategy, publishes it to Google Docs, and emails the Category Manager via Gmail.

What this workflow does

• Triggers on a Webhook POST request to begin a new category review.
• Fetches category spend and procurement data from an external API using an HTTP Request node.
• Fetches supplier performance and market conditions from a second external API using another HTTP Request node.
• Combines the data and sends it to OpenAI (gpt-4o-mini) to generate a structured JSON category strategy.
• Parses the AI response into fields such as opportunities, risks, action plan, timeline, and expected savings.
• Creates a new Google Docs document named after the category and inserts the generated strategy content.
• Sends a Gmail email to the Category Manager with key highlights from the strategy.

Use cases

• Speed up category management by auto-producing strategy documents for periodic reviews.
• Standardize how teams capture expected savings, risks, and action plans across categories.
• Enable SaaS operators and automation engineers to integrate procurement data sources into n8n workflows with consistent output.

Technical details

• Nodes/Tools: webhook, http request, OpenAI, set, google docs, gmail, sticky note
• Output: Google Docs strategy document + Gmail email summary
• Setup required: OpenAI API credential (model: gpt-4o-mini), Google Docs OAuth credentials + Drive folder ID, Gmail OAuth credentials, and replace the provided dummy API URLs with your real category/supplier/market endpoints (including any required auth headers).