Raw-materials store with requests, approvals and stock

The scenario handles receipts and release requests, approves them by email, writes off and updates stock and warns when material runs low.

  • Requests and email approvals
  • Stock counted on its own
  • A low-stock warning
  • Data reconciled in the database
Google SheetsWebhook

How it works

To keep Brevo and Webflow in sync, connect them with a ready-made scenario — changes flow automatically.

  1. Starts when: Get Approvals
  2. Then: Format Approval Response
  3. Then: Verify Approval Data
  4. Then: Retrieve Issue Request Details
  5. Check: Merge1
  6. Check: Process Approval Decision
  7. If yes: Update Stock After Issue
  8. If yes: Materials Issue Table Update
  9. If yes: Get Stock for Issue Update from Current
  10. Then: Update Stock
  11. Then: Update Current Stock1
  12. Then: LookUp Current stock1
  13. Then: Low stock Detection1
  14. Check: Is Stock is Low
  15. If yes: Low Stock Email Alert
  16. Then: Update Current Stck
  17. Then: Searck Issues
  18. Then: Append Material Request
  19. Then: Check Available Stock for Issue
  20. Check: Merge Lookups
  21. Then: Prepare Approval
  22. Then: Send Approval Request
  23. Then: Standardize Data
  24. Then: Validate Issue Request Data
  25. Then: Verify Requested Quantity
  26. Then: Create Record Issue
  27. Then: Search Product ID
  28. Starts when: Receive Issue Request
  29. Then: Append Raw Materials
  30. Then: Validate Quantity Received
  31. Then: Lookup Existing Stock
  32. Check: Merge
  33. Check: Check If Product ID Exists
  34. If yes: Calculate Updated Current Stock
  35. Then: Update Current Stock
  36. Then: LookUp Current stock
  37. Then: Low stock Detection2
  38. Check: Trigger Low Stock Alert
  39. If yes: Send Low Stock Email Alert
  40. Then: Current Stock Update
  41. If no: Format response
  42. Then: Initialize New Product stock
  43. Then: New Row Current Stock
  44. Then: Calculate Total Price
  45. Then: New Record Row
  46. Then: Search Current Stock
  47. Starts when: Receive Raw Materials Webhook
  48. Then: Standardize Raw Material Data

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