Sheet change tracking with approval in your messenger

The scenario compares the sheet to a snapshot, keeps a change log, and sends edits for approval in okoCrm.

  • Changes found automatically — no manual diffing
  • A log of what was added, changed, deleted
  • Edits come to okoCrm for approval
  • History kept in a separate sheet
Microsoft Excel 365
Add it to your serverScriptera

How it works

To move data from oneC to okoCrm automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Run every 1 minute
  2. Then: Get rows
  3. Then: Normalize Data
  4. Then: Environment Config
  5. Then: Compare previous and current snapshot
  6. Check: Check if changes exist
  7. If yes: Transform changes for notification
  8. Then: Send notification
  9. If yes: Check if audit logging is enabled
  10. If yes: Build audit log rows
  11. Then: Append Log to Excel
  12. Then: Append Log to Sheet
  13. If yes: Filter rows with waiting approval
  14. Then: Notification Approval

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

Similar scenarios