Overview

The GoogleDocs library enables users to connect with the GoogleDocs server to perform tasks such as ConnectGoogleDocs, CreateGoogleDocs, OpenGoogleDocs, GetTextIndex, InsertText, ReplaceText, and ReadAllText.

The features provided by the GoogleDocs library are as follows:

GoogleDocs Features: ConnectGoogleDocs
Managing GoogleDocs: CreateGoogleDocs, OpenGoogleDocs
GoogleDocs editing features: GetTextIndex, InsertText, ReplaceText, ReadAllText

Common Properties

Common properties

MORE OPTIONS

MORE OPTIONS properties
Properties	Type	Required	Unit	Auto-setting	Description
On Error	Combination box	N	-	N	Specify an action to carry out when an error occurs at the time of execution. - --Ignore--: Ignore the error. - --Retry--: Try the activity one more time. - --Goto--: Try the scenario for the specified time if the activity fails. - _Event: Select an event created within the project.

DESCRIPTION

Properties	Type	Required	Unit	Auto-setting	Description
DESCRIPTION	Text	N	-	N	Enter the description for the activity card. The Description entered in the DESCRIPTION field is used as an description of the property. A representative value will be displayed in the absence of the DESCRIPTION input.

ConnectGoogleDocs

Overview

This activity card starts authorizing for the Google Docs you want to connect to.

Application procedures

In the [Output]Connection field, enter the variable to store the connection information.
In the AuthenticationType field, select the Authentication Type.
In the Client ID field, enter the client ID.

ClientID, ClientSecret, Key, etc., can be issued by referring to the GoogleWorkspace Guide page below.

https://developers.google.com/workspace/guides/create-credentials?hl=ko

Card properties

Common	Properties	Type	Required	Unit	Auto-settings	Description
N	[Output] Connection	Variable	Y	-	Y	Enter the variable to store the connection information.
N	Authentication Type	Combo Box	Y	-	Y	Select the type of authentication to access the GoogleDocs service.:- OAuth2ClientID - ServiceAccountKey
N	Client ID	String	If the Authentication Type is OAuth2ClientID, then Y, or N	-	N	Enter Client ID.
N	Client Secret	String	If the Authentication Type is OAuth2ClientID, then Y, or N	-	N	Enter Client Secret.
N	KeyPath	String	If the Authentication Type is ServiceAccountKey, then Y, or N	-	N	Enter the path to the service account key JSON file.
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

In the case of OAuth2.0, the client credential is cached and stored, and if the credential succeeds, the crocheted credential is used until the token expires. This is the same authentication process as Drive Library.

Example of utilization

Connect to GoogleDocs using GoogleDocs.

Connectgoogledocs

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.connection = variable to which the connection information will be assigned
Global.clientID = username of your GoogleDocs account
Global.clientSecret = User Secret in your GoogleDocs account
this.keyPath = JSON of the service account key of your GoogleDocs account

Used properties

[Output] Connection = Global.connection
AuthenticationType = OAuth2ClientID
Client ID = Global.clientId
Client Secret = Global.clientSecret
KeyPath = this.keyPath

Related/Similar activities

CreateGoogleDocs, OpenGoogleDocs

CreateGoogleDocs

Overview

This activity card creates GoogleDocs.

Application procedures

In the [Output] fileID field, enter a variable to store the result.
In the [Input] Connection field, enter the variable and store the connection information.
In the Title field, enter Title.

Card properties

Common	Properties	Type	Required	Unit	Auto-settings	Description
N	[Output] FileID	Variable	Y	-	Y	Enter a variable to store the FileID.
N	[Input] Connection	Variable	Y	-	Y	Enter the variable to store the connection information.
N	Title	String	Y	-	N	Enter a Title.
N	Folder	Combo Box	Y	-	Y	Select the folder to create GoogleDocs. - Root - FolderID - SearchInDrive
N	FolderID	String	If Folder is FolderID, then Y, or N	-		Enter the FolderID.
N	Path	String	If Folder is SearchInDrive, then Y, or N	-		Path to the Spreadsheet file.
N	Client ID	String	Y	-	.	Credentails Google Pop-up Enter your Client ID.
N	Client Secret	String	Y	-		Credentials Google pop-up Enter Client Secret.
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

Example of utilization

Create GoogleDocs.

CreateGoogleDocs

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.fileID = Variable to which FileID will be assigned
Global.connection = Connection Info Variable

Used properties

[Output] FileID = Global.fileID
[Input] Connection = Global.connection
Title = 'test'
Folder = Root

Related/Similar activities

ConnectGoogleDocs, OpenGoogleDocs

OpenGoogleDocs

Overview

This activity card opens GoogleDocs.

Application procedures

In the [Output] fileID field, enter a variable to store the result.
In the [Input] Connection field, enter the variable and store the connection information.
In the OpenType field, select OpenType.

Card properties

Common	Properties	Type	Required	Unit	Auto-settings	Description
N	[Output] FileID	Variable	Y	-	Y	Enter a variable to store the generated FileID.
N	[Input] Connection	Variable	Y	-	Y	Enter the variable to store the connection information.
N	OpenType	Combo Box	Y	-	Y	Select to open GoogleDocs for: - FileID - SearchInDrive
N	FileID	String	If OpenType is FileID, then Y, or N	-	N	Enter the FolderID.
N	Path	String	If Folder is SearchInDrive, then Y, or N	-	N	Path to the GoogleDocs file.
N	Client ID	String	If Folder is SearchInDrive, then Y, or N	-	N	Credentails Google Pop-up Enter Client ID.
N	Client Secret	String	If Folder is SearchInDrive, then Y, or N	-	N	Credentials Google pop-up Enter Client Secret.
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

Example of utilization

Open GoogleDocs.

Opengoogledocs

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.fileID = Variable to which FileID will be assigned
Global.connection = Connection Info Variable

Used properties

[Output] FileID = Global.fileID
[Input] Connection = Global.connection
OpenType = SearchInDrive
Path = 'test'

Related/Similar activities

ConnectGoogleDocs, CreateGoogleDocs

InsertText

Overview

This activity card enters a value in the specified area.

Application procedures

In the Input field, enter the connection information variable.
In the Input FileID, specify a variable for the FileID to be entered.
Enter Text

Card properties

Common	Properties	Type	Required	Unit	Auto-setting	Description
N	[Input] Connection	Variable	Y	-	Y	Enter the connection information variables.
N	[Input] FileID	Variable	Y	-	Y	Specify a variable for the FileID to be entered.
N	Text	String	Y	-	N	Enter the string you want to enter.
N	Poisition	Combo Box	Y	-	N	Specify the input location. - Start - End- At Index
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

Example of utilization

Enter a value in the specified area.

InsertText

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.connection = Connection Info Variable
Global.fileID = FileID variable

Used properties

[Input] Connection = Global.connection
[Input] FileID = Global.fileID
Text = 'insert text'
Position = Start

Related/Similar activities

GetTextIndex, ReadAllText, ReplaceText

GetTextIndex

Overview

This activity card gets an array of Index for a specific string from a GoogleDocs document.

Application procedures

Specify the variables in the array to store the results in Indexes.
In the [Input] Connection field, enter the variable to store the connection information.
In the [Input] FileID field, enter a variable input target FileID.
Enter the Text to get the Index.

Card properties

Common	Properties	Type	Required	Unit	Auto-settings	Description
N	[Output] Indexes	Variable	Y	-	Y	Specifies the variables in the array where the results will be stored.
N	[Input] Connection	Variable	Y	-	Y	Enter the connection information variables.
N	[Input] FileID	Variable	Y	-	Y	Specify a variable for the FileID to be entered.
N	Text	String	Y	-	N	Enter the Text from which you want to get the Index.
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

Example of utilization

Get an array of Index for a specific string from a GoogleDocs document.

GettextIndex

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.connection = Connection Info Variable
Global.fileID = FileID variable

Used properties

[Output] Indexes = RESULT
[Input] Connection = Global.connection
[Input] FileID = Global.fileID
Text = 'insert text'

Related/Similar activities

InsertText, ReadAllText, ReplaceText

ReadAllText

Overview

This activity card reads GoogleDocs documents.

Application procedures

In the [Output] Text field, specify the a variable in the array to store the result.
In the [Input] Connection field, enter the variable to store the connection information.
In the [Input] FileID field, enter a variable input target FileID.

Card properties

Common	Properties	Type	Required	Unit	Auto-settings	Description
N	[Output] Texts	Variable	Y	-	Y	Specifies the variables in the array where the results will be stored.
N	[Input] Connection	Variable	Y	-	Y	Enter the connection information variables.
N	[Input] FileID	Variable	Y	-	Y	Specify a variable for the FileID to be entered.
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

Example of utilization

Read GoogleDocs documents.

Readalltext

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.connection = Connection Info Variable
Global.fileID = FileID variable

Used properties

[Output] Texts = RESULT
[Input] Connection = Global.connection
[Input] FileID = Global.fileID

Related/Similar activities

InsertText, GetTextIndex, ReplaceText

ReplaceText

Overview

This activity card changes the string in your GoogleDocs document.

Application procedures

In the [Output] ReplaceCount field, enter the variable to store the ReplaceCount to receive a result.
In the [Input] Connection field, enter the variable to store the connection information.
In the [Input] FileID field, enter a variable input target FileID
In the InputText field, enter the string.
In the ReplaceText field, enter the string to replace.

Card properties

Common	Properties	Type	Required	Unit	Auto-settings	Description
N	[Output] ReplaceCount	Variable	Y	-	Y	Specifies a variable to store the ReplaceCount to receive as a result.
N	[Input] Connection	Variable	Y	-	Y	Enter the connection information variables.
N	[Input] FileID	Variable	Y	-	Y	Specify a variable for the FileID to be entered.
N	InputText	Variable	Y	-	N	Specify the string to enter.
N	OutputText	Variable	Y	-	N	Specify the replacement target string.
Y	MORE OPTIONS	-	-	-	-	Common property of GoogleDocs library.
Y	DESCRIPTION	-	-	-	-	Common property of GoogleDocs library.

Example of utilization

Change the string in your GoogleDocs document.

ReplaceText

Sample file

Menu > Help > Samples > Sample > GoogleDocs

Used variables

Global.connection = Connection Info Variable
Global.fileID = FileID variable

Used properties

[Output] ReplaceCount = RESULT
[Input] Connection = Global.connection
[Input] FileID = Global.fileID
InputText = 'in'
ReplaceText = 'out'

Related/Similar activities

InsertText, GetTextIndex, ReadAllText