*The name of « G Suite » was changed into « Google Workspace » in October 2020
Hi there,
There are many cases of utilizing Questetra, a cloud-based workflow, in cooperation with G Suite (formerly Google Apps, which is a groupware provided by Google).
The topic of federation with G Suite is talked often in our Customer stories, as well as those I heard about other than them. The Customer stories are as follows.
- Sansan, Inc.
- JTB SYSTEM SOLUTION, INC
- Impress Holdings, Inc.
- Serverworks Co., Ltd.
- Cybertrust Japan Co., Ltd.
- Shanon Inc.
- POCKE, INC.
- CRIAX CO., LTD.
- Impress R&D
- KAWANO CONSUL
- CHUO Accounting Office
- i3systems, inc.
Likewise, we Questetra ourselves are using collaboration with G Suite so that we achieve efficiency in various businesses.
Because of such a situation, there are quite a lot of occasions I was asked that what kind of collaboration between G Suite and Questetra can be done.
Thus, I will introduce what kind of concrete cases there are since there are various cases which are referred to as, even in a word, « collaboration ».
2. Collaboration concerning Google Drive (storage)
3. Collaboration concerning Google Sheets
4. Collaboration concerning Google Calendar
5. Method of collaboration
6. Closing
1. Collaboration concerning Authentication and User information
- Single Sign-On with G Suite [Standard]
(Logging in without ID/Password input if logged in to G Suite) - Incorporating G Suite user, organization, group information [Standard]
(Retrieve from G Suite and incorporate only necessary parts.)
2. Collaboration concerning Google Drive (storage)
- Output the files attached to Questetra and PDF automatically generated by Questetra to Google Drive [Standard]
(Automatically accumulate automatically generated quotations or invoices in predetermined folders) - Output the files attached to Questetra and PDF automatically generated by Questetra to Google Team Drive [Add-on] * Currently, the standard function doesn’t support Team Drive.
(Automatically accumulate the file attachments in predetermined folders.) - Launch a Questetra workflow by Google Form entry [Standard]
(Once someone inputs in the application form, the corresponding business flow starts after the application.) - Embed images on Google Drive and YouTube videos to Questetra Operating screen [Standard]
(An explanatory diagram or a manual movie necessary for Task processing is to be inserted in the Operating screen.) - Acquire the file on Google Drive and send as the attachment to the specified destination sequentially. [GAS]
(Store files in a predetermined folder of Google Drive, making the file names as to identify their destination, and distribute them collectively)
1 → M229: Auto Backup to Google Drive
2 → Add-on: Google Drive Upload
3 → M222: Auto Starting Triggered by Google Form Entry
3. Collaboration concerning Google Sheets
- Output the flow processing result of Questetra to Google Sheets collectively. [Standard]
(Manually create a list of expense reimbursement for the month to a Google Sheet.) - Output Questetra data to Google Sheets one by one, aggregate them automatically by Pivot Table of Google Sheets. [Add-on]
(Automatically aggregate the approved data of decision-making respectively in each department.) - Collectively launch Questetra business flows by a list on Google Sheets. [GAS] * There is an Add-on of GAS.
(Collectively starts flows at the beginning of the month according to the monthly task list and assign it to each person in charge.) - Google Sheets retrieves data from Questetra and display as a chart. [GAS]
(A list of expense reimbursement of the month is automatically created in Google Sheets) - Manage the Master data to be used in Questetra on Google Sheets. [GAS]
(Manage Customer master or Product master in Google Sheets, use them as options in Questetra.)
1 → M117: Refine Search over All Job Data/ Saving Refining Condition* [Save to Google Sheets] is also available likewise [Download].
2 → Add-on: Google Sheets Append Cell
3 → Blog post: Starting Processing in Bulk from Customer List on Google Spreadsheet
5 → Blog post: Several Ways to Manage Master Data with Questetra (Currently preparing for migration)
4. Collaboration concerning Google Calendar
- Create an event on Google Calendar by Questetra. [Add-on]
(Register the work date time which has been determined by a work request to Google Calendar.) - Start a Questetra workflow based on a schedule on Google Calendar. [GAS]
(Start a Report flow triggered by a client visit schedule.) - Output a deadline for a Task of Questetra to Google Calendar. [Standard]
(Register the deadline for requested work to Google Calendar.)
1 → Add-on: Google Calendar Schedule Append
2 → How to Start Workflow by a Schedule on Google Calendar (Currently preparing for migration)
5. Method of collaboration
Although I will not mention in detail here, there are several types of collaboration.
The « Standard », « Add-on », and « GAS » which are attached to each case in the above description indicate these types.
- Standard (Standard feature): Cases which are realized with functions that have equipped in Questetra as the standard
- Add-on (Questetra Service Task Add-on): Cases which are realized with Add-ons that Questetra is capable of incorporating
- GAS (Google Apps Script): Cases which are realized using Google Apps Script
Service Task Definition
* This page has various Add-ons for Google Calendar, Google Drive, Google Sheets, etc.
There are three different types of « Add-ons » for Questetra which are Service Task Add-on, Options Master XML, and Base PDF.
Also, there is a Google Sheets add-on similarly named as « Questetra BPM Suite add-on » (Start processes on Questetra BPM Suite by Google Spreadsheet data.) provided from Google Sheets.
6. Closing
I hope now you understand that collaborations in various cases are possible. I suppose there will be more other cases of collaborations hereafter.
I hope that you will achieve efficiency and automation variously in your business using Questetra and G Suite together.
Please feel free to contact us via Contact form when you have any question.
Apply for Free Edition of Questetra (Starter Plan) Here
By applying for your Free account of your own Questetra, you will be able to use all the Questetra features including what I mentioned above.
Please click HERE to go to the Web form.