İçeriğe geç

Bu sayfa henüz sizin dilinizde yok. İngilizce metni okuyorsunuz.

Sheets, mail and other services

Google Sheets in ARMANOS flows

Read and write Google Sheets data right from a flow. The step works with a service account key and takes values from variables.

About the service

Google Sheets is the spreadsheet service from Google. A flow reaches it through a Google service account.

What you get with ARMANOS

  • Read a range

    The values of a range, for example Sheet1!A1:C10, go into a flow variable.

  • Write a row

    A row of values and variables goes into the spreadsheet.

  • Add a row at the end

    A new row lands under the last one.

  • Clear a range

    A range is cleared with one flow step.

  • Profile data in a row

    The profile name, number, group and code drop into any field of the step.

  • The key is locked on this computer

    The service account key stays on this computer. A flow keeps only the name of the key.

How to connect

  1. Open Flows

    The Flows screen is in the left column, in the Automation section.

    The Flows screen in the Automation section.
  2. Open Service keys

    The button sits in the flow window and in the Service key field of a step.

  3. Press Add a key

    Choose the kind Google service account and paste the JSON key file.

    Keys stay on this computer.
  4. Share the spreadsheet with the service account

    The account address is in the key file. Give it access to the spreadsheet in Google Sheets.

    Important: Without access the step does not see the spreadsheet.

  5. Add the Google Sheets block

    Find the block in the list on the left, then choose the action, the spreadsheet and the range.

    Flow blocks are searched by name.

Questions and answers

Which actions are available?
Read a range, write a row, add a row at the end and clear a range.
What goes into the Spreadsheet field?
The link to the spreadsheet or its id.
What goes into the Range field?
The sheet and the cells, for example Sheet1!A1:C10.

Link your flows to spreadsheets

Create an ARMANOS account and add a Google service account key.