Power Platform Community Forum Thread Details

HI Team,

We are using Google Drive access with a service account, but I'm facing issues when attempting to create a new Google Sheet using the "Google Drive New Sheet" action in Power Automate Desktop. Instead of creating a new Google Sheet, it creates a different file type, like a text file. Additionally, I am unable to access any existing Google Sheets to read the data.

Could someone please guide me on how to resolve this issue? Any articles or solutions on how to properly create and access Google Sheets using a service account would be greatly appreciated.

Thanks in advance!

Categories:

Power Automate Desktop

Hi @TS-05041405-0

Ok Let's see if either helps.

1. https://www.toolify.ai/ai-news/automate-google-sheets-with-service-accounts-stepbystep-guide-847254

2. Create a Service Account in Google Cloud: (just to verify its correct)

Go to the Google Cloud Console: Navigate to the Google Cloud Console (https://console.cloud.google.com/.
Navigate to IAM & Admin: Click on "IAM & Admin" in the left-hand menu.
Select Service Accounts: Click on "Service Accounts".
Create Service Account: Click on the "+ CREATE SERVICE ACCOUNT" button.
Fill in the details:
- Service Account Name: Give your service account a descriptive name.
- Service Account ID: Choose a unique ID for the account.
- Description (Optional): Add a description if needed.
- Grant this service account access to this project: Choose the appropriate roles (e.g., "Sheets Editor").
- Click "Continue" and then "Done" .

2. Configure the Service Account:

Create a Key:
Go back to the "Service Accounts" page in the Google Cloud Console.

Select the service account you just created.

Click on the "Keys" tab.

Click on "+ ADD KEY" and choose "Create new key".

Select "JSON" as the key type and click "Create".

Save the JSON key file securely: as you will need it for authentication in Power Automate.
Grant Permissions:
In the Google Cloud Console, navigate to the IAM & Admin > Roles page.

Assign the necessary roles to the service account, such as "Sheets Editor" or "Spreadsheet Viewer".

3. Create a Power Automate Flow:

Create a New Flow:

Open Power Automate and create a new flow (e.g., from blank or a template).
Add a Trigger:

Choose a trigger that suits your needs (e.g., a scheduled trigger, a button click, or an event from another app).
Add a "Google Sheets" Action:
Search for "Google Sheets" in the Power Automate connector gallery.

Add the "Create a spreadsheet" action.
Configure the Action:
Spreadsheet Name: Enter the desired name for the new Google Sheet.

Folder ID: If you want to create the sheet in a specific folder, enter the folder ID.

Authentication:

Select "Service Account" as the authentication method.

Upload the JSON key file you saved earlier.
Add More Actions (Optional):
You can add more actions to the flow to perform other tasks, such as:

Writing data to the sheet.

Reading data from the sheet.

Sharing the sheet with other users.