هذه الصفحة غير متوفرة بلغتك بعد. أنت تقرأ النص الإنجليزي.
Sheets, mail and other services
Google Sheets in ARMANOS flows
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
Open Flows
The Flows screen is in the left column, in the Automation section.
The Flows screen in the Automation section. Open Service keys
The button sits in the flow window and in the Service key field of a step.
Press Add a key
Choose the kind Google service account and paste the JSON key file.
Keys stay on this computer. 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.
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.