Google Sheet writer
Write the given google sheet on configured Google Drive
.
Pre-requisite: Install Google Drive
application Profile > {Organization} > Applications
to grant Zparse access.
Input
Google Sheet
Google sheet data you want to write.
Parameters
Account—REQUIRED
Select configured Google Drive
which contains your spreadsheet.
Spreadsheet ID—REQUIRED
Select configured Google Drive
which contains your spreadsheet.
Example: Get spreadsheet id from the url.
Url: https://docs.google.com/spreadsheets/d/xxx-yyy-zzz/edit?gid=0#gid=0
ID : xxx-yyy-zzz
Value input option—REQUIRED
Wether to interpret formula or not.
- Raw: will not interpret formula
- User entered: will interpret formula
Output
Google sheet
Loaded given spreadsheet.