Freelance projects

Freelance projects

Business Safe

Automation of data collection process from the web portal on n8n

Data Parsing, Enterprise Resource Planning (ERP) — incorrectly specified categories?

224 USD

Project translated automatically. Log in or register, to view the original

Automation of data collection process on n8n from a web portal and their organization in Google Sheets and Google Drive

Project name: Creating a bot for automating work with the Executive Proceedings Register and Google Workspace.

Project goal: Develop an automated solution for collecting data from the government portal, uploading related documents, and organizing them in Google Sheets and Google Drive.

Description of the process to be automated:

The bot should perform the following sequence of actions:

Process initiation: The bot is started manually.
Reading data from Google Sheets:
- The bot accesses the Google Sheet named "executive proceedings1".
- In the "Input" sheet, it retrieves data from two columns for each new task:
  - Registration number of the executive proceeding in the ASVP: (Column A)
  - Access identifier: (Column B)
Working with the web portal (web scraping):
- Navigate to the link: https://asvpweb.minjust.gov.ua/#/search-debtors.
- On the page, click the "Access to the executive proceeding" button.
- In the form that opens in a new tab, enter the data obtained from Google Sheets:
  - In the "Registration number of the executive proceeding in the ASVP:" field, enter the corresponding number.
  - In the "Access identifier:" field, enter the corresponding identifier.
- After successful authentication, proceed to data collection.
Collecting and processing data from the "List of decisions" tab:
- Switch to the "List of decisions" tab.
- Gather (parse) the following information from the page:
  - Full name of the executor handling the proceedings.
  - Date of each decision.
  - Name of each decision.
- Save the collected information to the "output" sheet in Google Sheets in the respective columns:
  - Executor handling the proceedings: (Column C)
  - Decision date: (Column D)
  - Executor's decision name: (Column E)
  - Add "Registration number of the executive proceeding in the ASVP:" (Column A)
Collecting and processing data from the "Other documents" tab:
- After completing work with the "List of decisions," switch to the "Other documents" tab.
- Gather (parse) information from this tab:
  - Document date.
  - Document name.
- Save this information to the "output" sheet in Google Sheets in the respective columns:
  - Document date: (Column G)
  - Document name: (Column H)
Working with Google Drive (creating folders and uploading files):
- In Google Drive, in the root folder named "ВП," create a new folder. The name of the new folder should match the value from the "Registration number of the executive proceeding in the ASVP:" field (for example, "76090046").
- Upload all documents from the "List of decisions" tab to the newly created folder on Google Drive.
- Upload all documents from the "Other documents" tab to the same folder on Google Drive.
- Create hyperlinks in the Google Sheets document names linking to the documents so they can be opened directly.

Proposals 12 Rejected 1 Discussions 1

Vitalii Bolkov

0 0

Projects -
Rating -
Rating 344

Budget: 100000 UAH Deadline: 7 days

Hello! 👋
I specialize in automation through n8n, integration with Google Workspace (Sheets + Drive), and creating custom bots. I am just starting to work with such complex systems, but I am very interested in taking on this task. We can agree on the budget individually depending on the scope of work and the pace of implementation.

🔍 What needs to be implemented:
Reading data from Google Sheets

Logging into the state web portal of ASVP using credentials

Scraping data from the "List of resolutions" and "Other documents" tabs

Saving structured information to the "Output" sheet

Creating folders on Google Drive by case number

Uploading found documents to the respective folders

⚙️ Technologies I plan to use:
n8n: for building a fully automated workflow

Google Sheets + Drive API: for integration with spreadsheets and cloud storage

HTTP requests or web scraping: for processing the Ministry of Justice website

Node/Python (if needed): if a separate module for complex scraping is required

📋 Implementation stages:
Setting up Google Sheets structure

Building logic for reading data and manually starting the bot

Working with the portal: filling out forms, navigating tabs, collecting information

Processing and saving results in the spreadsheet

Creating folders on Google Drive and uploading files

Checking stability, documentation, support

🧩 I am interested in working on this project because it combines working with n8n, integration, data, and automation well. I am ready to learn quickly on the go, communicate transparently, and provide interim results.

Ali Munzer

0 0

Projects -
Rating -
Rating 198

Budget: 10000 UAH Deadline: 7 days

Hello.
I specialize in such tasks — data collection, automation through n8n, working with Google Sheets and Drive.
I will handle the entire process: portal authorization, parsing decisions and documents, creating hyperlinks, everything according to the structure — as required.

I have done similar work before, I know all the pitfalls. It will be clear, stable, and without hacks.
Write — I will take this task and start.

Alexander Krys

32 0

Budget: 12000 UAH Deadline: 4 days

Hello. I can create a data collection script on Browser Automation Studio, Zennoposter. If you're interested - write, we will discuss.

Anastasiya Grishanovich

0 0

Projects -
Rating -
Rating 248

Budget: 9500 UAH Deadline: 2 days

Hello, I will gladly complete the project for you as soon as possible.

Hennadii Y.

32 0

Budget: 10000 UAH Deadline: 3 days

Hello!
Are you only considering n8n?
I can implement it with a Python script, contact me privately to discuss all the details.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Tetyana B.

1 0

Projects -
Rating -
Rating 524

Budget: 15000 UAH Deadline: 5 days

Hello,
I specialize in full-stack automation and have already created similar solutions using n8n, Google Sheets/Drive, and browser scraping. I can create an n8n bot for complete automation of your process. It will read data from Google Sheets, log into the ASVP portal, and gather all necessary information.

The bot will parse decisions and documents, save everything in the output sheet, and upload files to Google Drive.
https://freelancehunt.com/showcase/work/business-process-automation-expert-make-com/1957839.html
Folders will be created based on registration number. Each file will receive a clickable link in the table. I can handle any dynamic pages or pop-ups.

The final solution will be clean, well-documented, and easy to maintain or expand.

Vitaliy Makiv
Kyiv, Ukraine

Projects 31
Rating 5.0
Rating 4 982

Automation of data collection process from the web portal on n8n

Automation of data collection process on n8n from a web portal and their organization in Google Sheets and Google Drive

Vitalii Bolkov

Ali Munzer

Alexander Krys

Anastasiya Grishanovich

Hennadii Y.

Proposals are currently absent

Tetyana B.

Current freelance projects in the category Data Parsing

Online toy store on WordPress

Database parsing

It is necessary to parse a database of masters for keratin hair straightening, with phone numbers.

Integration of Solomono + SalesDrive: transferring UTM to orders

1C programmer