Cloud BPM v11.11 Auto-Append to Google Sheets with Our New Service Task
Easier Real-time Utilization of Business Data

20190708-PR-ja-v1111-auto-append-to-google-sheets.pdf

Kyoto, Japan – July 8th, 2019 – Questetra, Inc., the global SaaS provider of Business Process Management (BPM), today announced that they have published the new version 11.11 of the Cloud-based Workflow product “Questetra BPM Suite” on Jul. 8th, 2019. This new version introduces a mechanism of automatically appending rows to a Google Sheets using only the standard features.

In daily work, various systems and services besides Workflow systems are used within the organization for the purpose of sales support, file storage/sharing, communication, collaboration, etc. In order to improve the convenience and productivity of users, it is essential to automate data coordination and processing among these multiple services.

Up to now “Questetra BPM Suite” has been capable of passing and receiving data in cooperation with external services by setting up HTTP communication or importing packaged “Add-ons” for communication processing, but knowledge of APIs and preparations in advance were required for them. In v11.11 a Service Task that performs the function has been added. By using the Service Task you will be able to build a system such as an “Order acceptance flow”, for example, in which data concerning an order is automatically added to a Google Sheets right after the approval Step is processed, without the need for any extra programming.

Questetra BPM Suite

Cloud-based Workflow “Questetra BPM Suite” is a business platform for realizing paperless environments and remote-working.

Business issues are controlled according to a Business Flow Diagram. When a Process reaches a Human Task, the user will be asked to add their input. Also, when an issue reaches an automated Step the predetermined processing (server-side processing) such as “Generate PDF” and “Save to cloud storage” is performed automatically. (BPM: Business Process Management)

You can apply it to various business operations such as “Approval request flow”, “Document translation flow”, Quality check process, “Invoice issuance process”. Process owners of each Business Process can practice “improvement of Business Process” little by little in daily work. (Examples of Business Flow Diagram: https://en.workflow-sample.net/ )

Google Sheets: Append New Row

It will be able to automatically append data to Google Sheets using the Service Task. When you are using Google Sheets for aggregating sales or expenses, you can connect them with your business. Thus, you can reduce the work time spent on the administration of this process.

Other Improvements

Google Sheets: Download Choice Data

It allows you to collectively retrieve various master data (i.e. Customer master, Product master, etc.) automatically using the Service Task. The retrieved data can be used as options in the Select type Data Item.

Converter (Date to Japanese era string)

Using the Service Task, Date type and Datetime type data can be converted to a string of Japanese calendar date format. (e.g. Converts a value of Date type Data “2019-07-08” to “令和元年7月8日”)

Google Drive: Folder Search

This Service Task allows you to search for folders on Google Drive. It can be used incorporated in processing such as to store files to a folder that are found in a search.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.