Write Spreadsheet step writes to a spreadsheet on Google Drive.
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