This is a set of functions to manipulate Google Sheets stored in Google Drive.
Since there is no action to create a new file, the flow is mainly manipulating already existing files.
This is done by Google Drive's unique file ID.
The appearance on the flow is the file path, but it is only a display and the content is the ID.
Even if a file with the same name is created after the file is deleted after designation, it will be treated as a different file because the ID has changed.
In that case, the flow will not work unless the file is re-specified.
ID for handling rows, as this information does not exist in Google Sheets.
How to build flow.
In many cases, "Insert row" is just adding rows to a sheet,
It can be used independently of other Google Sheets triggers and actions.
In most cases, a fixed target sheet is specified,In some cases, the target sheet is retrieved from the "Get sheets" action.
Retrieving, updating, and deleting rows requires a __PowerAppsId__.
To do so, you must either perform a "Get rows" action or create the columns in the sheet beforehand.
Does not exist.
|Get rows||High||This action retrieves multiple rows of data by specifying the file, sheet, and number of rows to be retrieved.|
|Insert row||High||This action adds rows to Google Sheets.|
|Delete row||High||This action deletes one data row by specifying the file name, sheet name, and ID of the row to be deleted.|
|Get row||Low||This action retrieves a single row of data from Google Sheets.|
|Get sheets||Middle||This action retrieves information on all sheets that exist in the specified file in Google Sheets.|
|Update row||High||This action updates the contents of a specified row in Google Sheets.|