Adds the TSV dataset after the last row. New rows will be inserted into the sheet if necessary. Only the specified columns of TSV are added, column ID with an identifier “d” as Datetime, and column ID with an identifier “n” as Numeric; eg “0,2d,5n”.
Adds a new sheet to the end of the spreadsheet. If the specified sheet name already exists, this Automated Task will end with an error. If needed, SheetId can also be specified.
Returns a value by referencing master data in Google Spreadsheets. Searches for the Lookup Value in array C, and if an exact match, returns the value in array D at the same index. C and D are defined in A1Notation. The length must be the same.
Exports the values in the rectangular range as TSV text, which has the same number of tab delimiters on each line. Empty cells are regarded as the null string. Two range export are also supported: e.g. Freezed headings and recent data.
Sums the numeric values in the specified range. Values that cannot be recognized as numeric values are regarded as zero. Two ranges of simultaneous calculations are also supported. e.g. The budgeting progress in the general ledger is summarized.
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 staff makes corrections such as “Payment by corporate card”, and then it is automatically recorded in a Google Sheet.
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 “Budget Consumption Log” (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision], the approver can make his/her decision confirming the budget consumption situation. The amount approved is automatically added to the “budget consumption log”.
Download GoogleSheets-valueUpdate.xml Capture Notes * https://docs.google.com/spreadsheets/d/1exampleEXAMPLEexampleEXAMPLEexampleEXAMPLE0/edit#gid=0 See also 2017-09-04 (Weekly Sales Report-Feedback): Episode 551: Comments on Weekly Report SpreadSheet
