Experimental in Advanced Plugins

Experimental in Advanced Plugins



Experimental in Advanced Plugins

Write Spreadsheet 

Description

Write Spreadsheet step writes to a spreadsheet on Google Drive.


Configurations

No.

Field Name

Description

1

Step name

Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.


Input Fields:


3

Token Type

Token type by default is bearer.

4

Access Token

Access token is mandatory to access google spreadsheet using google REST APIs with specified scope.

5

Spreadsheet Name

Name of the spreadsheet.

6

Spreadsheet File Name

Name of the spreadsheet  file.

7

Append Values to existing Spreadsheet?

Enable checkbox to Append Values to an existing Spreadsheet.

8

Spreadsheet Id

Unique ID of that spreadsheet.


Range

Range should be provided in A1 notation.


This is a string like Sheet1!A1:B2, that refers to a group of cells in the spreadsheet, and is typically used in formulas.


Column Fields :


8

Name 

These headers can now be used as output fields.

9

Type


10

Get Fields Button

Click this button to fetch headers from the excel file.


Common Buttons:

No.

Field Name

Description


Buttons:


1

OK

On click of this button. It will check the field values.  If any required field values are missing then it will display validation error message.

If all the required field values are provided then it will save the field values.

2

Cancel

On click of this button, it will cancel the window and do not save any values








      Links to better reach 

            Bot Store

             EPD