{"id":119881,"date":"2022-05-11T14:01:59","date_gmt":"2022-05-11T05:01:59","guid":{"rendered":"https:\/\/support.questetra.com\/?p=119881"},"modified":"2026-08-06T17:01:44","modified_gmt":"2026-08-06T08:01:44","slug":"google-sheets-employee-master","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/google-sheets-employee-master\/","title":{"rendered":"Managing Employee Information in Google Spreadsheets with Workflow Apps"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Questetra BPM Suite provides a variety of automation items that work with Google Workspace. By combining these automation items you can design a workflow that integrates Google Workspace services and Questetra.<\/p>\n\n\n\n

This article introduces a Workflow App that performs add\/retrieve\/update\/delete operations using employee information managed in Google Spreadsheets as an example.<\/p>\n\n\n\n

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

About Each Automation Items<\/h3>\n\n\n\n

Automation items related to Google Spreadsheets include [Create File], [Add New Sheet], [Copy Sheet], [Append New Row], [Append New Rows (Table type data)], [Download Choice Data], [Get Row], and [Update Row]. This time, four of them are used: [Append New Row<\/a>], [Get Row<\/a>], [Update Row<\/a>], [Download Choice Data<\/a>]. In addition, [Update Choices<\/a>] is also used to update the choices master file on the workflow platform.<\/p>\n\n\n\n

First, a brief description of each items<\/p>\n\n\n\n

Google Sheets: Append New Row<\/h4>\n\n\n\n

Add a row to the end of the sheet and enter data in each cell. Expand the row area if necessary.<\/p>\n\n\n\n

\"\"<\/a>
Append New Row Settings Screen<\/figcaption><\/figure><\/div>\n\n\n\n

Google Spreadsheet: Get Row<\/h4>\n\n\n\n

Retrieves data from a specified row in a Google spreadsheet. To specify a row, prepare a String-type Data Item (single row) and enter the target row number. Input values for each column of the spreadsheet are stored separately by preparing a String-type Data Item (single line) for each column.<\/p>\n\n\n\n

\"
Get Row Settings Screen<\/figcaption><\/figure><\/div>\n\n\n\n

Google Spreadsheet: Update Row<\/h4>\n\n\n\n

Updates data in the specified rows of a Google spreadsheet. To specify a row, prepare a String-type Data Item (single line) and enter the target row number. Specify a range of cells to be updated and specify the input contents for each cell.<\/p>\n\n\n\n

\"<\/a>
Update Row Settings Screen<\/figcaption><\/figure><\/div>\n\n\n\n

Google Spreadsheets: Download Choice Data<\/h4>\n\n\n\n

Retrieves data in two specified columns from a Google spreadsheet, preparing two String-type (multi-line) Data Items and storing the retrieved data in each column.<\/p>\n\n\n\n

\"<\/a>
Download Choice Data Settings Screen<\/figcaption><\/figure><\/div>\n\n\n\n

Update Choices<\/h4>\n\n\n\n

Register and update the list of choices defined in the Select-type Data Item as an app-shared\/app-specific choice master (add-on). It must be set by a user with app management authority. Each choice list specifies a String-type (multi-line) Data Item that will be used as a choice ID display label.<\/p>\n\n\n\n

\"<\/a>
Update Choices Settings Screen<\/figcaption><\/figure><\/div>\n\n\n\n
<\/div>\n\n\n\n
\n\n\n\n

Sample App<\/h3>\n\n\n\n

Here is a workflow diagram of a sample App created using these automation items.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

The starting point is divided according to the operation to be performed. Retrieving\/updating employee information starts from the same point, retrieves the information, and then modifies and updates it.<\/p>\n\n\n\n

Note that this App handles two employee lists.<\/p>\n\n\n\n