Google Sheets

Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google.

Integration with LogicHub

Connecting with Google Sheets

To connect to Google Sheets following details are required:

📘

Note

The sheet must be shared with a service account and follow here to create a service account.

Actions with Google Sheets

Read Sheet

Reads data from Google Sheet.

Inputs to this Action

Output of Action
JSON containing following items:

  • has_error: True/False
  • error: message/null
  • result: Sheet Value
{
  "error": null,
  "has_error": false,
  "result": [
    "column1",
    "column2"
  ]
}

Write Sheet

Writes table data into Google Sheet.

Inputs to this Action

Output of Action
JSON containing following items:

  • has_error: True/False
  • error: message/null
  • result: Success/Failure message
{
  "result": "Sheet updated",
  "error": null,
  "has_error": false
}

Read Sheet (Dynamic URL)

Reads data from Google Sheet.

Inputs to this Action

Output of Action
JSON containing following items:

  • has_error: True/False
  • error: message/null
  • result: Sheet Value
{
  "error": null,
  "has_error": false,
  "result": [
    "column1",
    "column2"
  ]
}

Write Sheet (Dynamic URL)

Writes table data into Google Sheet.

Inputs to this Action

Output of Action
JSON containing following items:

  • has_error: True/False
  • error: message/null
  • result: Success/Failure message
{
  "result": "Sheet updated",
  "error": null,
  "has_error": false
}

Did this page help you?