I can't find the data I read from Google Sheets :)

Help Activities
, ,
1

Hello everyone,

I read the data with Google Sheets Read Range activity. I have no problem reading data but I can’t find the data. How can I find the data I received and print it?

resim

Thanks!

2

How do you indicate that the data was not found? What is the error in UiPath?

3

I can’t get the data as any datatable. This is my first time dealing with sheets. It is enough for me if I can access the data I receive as a datatable.

4

Could you please attach a screenshot of the properties panel in the read range? Thank you

5
  1. Spreadsheet Configuration:
    For the Spreadsheet field, specify either the file ID or the URL of the file.
  2. Range Specification:
    In the “Range” field, enter only the name of the sheet.
  3. Permissions Note:
    Ensure that the account you are using has the necessary permissions for the file.
  4. Data Storage:
    Save the retrieved data in a DataTable.

A "Read Range" properties panel in a spreadsheet tool, where you can specify the spreadsheet URL or ID, the range, and whether the sheet has headers. (Captioned by AI)

image

Id file is in url, for example:

https://docs.google.com/spreadsheets/d/{HereIsID}

1 Like
6

Oh thank you very much @Javier_Diaz

I was using UiPath in Turkish. The translation was quite wrong so I couldn’t understand it hahaha

Thanks again!

7

Hey @Javier_Diaz,

I have one more question for you. I did as you said. I want to connect via URL but I get an error like this.

resim
resim1500×702 142 KB

Where is the problem? If you can help me, I would be very grateful.

Thanks!

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.