Skip to main content

Using the Google Sheet Connector

Prerequisite#

Usage#

Open Connectors library from right menu.

img

Filter Google Sheet from search menu

img

Import the Get Action

img

Double click on Google Sheet Connector to open the properties menu.

img

img

Set-up Google Sheet Connector Properties#

  • Provide the credential from Save Credential File

  • Provide Sheet_Id from Copy ID Part from Sheet

  • Provide the Range that you want to cover from the sheet in the format “Sheet1!A1:C1”, where Sheet1 is the name of sheet within your Google Sheet.

In our example sheet “Sheet1” is the name of sheet and you can select the cells to get the range details.

img

After fill the properties, associate the Google Sheet Get sub-flow with inject and debug node.

img

Deploy the changes and then inject message from “Inject” node. You will get result.

img

Similarly, you can setup the other actions like “Append”, ”Update” and “Clear”. For Update and Append you have to pass the comma separated values in the “Value” property.

img

Deploy the changes and then inject message from “Inject” node. You will get result.

img