Get sheets in Google Sheets Connector(Power Automate Cloud flows)

Japanese version.

This action retrieves information on all sheets that exist in the specified file in Google Sheets.

How to use

Select the "Google Sheets" connector when adding steps to the flow.

Select the "Get sheets" from the "Action" menu.

Set Parameters.

ParameterDescription
FileSpecify the Google Sheets file to be retrieved.

To use the information retrieved, "Apply to each" is also required.

Specify the dynamic content "Table List Value" in "Select an output from previous steps".

This will repeat the action put in place in "Apply to each" for the number of times the sheet exists.

Dynamic content "Table List Table Name" are available for the "Worksheet" option in the Add, Update, and Delete actions.

---

Links

Google Sheets Connector(Power Automate Cloud flows)