Spreadsheet creator

[sdk/google/spreadsheet/Spreadsheet creator]

---

Creates google spreadsheet on the given drive/folder. Example:

1. auth data receives { "email": "[e-mail]", "key": "TopSecretKey!" }@0

2. drive data { "file meta data": { "name": "Test!", "driveId": "0AFITUOLHhs3T_ID", "corpora": "drive", "parents": [ "1_ghBRrDju9oMNSy8DqqNtOEfDRIVE_Id" ] }, "supports all drives": true }"@0

3. spreadsheet data receives { "update meta data": { "range": "Sheet1!A1:B10" }, "values": [ ["A1 value", "B1 value"], ["A2 value", "B2 value"] ] }}@0

4. done sends null@0

---

Keywords: google, drive, spreadsheet

Input ports

• auth data: {"email": string, "key": string}

  Receives the authentication data of service account. Example: { "email": "[e-mail]", "key": "TopSecretKey!" }

• drive data:

  {"file meta data": {string: any}, "supports all drives": boolean}

  Receives the data of the drive where the spreadsheet is stored. Example: { "file meta data": { "name": "Test!", "driveId": "0AFITUOLHhs3T_ID", "corpora": "drive", "parents": [ "1_ghBRrDju9oMNSy8DqqNtOEfDRIVE_Id" ] }, "supports all drives": true }

• spreadsheet data:

  {"update meta data": {string: any}, "values": any[][]}

  Receives the spreadsheet metadata. { "update meta data": { "range": "Sheet1!A1:B10" }, "values": [ ["A1 value", "B1 value"], ["A2 value", "B2 value"] ] }

Output ports

• done: null

  Sends null if the action was successful. Example: null

• error: {"error": string}

  Sends the error which happened during the execution of the action. Example:. {error: "Something went wrong!"}