Downloads RPA

Help Studio
, ,
1

Hello everyone, I’m learning about RPA, my automation downloads a file from Google, I would like to know how I can access this file on my machine for example, or how to send it to a database.

Captura de tela 2025-07-17 150840
Captura de tela 2025-07-17 1508401419×840 53.9 KB

2

Hello @kaio_valadao,

It depends on the file type.

For example, if it is an Excel file:

  1. Read the sheet of excel as Data table.

  2. And then loop through the data table and run update SQL query on the specific database.

If it is an PDF\Text\ Word file:

  1. Get the Text from the File - with appropriate activity (you will have to import packages to see them in the activities panel)

  2. Parse the text- apply regex or split by any delimiter (, or tab or space) and build a data table and add rows to it.

  3. And then loop through the data table and run update SQL query on the specific database.

Hope it helps

1 Like
3

So I actually need to get the download, it’s downloaded in chromium, but after that I don’t have access, how do I access this file on my computer? It’s an Excel spreadsheet

4

Hey @kaio_valadao
I see you’re currently downloading the file using browser interaction and the “Wait for Download” activity. A more reliable approach would be to use the Integration Service with the Google Drive connector.
You can use similar flow:

This image shows a successful execution flow for a sequence of tasks involving manual triggering, file downloading, path logging, workbook reading, looping through data rows, and message logging. (Captioned by AI)
This image shows a successful execution flow for a sequence of tasks involving manual triggering, file downloading, path logging, workbook reading, looping through data rows, and message logging. (Captioned by AI)780×582 25 KB

If you downloading file, the path you can get this way:

The image shows a graphical user interface for logging a local file path to an output, with a structured list of file attributes available under variables. (Captioned by AI)
The image shows a graphical user interface for logging a local file path to an output, with a structured list of file attributes available under variables. (Captioned by AI)922×601 26.2 KB

and use it in read range activity and then in for each loop to process the data row by row, e.g. to insert values into a database.
This image showcases a workflow automation interface with a sequence of tasks and highlighted settings for reading a workbook in the 'Read Range Workbook' action. (Captioned by AI)
This image showcases a workflow automation interface with a sequence of tasks and highlighted settings for reading a workbook in the 'Read Range Workbook' action. (Captioned by AI)2082×766 61.9 KB

5

@kaio_valadao

wait for download will have an output variable which is the file downloaded

variable.localpath will give the path to the file

if you want to use it in further activities the variable can be directly used

also if it is in drive then using integration service as @pikorpa said would be appropriate

cheers