Google Sheets Connector(Power Automate Cloud flows)


Japanese version.

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.

File designation

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.

You need to create a unique column by yourself or use "Insert row" or "Get rows" as it will be added automatically.

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.

Example of "Insert row" flow structure.

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.

Example of row get, update, and delete flow structure.


Does not exist.


Get rowsHighThis action retrieves multiple rows of data by specifying the file, sheet, and number of rows to be retrieved.
Insert rowHighThis action adds rows to Google Sheets.
Delete rowHighThis action deletes one data row by specifying the file name, sheet name, and ID of the row to be deleted.
Get rowLowThis action retrieves a single row of data from Google Sheets.
Get sheetsMiddleThis action retrieves information on all sheets that exist in the specified file in Google Sheets.
Update rowHighThis action updates the contents of a specified row in Google Sheets.