How to get Google sheet data Through HTTTp request activity

Help Activities
1

Hi RPA Team,

I have nearly 1 lakh rows in a Google Sheet with around 12 columns. When I try to download the data using the Gsuite Download File activity, I receive an error stating that the data size is too large.

Could you please help me understand how we can retrieve this data using an HTTP Request instead?

Regards,
Manoj.

2

@manojmanu.rpa Please try below:

  • Use HTTP Request to call the Google Sheets API
  • Read the sheet values in chunks/ranges instead of pulling everything at once
  • Append the results into a DataTable / file in UiPath
    e.g-

GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{sheetName}!A1:L10000

Then repeat for the next ranges:

A10001:L20000
A20001:L30000