Why deals were won and lost — analysed from the actual correspondence

The scenario reads deal notes and correspondence from Microsoft Excel 365, has AI find the real reasons behind each outcome, writes the analysis back and emails a digest of recent deals to Gmail.

  • Real reasons instead of a one-word «too expensive»
  • The analysis of each deal is saved into Microsoft Excel 365
  • A digest of recent deals arrives by email at Gmail
  • You see patterns, not isolated anecdotes

How it works

To move data from Microsoft Excel 365 to Gmail automatically, use a ready-made scenario — no manual exports.

  1. Starts when: When clicking ‘Execute workflow’
  2. Then: Get row(s) in sheet
  3. Then: Extract Notes/Emails
  4. Check: Loop Over Items
  5. Then: Fetch Google Sheet Data
  6. Then: AI Agent1
  7. Then: Filter Recent Data
  8. Then: Send Email Digest
  9. Then: AI Agent
  10. Then: Edit Fields
  11. Then: Parse AI Response
  12. Then: Save to Google Sheets
  13. Then: Azure OpenAI Chat Model
  14. Then: Azure OpenAI Chat Model1

You can launch this Microsoft Excel 365 + Gmail integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.