Customer Master Synchronisation Process, Google Sheet Integration 20230417
This workflow automatically imports the latest customer master. The master data held on Google Sheets is automatically synchronised to the choice master in Questetra. Regardless of whether you have the authority to edit the choice master, if you have the authority to execute this flow, you can execute the synchronisation process.
Worker (#of Swimlane: 1)
  • Processor
    • Person in charge of master synchronisation.
Business Flow (Complexity of Workflow: 7)
  • 1(0. Do nothing and move on)
    • The person in charge completes the task immediately and proceeds with the process (empty tasks must be placed due to specification constraints)
  • 31. Data verification
    • The person in charge checks the data options that are due to be synchronised.
  • 2x1. Master data acquisition from G sheet
    • The workflow platform retrieves the master data from the specified Google Sheet.
  • 4x2. Reflecting the choice master
    • The workflow platform reflects the data scheduled for synchronisation in the choice master.
Business Process Variables (#of Data Item: 3)
  • ID List of Master Options q_ID_list 0
    • The list of IDs of the master, whose choices are to be synchronised, is stored.
  • List of Labels for Master Options q_label_list 1
    • The list of label options is stored in the master that is to be synchronised.
  • Master Options q_selects 2
    • The master, which is to be synchronised, is stored with the options.

Field Name, num, Initial Value


This archive contains the BPMN icons that are not available in the Basic edition.


See also

%d bloggers like this: