This Choreo creates a Google spreadsheet from a CSV file that you provide. The documentation for this Google Spreadsheets resource can be found here.
Note: since files are downloaded via the Google Drive API, you will want to request the following Scope when going through the OAuth process for this choreo:
https://www.googleapis.com/auth/drive
Here is an example of acceptable inputs:
ClientID: {YOUR CLIENT ID}
ClientSecret: {YOUR CLIENT SECRET}
RefreshToken: {YOUR REFRESH TOKEN}
Title: MyNewSpreadsheet
RowData:
FirstName,LastName,Email
John,Smith,john@temboo.com
Jack,Phillips,jack@temboo.com
The following is a sample of the JSON information returned by this Choreo:
{
"kind": "drive#file",
"id": "1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms",
"etag": "\"pt5nQlYh-yq-SeWugxLlOauv7RA/MTQyNTYwMTE2NTUyMA\"",
"selfLink": "https://www.googleapis.com/drive/v2/files/1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms",
"alternateLink": "https://docs.google.com/spreadsheets/d/1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms/edit?usp=drivesdk",
"embedLink": "https://docs.google.com/spreadsheets/d/1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms/htmlembed",
"iconLink": "https://ssl.gstatic.com/docs/doclist/images/icon_11_spreadsheet_list.png",
"title": "oauthtest.csv",
"mimeType": "application/vnd.google-apps.spreadsheet",
"labels": {
"starred": false,
"hidden": false,
"trashed": false,
"restricted": false,
"viewed": true
},
"createdDate": "2015-03-06T00:19:26.192Z",
"modifiedDate": "2015-03-06T00:19:25.520Z",
"modifiedByMeDate": "2015-03-06T00:19:25.520Z",
"lastViewedByMeDate": "2015-03-06T00:19:25.520Z",
"markedViewedByMeDate": "1970-01-01T00:00:00.000Z",
"version": "401618",
"parents": [
{
"kind": "drive#parentReference",
"id": "0ALyw6-lKEQSZUk9PVA",
"selfLink": "https://www.googleapis.com/drive/v2/files/1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms/parents/0ALyw6-lKEQSZUk9PVA",
"parentLink": "https://www.googleapis.com/drive/v2/files/0ALyw6-lKEQSZUk9PVA",
"isRoot": true
}
],
"exportLinks": {
"text/csv": "https://docs.google.com/spreadsheets/export?id=1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms&exportFormat=csv",
"application/pdf": "https://docs.google.com/spreadsheets/export?id=1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms&exportFormat=pdf",
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet": "https://docs.google.com/spreadsheets/export?id=1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms&exportFormat=xlsx"
},
"userPermission": {
"kind": "drive#permission",
"etag": "\"pt5nQlYh-yq-SeWugxLlOauv7RA/sqvaRhIfRFgon-Rn4a1YkWy4CrE\"",
"id": "me",
"selfLink": "https://www.googleapis.com/drive/v2/files/1P7H7GGEa_WhORdqHl-X54xvB82spX9REhh2Sa5hS1ms/permissions/me",
"role": "owner",
"type": "user"
},
"quotaBytesUsed": "0",
"ownerNames": [
"AJ TembooDev"
],
"owners": [
{
"kind": "drive#user",
"displayName": "AJ TembooDev",
"isAuthenticatedUser": true,
"permissionId": "04692518151122865289",
"emailAddress": "aarontemboodev@gmail.com"
}
],
"lastModifyingUserName": "AJ TembooDev",
"lastModifyingUser": {
"kind": "drive#user",
"displayName": "AJ TembooDev",
"isAuthenticatedUser": true,
"permissionId": "04692518151122865289",
"emailAddress": "aarontemboodev@gmail.com"
},
"editable": true,
"copyable": true,
"writersCanShare": true,
"shared": false,
"appDataContents": false
}