-
Google Sheets: ValueRanges, Sum
Sums the numerical data in a specified range. Cells that cannot be recognized as numbers are considered zero. It also supports simultaneous calculation of two ranges. For example,…
-
Google Sheets: Spreadsheets Cells Value, Bulk Update (range)
Bulk update cells data at the specified range in a sheet. (Values containing line breaks cannot be specified)
-
Google Sheets: Two ValueRanges, Xlookup Reference
Converts string B to string C by referring to the two spreadsheet areas. Searches lookup_string in range B, and if there is an exact match it returns the…
-
Google Sheets: Find Row Number By Specified Value
Google スプレッドシートの対象列から指定値が入っている行番号を特定します。
-
Google Sheets: Spreadsheets Multiple Cells Value, Update
Overwrites mulitiple cells of a spreadsheet. The value will be parsed as if user typed text into the Google Sheets UI. For example, if date formated, the value…
-
Google Sheets #Sheet: Overwrite with TSV
Pastes TSV data to the specified coordinates in the specified sheet. Only the selected columns can be pasted. Specify the column ID with “d” for datetime data and…
-
Google Sheets: Find Row Number By Specified Value
Finds the row number that contains a specified value in the target column of a Google Sheet.
-
Quote Approval Process, Google Drive/Sheets Connectivity
This is a process that manages everything from drafting quotations and their approval to recording whether they are won or lost. After approval by a supervisor, a PDF…
-
Lending Management App, Random Responder Selection
This workflow accepts requests to borrow company-owned items. All employees can apply using the public form. A staff member in charge of the material management in the General…
-
Personal Information Transfer App
This workflow is for authorizing permission for personal information to be taken out of the system. Authorization is automatically recorded in the control ledger (G sheet). When a…
-
Google Sheet: Copy Sheet
This item copies a single Google Sheet to the same or another spreadsheet.
-
Google Sheets: Get Row
This item gets data in a specified row from a Google Sheet.
-
Google Sheets: Download Choice Data
This item downloads Choice Data in specified 2 columns from Google Sheet.
-
Google Sheets: Update & Get Cells
This item updates values of cells and gets updated values of other cells on Google Sheets.
-
Google Sheets: Append New Rows (Table type data)
This item appends values of a Table type data item at the last of the sheet.
-
Recurring Payment App, Stripe Payment
This workflow accepts subscription applications online. The customer makes a provisional application online using the trial version ID as a key. After the provisional subscription, the customer enters…
-
Maintenance Service Request Registration App
This is a workflow for registering maintenance service requests (SRs) to the central system. SRs are automatically added to a Google Sheet after being checked by the person…
-
Google Sheets: Two ValueRanges, Xlookup Reference
Converts string B to string C by referring to the two spreadsheet areas. Searches lookup_string in range B, and if there is an exact match it returns the…
-
Google Sheets: Delete Sheet
This item deletes a single sheet in a Google Sheet. When the Google Sheet has only one sheet, it cannot be deleted.
-
Google Sheets: Create File
This item creates a new Spreadsheet in the specified folder on Google Drive.
-
Google Sheets: Update Row
This item updates data in a specified row of a Google Sheet.