Google Sheets v3.0.0

Limited Use Requirements

App’s use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Table of Contents

• Contexts
• Actions
  • Extract Tab From Spreadsheet
  • Delete Rows
  • Update Spreadsheet Row
  • Find Row
  • Add To The Following

Contexts

You only need to SignIn with Google in order to use this application. You must have a Google Account.

You must grant Marjory the access authorisation (scopes) needed to run the application.

Actions

Extract Tab From Spreadsheet

Extract a tab from a spreadsheet

Inputs

{
  "url": "https://docs.google.com/spreadsheets/d/1gNkyL7hfb6dcIqByR6DP63lnYpga6AFl8BVlZCtMxDQ/edit#gid=0", /*(required)*/
  "tabName": "Tab 1", /*(required)*/
}

Outputs

Http Code 200

{ "marjoryFile": { "name": "string", "link": "string", "id": "string", "lastModified": "string", "size": "number", "contentType": "string" } }

Http Code 400

"Bad Request"

Http Code 401

"Unauthorized"

Http Code 403

"Forbidden"

Http Code 404

"Not Found"

Http Code 500

"Internal Server Error"

Delete Rows

Delete rows or only values of rows

Inputs

{
  "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/1MGD4jJIGvMGIkcBs2OH9lzHogK8q4oSj9Ni0cIu_0-k/edit?usp=share_link", /*Url of the spreasheet file(required)*/
  "tabName": "string", /*name of the tab where to clear(required)*/
  "deleteOnlyValues": "boolean", /*false if you want to delete rows, true if you only want to clear values without deleting rows. Default :"false"*/
  "startRow": "number", /*line from where you want to start the action. Line included*/
  "endRow": "number", /*if empty, clear until the end of the tab*/
}

Outputs

Http Code 200

null

Http Code 400

"Bad Request"

Http Code 401

"Unauthorized"

Http Code 403

"Forbidden"

Http Code 404

"Not Found"

Http Code 500

"Internal Server Error"

Update Spreadsheet Row

Update spreadsheet row.

Inputs

{
  "url": "https://docs.google.com/spreadsheets/d/1HEPdJS5uAtEtiuFB0fq0Q_kuM8n9Oi94nEfNl9_hmFk/edit#gid=0", /*(required)*/
  "data": [ /*(required)*/
    {
      "range": "Tab1", /*(required)*/
      "majorDimension": "ROWS", /*(required)*/
      "values": [ /*(required)*/
        [
          "string",
        ]
      ]
    }
  ]
}

Outputs

Http Code 200

null

Http Code 400

"Bad Request"

Http Code 401

"Unauthorized"

Http Code 403

"Forbidden"

Http Code 404

"Not Found"

Http Code 500

"Internal Server Error"

Find Row

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

Inputs

{
  "url": "https://docs.google.com/spreadsheets/d/1HEPdJS5uAtEtiuFB0fq0Q_kuM8n9Oi94nEfNl9_hmFk/edit#gid=0", /*(required)*/
  "range": "A1", /*The A1 notation or R1C1 notation of the range to retrieve values from.(required)*/
}

Outputs

Http Code 200

{ "data": { "range": "string", "majorDimension": "string", "values": "array" } }

Http Code 400

"Bad Request"

Http Code 401

"Unauthorized"

Http Code 403

"Forbidden"

Http Code 404

"Not Found"

Http Code 500

"Internal Server Error"

Add To The Following

Insert values at the following line

Inputs

{
  "url": "https://docs.google.com/spreadsheets/d/1gNkyL7hfb6dcIqByR6DP63lnYpga6AFl8BVlZCtMxDQ/edit#gid=0", /*Url of the sourcefile(required)*/
  "tabName": "Tab 1", /*(required)*/
  "values": [ /*(required)*/
    "string",
  ]
}

Outputs

Http Code 200

null

Http Code 400

"Bad Request"

Http Code 401

"Unauthorized"

Http Code 403

"Forbidden"

Http Code 404

"Not Found"

Http Code 500

"Internal Server Error"

Events

Check refresh token

Check refresh token. Be careful, this event is not usable. Only used by Marjory to run functions.