HELP: ISSUES EXPORTING DATATABLE TO GOOGLE SHEETS (GOOGLE WORKSPACE SCOPE + WRITE RANGE)

Help Robot
, , , ,
1

Hello everyone,
I am building an automation that extracts real-estate data (price, area, rooms, description) from the Fincaraíz website. Everything works well until I try to export the resulting DataTable to Google Sheets using the Google Workspace activities.

These are the problems I am facing:

1. Google Workspace Scope does not recognize my JSON key file

I created a service account in Google Cloud, downloaded the JSON credentials, and placed the file here:

C:\Users\USER_NAME\Desktop\CredencialesGSuite\credentials.json

Inside UiPath, I set this same path in Google Workspace Application Scope → Key File Path.
However, UiPath shows this warning:

“Couldn’t read authentication parameters. Key file not found at the specified path… You must provide a literal value…”

But the file is there. I used Shift + Right Click → Copy as path to make sure the path is correct.

2. The activity ‘Update Values’ does NOT appear in my Google Workspace package

I installed:

  • Google Workspace (latest version) from Manage Packages

But the activity Update Values does not exist in the “Sheets” category.
The only write-type activity I see is:

  • Write Range – Google Workspace

But it asks for:

Spreadsheet
Range
Include Headers
How to Write (Overwrite)
What to Write

And I’m not sure how to link my DataTable correctly.

3. I received XAML errors when importing a workflow with Google Sheets activities

Errors include:

  • “No se pudo encontrar el tipo ‘CellInSheetUpdated’…”
  • “Multiple root elements…”
  • “Sequence is not assignable to ActivityAction(DataRow)…”

This tells me maybe my project version or package version is mismatched with the example workflow someone provided me.

What I need

A clear explanation of:

  1. How to correctly configure Google Workspace Scope
  2. Which activity should be used to write an entire DataTable to a new Google Sheet
  3. How to pass the DataTable to the correct field
  4. Whether Write Range or Update Values should be used in the latest version

Extra info

  • UiPath Studio version: 26.0.180-cloud
  • Windows 10
  • The DataTable name is: TablaDatosCreada
  • I already tested the extraction logic; only the Google Sheets part is failing.

Thank you in advance. Any guidance is appreciated.
If needed, I can upload my XAML file so you can inspect it.

2

@Nicolas_Solano

In the new way you can use integration services to connect

also write range or append range can be used. write range is used to directly write if you want to append at the bottom use append range

Coming to errors please show some screenshots for more clarity

cheers