{"id":75420,"date":"2021-01-14T13:55:00","date_gmt":"2021-01-14T04:55:00","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/customer-master-data-sync-process-20160719\/"},"modified":"2021-09-29T13:42:51","modified_gmt":"2021-09-29T04:42:51","slug":"customer-master-data-sync-process-20160719","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/templates\/customer-master-data-sync-process-20160719\/","title":{"rendered":"Customer Master Data Sync Process"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#44bbbb;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#77eeee;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Customer Master Data Sync Process<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">Automatically synchronizes customer master data managed in Google Spreadsheets. Automatically Starts at 1:00 every night, connects to Google spreadsheet API and acquires a customer list. The acquired customer list is reformatted and updated as a Customer Master (Options) XML on the Workflow platform. It also supports manual initiation and manual list checking.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"nodes\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>BPMN Nodes<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul wp-block-list\"><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"far fa-rectangle-landscape fa-lg\" style=\"color:#4a86e8;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">3<\/span><\/span><\/span> <strong>0. Manual Synchronization<\/strong> The person in charge will start downloading the Choice IDs and Labels from Google Sheets<\/li><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"far fa-rectangle-landscape fa-lg\" style=\"color:#4a86e8;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">7<\/span><\/span><\/span> <strong>1. Synchronization Check<\/strong> The person in charge checks the downloaded data and decides whether to update the option master.<\/li><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">12<\/span><\/span><\/span> <strong>x1. Download Choice Data<\/strong> The system retrieves the values from the specified cells of the Sheet and stores them in the Data Item<\/li><li><span class=\"fa-li\"><span class=\"fa-layers fa-fw\"><i class=\"fal fa-rectangle-landscape fa-lg\" style=\"color:#666666;\"><\/i><span class=\"fa-layers-text\" data-fa-transform=\"shrink-8\">6<\/span><\/span><\/span> <strong>x2. Master Update<\/strong> The system updates the options master file with the downloaded values<\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"diagram\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Workflow Diagram (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" data-attachment-id=\"98705\" data-permalink=\"https:\/\/support.questetra.com\/en\/templates\/customer-master-data-sync-process-20160719\/attachment\/customer-data-master-sync-process-en-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en.png?fit=1074%2C399&amp;ssl=1\" data-orig-size=\"1074,399\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"customer-data-master-sync-process-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en.png?fit=1024%2C380&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en-1024x380.png?resize=1024%2C380&#038;ssl=1\" alt=\"\" class=\"wp-image-98705\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en.png?resize=1024%2C380&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en.png?resize=600%2C223&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en.png?resize=768%2C285&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/customer-data-master-sync-process-en.png?w=1074&amp;ssl=1 1074w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>BPMN Icons<ul><li>Start Event<\/li><li>End Event<\/li><li>Join Gateway<\/li><li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/timer-start-event\/\">Timer Start Event<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/human-task\/\" target=\"_blank\">Human Task<\/a><\/li><li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/timer-intermediate-event-boundary-type\/\">Timer Intermediate Event (Boundary Type)<\/a><\/li><li><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-choices-update\/\">Update Choices<\/a><\/li><li><a href=\"https:\/\/support.questetra.com\/en\/addons\/googlesheets-getidslabels\/\">Service Task: Google Sheets: Download Choice Data<\/a><\/li><\/ul><\/li><\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"vars\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Variables (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>\u25bcNew Customes for Workflows\u25bc<\/strong> <span style=\"font-style:italic;\"> 3<\/span>: <\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box multiple lines)\"><\/i><\/span> <strong>value_id_list<\/strong> <span style=\"font-style:italic;\">q_Value 4<\/span>: Automatically acquired at x1.<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-font fa-lg\" style=\"color:#B40404;\" title=\"String (Text Box multiple lines)\"><\/i><\/span> <strong>display_label_list<\/strong> <span style=\"font-style:italic;\">q_Display 5<\/span>: Automatically acquired at x1.<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-list-alt fa-lg\" style=\"color:#AEB404;\" title=\"Select (Search Select Box)\"><\/i><\/span> <strong>customer_list<\/strong> <span style=\"font-style:italic;\">q_Customer 6<\/span>: <\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-info fa-lg\" style=\"color:#5F04B4;\" title=\"Guide Panel\"><\/i><\/span> <strong>\u25bcmemo\u25bc<\/strong> <span style=\"font-style:italic;\"> 7<\/span>: <\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-comments fa-lg\" style=\"color:#045FB4;\" title=\"Discussion\"><\/i><\/span> <strong>Memo<\/strong> <span style=\"font-style:italic;\">q_Memo 8<\/span>: <\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/drive.google.com\/uc?id=1IFdcbRdxz8PN7_v6iTqB3NAulTe1vKJO&amp;export=download\" target=\"_blank\" rel=\"noreferrer noopener\">customer-master-data-sync-process-20160719-209-en.qar<\/a><\/p>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"><i class=\"fal fa-info-circle\"><\/i> Available for <span style=\"color:#e06666\" class=\"has-inline-color\"><strong>Advanced<\/strong><\/span> and <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>You need to associate the Swimlane settings according to your organizational structure upon import<\/li><li>Immediately after importing, a setting error will occur<ul><li>Make the necessary settings in edit mode<\/li><\/ul><\/li><li>For practical use, please change the fixed values that have been set in \u201dx1. Download Choice Data\u201d<ul><li>C2: Source Spreadsheet ID, C3: Source Sheet Title<\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-wrench\"><\/i> Arrangement Tips<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>The updated Options Master file can be used by any Apps on the same workflow platform for Select-type Data Items<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Scenario: <a rel=\"noreferrer noopener\" href=\"https:\/\/en.workflow-sample.net\/2016\/07\/sync-google-spreadsheets.html\" target=\"_blank\">Episode 492: Referring to Client Master SpreadSheet (Sheets API v4)<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360052780932-Settings-Required-When-Importing-an-Archive\" target=\"_blank\">Settings Required When Importing an Archive<\/a><\/li><li>Data Item: <a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/data-items\/select-type\/\" target=\"_blank\">Select-Type<\/a><\/li><li>Blog: <a rel=\"noreferrer noopener\" href=\"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/\" target=\"_blank\">Utilize Customer Data on Google Sheets as Choices<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Synchronizes &#8220;Customer Master&#8221; managed in Google Spreadsheet, automatically. Automatically Starts 1:00 every night, connects to Google spreadsheet API, and acquires &#8220;Customer list&#8221;. The acquired customer list is reformatted and updated as &#8220;Customer Master (Options XML)&#8221; on the Workflow platform. It also corresponds to a manually starting by a person or checking on a list.<\/p>\n","protected":false},"author":3,"featured_media":98701,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[156],"tags":[321,489],"class_list":["post-75420","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-templates","tag-information-control","tag-purchase-order"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":0,"uagb_excerpt":"Synchronizes \"Customer Master\" managed in Google Spreadsheet, automatically. Automatically Starts 1:00 every night, connects to Google spreadsheet API, and acquires \"Customer list\". The acquired customer list is reformatted and updated as \"Customer Master (Options XML)\" on the Workflow platform. It also corresponds to a manually starting by a person or checking on a list.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-jCs","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":72429,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/master-data-management\/","url_meta":{"origin":75420,"position":0},"title":"Several Ways to Manage Master Data with Questetra","author":"Tsuyoshi Kusaka","date":"2017-09-19","format":false,"excerpt":"Hi there! The topic I am going to talk about this time is related with utilizing Questetra, as well as system collaboration. Management of master data associated with Questetra is one of the common agendas. There are cases where you prepare an approval flow when registering\/modifying\/deleting master data, which Questetra\u2026","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/09\/master-data-management-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78460,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/","url_meta":{"origin":75420,"position":1},"title":"Utilize Customer Data on Google Sheets as Choices","author":"Hirotaka NISHI","date":"2020-04-23","format":false,"excerpt":"Get the Customer List stored in Google Sheet via API, and save\/use it as the Options Master.","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":147822,"url":"https:\/\/support.questetra.com\/en\/templates\/master-synchronization-20230417\/","url_meta":{"origin":75420,"position":2},"title":"Customer Master Synchronisation App, Google Sheet Integration","author":"Tsuyoshi Kusaka","date":"2023-07-10","format":false,"excerpt":"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\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/master-synchronization-20230417-capture-en.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/master-synchronization-20230417-capture-en.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/master-synchronization-20230417-capture-en.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/master-synchronization-20230417-capture-en.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2023\/07\/master-synchronization-20230417-capture-en.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":78910,"url":"https:\/\/support.questetra.com\/en\/templates\/employee-information-acceptance-20160208\/","url_meta":{"origin":75420,"position":3},"title":"Employee Information Acceptance","author":"Hirotaka NISHI","date":"2021-01-05","format":false,"excerpt":"Manages additions\/updates in employee information and updates employee masters as needed. The data entered in the Step of [1. Addition \/ Updating of Employee's Information] is passed to the Human Resources Department after approval by the supervisor. If the employee master needs to be updated, the current master is retrieved,\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-employee-information-acceptance-20160208-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-employee-information-acceptance-20160208-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-employee-information-acceptance-20160208-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-employee-information-acceptance-20160208-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-employee-information-acceptance-20160208-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79860,"url":"https:\/\/support.questetra.com\/en\/templates\/common-password-request-20160725\/","url_meta":{"origin":75420,"position":4},"title":"Common Password Request","author":"Hirotaka NISHI","date":"2021-01-05","format":false,"excerpt":"Manage common passwords. Passwords are recorded in Google Sheets and retrieved\/updated via the API. The password user requests disclosure at the Step of [1. Password Request]. When the administrator approves, the password is automatically acquired and disclosed at the Step of [3. Password confirmation]. After confirmation, the password recorded in\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/eye-catch-common-password-request-20160725-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":166268,"url":"https:\/\/support.questetra.com\/en\/templates\/auto-update-customer-master-20211031\/","url_meta":{"origin":75420,"position":5},"title":"Automatic Update Salesforce Customer Master","author":"furuzo","date":"2024-09-24","format":false,"excerpt":"This workflow automatically imports Salesforce Account objects into the Account Choice Master. It starts automatically every day at 7:00 AM. Salesforce Account objects are added, changed, and deleted through various workflows and direct input from Salesforce. As of 7:00 AM every day, the latest Account information is used as choice\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2024\/09\/eyecatch-eyecatch-auto-update-customer-master-20211031-en2.png?fit=960%2C540&ssl=1&resize=700%2C400 2x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/75420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=75420"}],"version-history":[{"count":14,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/75420\/revisions"}],"predecessor-version":[{"id":114270,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/75420\/revisions\/114270"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/98701"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=75420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=75420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=75420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}