{"id":116684,"date":"2021-11-11T17:55:00","date_gmt":"2021-11-11T08:55:00","guid":{"rendered":"https:\/\/support.questetra.com\/?p=116684"},"modified":"2026-04-14T15:50:00","modified_gmt":"2026-04-14T06:50:00","slug":"google-sheet-table-add-sum","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheet-table-add-sum\/","title":{"rendered":"Adding Table Values to Google Sheets and Getting the Aggregate Value"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

In this article, I will explain the automatic process relating to Google Sheets.<\/p>\n\n\n\n

Google Sheets is an online spreadsheet software provided by Google. Anyone with a Google account can use it for free. Also, if the APIs are enabled in Google Workspace, you can access it from the outside to perform various operations. The automatic Steps introduced here use them.<\/p>\n\n\n\n

<\/div>\n\n\n\n

About each Auto-step<\/h3>\n\n\n\n

There are several preinstalled features related to Google Sheets, such as [Create File], [Add New Sheet], [Copy Sheet], [Append New Row], [Append New Rows (Table type data)], [Download Choice Data], [Get Row], and [Update Row]. In this article I will use [Append New Rows (Table type data)<\/a>] and [Get Row<\/a>].<\/p>\n\n\n\n

First, I will briefly explain each auto-step.<\/p>\n\n\n\n

Google Sheets: Append New Rows (Table type data)<\/h4>\n\n\n\n
\"\"
Append New Rows (Table type data) settings screen<\/figcaption><\/figure><\/div>\n\n\n\n

It appends the values in the Table-type Data Item to the specified Google Sheet. The field names set in the sub-items of the Table-type Data Item are used to specify the target column on the spreadsheet.<\/p>\n\n\n\n

Google Sheets: Get Row<\/h4>\n\n\n\n
\"\"
Get Row settings screen<\/figcaption><\/figure><\/div>\n\n\n\n

It retrieves the data from the specified row in the Google Sheet. To specify a row, prepare a String-type Data Item (single-line) to enter the target line number. The input values for each column in the spreadsheet are prepared as String-type Data Items (single line) and saved separately.<\/p>\n\n\n\n

\n\n\n\n

Example App<\/h3>\n\n\n\n

Below is the Workflow Diagram of an example App using these auto-steps.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

This App appends the content entered in Daily sales (a Table-type Data Item) to the spreadsheet and gets the cumulative value after the addition. It allows you to input test data to see its operations. By adding these auto-steps to Apps that use Table-type Data Items such as Out-of-pocket expense claims or Business trip requests, various budget consumption aggregations such as by person or by the department will be automatic since the table data in separate Processes can be amalgamated in one spreadsheet.<\/p>\n\n\n\n

<\/div>\n\n\n\n

Preparing the Spreadsheet<\/h4>\n\n\n\n

You must prepare a spreadsheet beforehand.<\/p>\n\n\n\n

Go to the Google page, then click the menu list (<\/i>) in the top-right corner and select Sheets. (If you are not logged in to your Google account, the login screen will be displayed.) You will see several templates in the [Start a new spreadsheet] section, so select Blank. When you enter the title of the spreadsheet it will be saved as a file in the My Drive area of your Google Drive. (You can also create a spreadsheet file in any folder of your Google Drive by clicking + New on the top left.)<\/p>\n\n\n\n

Open the created file and make a note of the file’s ID. The ID is the following part in the URL.<\/p>\n\n\n\n

https://docs.google.com\/spreadsheets\/d\/SPREADSHEETID\/edit#gid=0<\/code><\/pre>\n\n\n\n
Enter the following as headings in columns A to E on the first row.<\/p>\n\n\n\n
A: DATE, B: ITEM, C: QUANTITY, D: UNIT PRICE, E: SUBTOTAL<\/code><\/pre>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Then add another sheet to your spreadsheet. Click “+” (Add Sheet) at the bottom left of the screen to create Sheet 2 to the right of Sheet 1. Click the Sheet 2 tab to open it and enter AGGREGATE into the first row of the A column. Below that cell, the second row of the A column, enter the following function.<\/p>\n\n\n\n
=SUM(Sheet1!E2:E)<\/code><\/pre>\n\n\n\n
This means “display the total sum of the input values of the second row and below of column E of sheet 1”. Make sure that all the characters are entered in half-width characters.<\/p>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
Your spreadsheet is now ready.<\/p>\n\n\n\n
  • You can obtain various aggregate values by setting the spreadsheet, such as separating the sheets for each user and devising the aggregation target<\/li><\/ul>\n\n\n\n
    <\/div>\n\n\n\n
    Google and Questetra integration settings<\/h4>\n\n\n\n
    I will explain how to set up integration between Questetra and Google.<\/p>\n\n\n\n
    • System Administrator privileges are required to set up HTTP Authorization settings<\/li>
    • The registered HTTP Authorization settings are also shared with other Apps on the same workflow platform<\/li>
    • Since the scope of the request of the two auto-steps is different, you need to add the settings using the same procedure in each step respectively<\/li><\/ul>\n\n\n\n
      Place the aforementioned auto-step icons using the Questetra’s App editor. In the Append New Rows (Table type data) config screen, click the [Set up Settings] button below the C1: OAuth2 settings item to open the HTTP Authorization Setting Google Sheets API screen.<\/p>\n\n\n\n
      Click [Add] on the screen and specify a name of your choice. (An arbitrary string: it\u2019s better to give a name that is easy to understand later.)<\/p>\n\n\n\n
      \"\"<\/figure><\/div>\n\n\n\n
      Click [Get Token] in the added settings to move to the Google authentication screen.<\/p>\n\n\n\n
      \"\"<\/figure><\/div>\n\n\n\n
      In the account with which you will manipulate the spreadsheet, allow the request.<\/p>\n\n\n\n
      \"\"<\/figure><\/div>\n\n\n\n
      You have now obtained a token for OAuth2 authentication with Google. You can confirm it by checking the “\u25cb (refresh token)” indicator above the [Get Token] button.<\/p>\n\n\n\n
      Go back to the Append New Rows (Table type data) config screen and select and specify the setting name you have added in C1: OAuth2 settings.<\/p>\n\n\n\n
      Follow the same procedure on the Get Row Step config screen to set this up.<\/p>\n\n\n\n
      <\/div>\n\n\n\n
      Data Items settings<\/h5>\n\n\n\n
      Set up the Data Item settings as follows.<\/p>\n\n\n\n
      Data Item Name<\/strong><\/td>Field Name<\/strong><\/td>Data-type<\/strong><\/td>Required<\/strong><\/td>[Enter Value] Step<\/strong><\/td>[Confirm] Step<\/strong><\/td>Description<\/strong><\/td><\/tr>
      Title<\/strong><\/td>–<\/td>–<\/td>–<\/td>Editable<\/td>Display only<\/td>The title of the Process<\/td><\/tr>
      Aggregate<\/strong><\/td>q_Sum<\/td>String-type (single line)<\/td>No<\/td>No display<\/td>Display only<\/td>The aggregate value obtained from the sheet is saved<\/td><\/tr>
      Row<\/strong><\/td>q_Row<\/td>String-type (single line)<\/td>No<\/td>No display<\/td>No display<\/td>It is used to specify the row to be acquired. Set the numeric of the row number to the initial value.<\/td><\/tr>
      Daily Sales<\/strong><\/td>q_Table<\/td>Table-type<\/td>Yes<\/td>Editable<\/td>Display only<\/td>The contents will be added to the sheet.<\/td><\/tr><\/tbody><\/table>
      Data Items settings<\/figcaption><\/figure>\n\n\n\n
      Set up the Table-type Data Item as follows.<\/p>\n\n\n\n
      Table Item Name<\/strong><\/td>Table Item-type<\/strong><\/td>Field Name<\/strong><\/td>Description<\/strong><\/td><\/tr>
      DATE<\/strong><\/td>Date<\/td>date<\/td><\/td><\/tr>
      ITEM<\/strong><\/td>String<\/td>item<\/td><\/td><\/tr>
      QUANTITY<\/strong><\/td>Numeric<\/td>quantity<\/td><\/td><\/tr>
      UNIT PRICE<\/strong><\/td>Numeric<\/td>unit<\/td><\/td><\/tr>
      SUBTOTAL<\/strong><\/td>Numeric<\/td>subtotal<\/td>[Show calculated value] QUANTITY * UNIT PRICE<\/td><\/tr><\/tbody><\/table>
      Table Items settings<\/figcaption><\/figure>\n\n\n\n
      <\/div>\n\n\n\n
      Add table data (Google Sheets: Append New Rows (Table type data)) settings<\/h4>\n\n\n\n
      Settings in the Add table data step are as follows.<\/p>\n\n\n\n
      Config name<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
      C1: OAuth2 Config<\/strong><\/td>Yes<\/td>Specify the HTTP Authorization Setting name for connecting to Google Sheet APIs. You need to get the OAuth2 token in advance with the setting name to be specified. (Refer to Google and Questetra integration settings<\/a>.)<\/td><\/tr>
      C2: Target Spreadsheet ID<\/strong><\/td>Yes<\/td>Specify the Sheet ID you made a note at Preparing Spreadsheet<\/a>.<\/td><\/tr>
      C3: Target Sheet Title<\/strong><\/td>Yes<\/td>Enter the name of the Sheet
      (Sheet1)<\/td><\/tr>
      C4: Table type data item<\/strong><\/td>Yes<\/td>Select the Data Item Name of the Table-type
      (Daily sales)<\/td><\/tr>
      C-A: Field Name of Sub Data Item for Column-A<\/strong><\/td>No<\/td>Enter the Field name set in the Table Item of the Table-type Data Item.
      (date)<\/td><\/tr>
      C-B: Field Name of Sub Data Item for Column-B<\/strong><\/td>No<\/td>Enter the Field name set in the Table Item of the Table-type Data Item.
      (item)<\/td><\/tr>
      C-C: Field Name of Sub Data Item for Column-C<\/strong><\/td>No<\/td>Enter the Field name set in the Table Item of the Table-type Data Item.
      (quantity)<\/td><\/tr>
      C-D: Field Name of Sub Data Item for Column-D<\/strong><\/td>No<\/td>Enter the Field name set in the Table Item of the Table-type Data Item.
      (unit)<\/td><\/tr>
      C-E: Field Name of Sub Data Item for Column-E<\/strong><\/td>No<\/td>Enter the Field name set in the Table Item of the Table-type Data Item.
      (subtotal)<\/td><\/tr>
      (Leave the following setting items blank)<\/td><\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      The value of each Table Item entered in the Table-type Data Item in the Enter Value Step is added to the specified spreadsheet column. Please note that an error will occur if no value is entered in the Table-type Data Item.<\/p>\n\n\n\n
      <\/div>\n\n\n\n
      Get sum (Google Sheets: Get Row) settings<\/h4>\n\n\n\n
      Settings in the Get sum step are as follows.<\/p>\n\n\n\n
      Config name<\/strong><\/td>Required<\/strong><\/td>Description<\/strong><\/td><\/tr>
      C1: OAuth2 Setting<\/strong><\/td>Yes<\/td>Specify the HTTP Authorization Setting name for connecting to Google Sheet APIs. You need to get the OAuth2 token in advance with the setting name to be specified. (Refer to Google and Questetra integration settings<\/a>.)<\/td><\/tr>
      C2: Source Spreadsheet ID<\/strong><\/td>Yes<\/td>Specify the Sheet ID you made a note of in  Preparing Spreadsheet<\/a>.<\/td><\/tr>
      C3: Source Sheet Title<\/strong><\/td>Yes<\/td>Enter the name of the Sheet
      (Sheet2)<\/td><\/tr>
      C4: Row to Get<\/strong><\/td>Yes<\/td>Select the Data Item to be specified
      (Row)<\/td><\/tr>
      C5: Column Range to Get<\/strong><\/td>Yes<\/td>Specify the column to be obtained with the range.
      (A:A)<\/td><\/tr>
      C6_1: Data item that stores the value in the 1st column<\/strong><\/td>No<\/td>Select the Data Item to be specified.
      (Aggregate)<\/td><\/tr>
      (Leave the following setting items blank)<\/td><\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      It retrieves the value of the AGGREGATE cell calculated on the spreadsheet. You can confirm the value obtained at the Confirm Step.<\/p>\n\n\n\n
      When you finish setting up the App, [Release] it and Start a new Process for a test run. If you have set it up correctly, you can see that the table data entered in the workflow is added to the spreadsheet and the accumulated value is automatically set in the Sum Data Item.
      When you run multiple Processes, the accumulated value across the Processes will be retrieved.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Adds the contents of a Table-type Data Item to a Google Sheet and retrieves the aggregated value. Various aggregations can be performed automatically depending on the spreadsheet settings.<\/p>\n","protected":false},"author":3,"featured_media":116692,"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":[296],"tags":[396,3162],"class_list":["post-116684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog","tag-google-sheets-api-v4","tag-google-workspace"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-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\/2021\/11\/eyecatch-google-sheet-table-add-sum-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/eyecatch-google-sheet-table-add-sum-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":"Adds the contents of a Table-type Data Item to a Google Sheet and retrieves the aggregated value. Various aggregations can be performed automatically depending on the spreadsheet settings.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-um0","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":77746,"url":"https:\/\/support.questetra.com\/en\/templates\/expense-record-flow-20161121\/","url_meta":{"origin":116684,"position":0},"title":"Expense Record Flow","author":"Hirotaka NISHI","date":"2021-03-01","format":false,"excerpt":"Reports and records expenses after approval\/correction. The Process for all employees is automatically started at the beginning of every month. The employee holds the [1. Report] Task until the closing date and inputs the expenses and payments on behalf of during that term. At the [3. Confirmation\/Adjustment] Step, the accounting\u2026","rel":"","context":"In "Workflow Apps"","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\/07\/eye-catch-expense-record-flow-20161121-220-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\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-expense-record-flow-20161121-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77695,"url":"https:\/\/support.questetra.com\/en\/templates\/approval-flow-budget-control-20160920\/","url_meta":{"origin":116684,"position":1},"title":"Approval Flow-Budget Control","author":"Hirotaka NISHI","date":"2022-01-17","format":false,"excerpt":"A Proposal-approval flow that automatically records the approved spending in a Google Sheet. When a new Issue is entered at the [1. Submit plan draft] Step, the \u201cBudget Consumption Log\u201d (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision],\u2026","rel":"","context":"In "Workflow Apps"","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\/07\/eye-catch-approval-flow-budget-control-20160920-220-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\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-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":116684,"position":2},"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 "Workflow Apps"","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":75420,"url":"https:\/\/support.questetra.com\/en\/templates\/customer-master-data-sync-process-20160719\/","url_meta":{"origin":116684,"position":3},"title":"Customer Master Data Sync Process","author":"Hirotaka NISHI","date":"2021-01-14","format":false,"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\u2026","rel":"","context":"In "Workflow Apps"","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\/03\/eye-catch-customer-data-master-sync-process-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\/03\/eye-catch-customer-data-master-sync-process-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, 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&resize=525%2C300 1.5x, 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&resize=700%2C400 2x, 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&resize=1050%2C600 3x"},"classes":[]},{"id":97139,"url":"https:\/\/support.questetra.com\/en\/addons\/google-sheets-sheet-row-update-with-singleline-tsv\/","url_meta":{"origin":116684,"position":4},"title":"Google Sheets: Sheet Row, Update with Singleline TSV","author":"IMAMURA, Genichi","date":"2020-10-28","format":false,"excerpt":"Updates a Google Sheet with a single line of TSV data. Searches for an A-Column cell that exactly matches the first value of the TSV and overwrite only the first occurrence. The values will be parsed as if they were entered manually by the user. If no matching line exists,\u2026","rel":"","context":"In "Add-ons"","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Google Sheets: Sheet Row, Update with Singleline TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-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\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Row-Update-with-Singleline-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":97327,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/google-sheets-file-create\/","url_meta":{"origin":116684,"position":5},"title":"Google Sheets: Create File","author":"nishiokac","date":"2024-02-27","format":false,"excerpt":"This item creates a new Spreadsheet in the specified folder on Google Drive.","rel":"","context":"In "BPMN Icons"","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/11\/bpmn-icon-google-sheets.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/116684","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=116684"}],"version-history":[{"count":14,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/116684\/revisions"}],"predecessor-version":[{"id":122281,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/116684\/revisions\/122281"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/116692"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=116684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=116684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=116684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}