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 Optionsq_ID_list0
The list of IDs of the master, whose choices are to be synchronised, is stored.
List of Labels for Master Optionsq_label_list1
The list of label options is stored in the master that is to be synchronised.
Master Optionsq_selects2
The master, which is to be synchronised, is stored with the options.
