This project demonstrates how to automatically fill a web form using Python automation, reading structured product data directly from a cloud spreadsheet.
The automation collects product information submitted through Google Forms, stores the responses in Google Sheets, and then uses Python to automatically submit this data into a web system.
This project was developed as part of my practical learning journey in Python, Automation, and Data Handling.
Many business workflows require manually transferring data from spreadsheets into web systems, which is repetitive and prone to human error.
This project solves that problem by building a Python automation script that:
- Reads product data directly from Google Sheets
- Iterates through each row of data
- Automatically fills out a web form
- Submits the product information without manual typing
The workflow integrates form data collection, cloud spreadsheets, and Python automation.
The first step of the process is collecting product information through Google Forms.
Users fill out a form containing fields such as:
- Product Code
- Product Brand
- Product Type
- Product Category
- Unit Price
- Product Cost
- Additional Notes
All responses are automatically stored in Google Sheets, creating a structured dataset ready to be processed by Python.
Instead of using a local CSV file, the automation reads the dataset directly from Google Sheets.
This means that:
- The dataset is always up to date
- No manual file downloads are required
- The automation can run using the latest data from the spreadsheet
The spreadsheet acts as a live database for the automation process.
The automation script was built using Python and simulates user interaction with the browser.
The script performs the following actions:
- Opens the browser
- Accesses the target web system
- Performs login
- Reads product data from Google Sheets
- Iterates through each row of the dataset
- Automatically fills the form fields
- Submits the product information
This eliminates repetitive manual work and ensures consistent data entry.
- Python
- Pandas
- PyAutoGUI
- Google Forms
- Google Sheets
python-form-automation
│
├── automacao.py
├── README.md
└── requirements.txt
The goal of this project is to demonstrate practical skills in:
- Python automation
- Data handling with Pandas
- Integration with cloud-based data sources
- Workflow automation
- Reducing manual repetitive tasks
This type of automation is commonly used in business operations, data pipelines, and process automation.
Possible improvements include:
- Replacing GUI automation with browser automation using Selenium
- Creating a scheduled automation pipeline
- Implementing error handling and logging
- Deploying the automation as a background job
Gabriel Godoi
🇧🇷 Brasileiro | Analista de Dados em formação
Atualmente, estou desenvolvendo projetos práticos utilizando Python, Análise de Dados e Automação para adquirir experiência real na área de dados.
🔗 LinkedIn
https://www.linkedin.com/in/gabriel-godoi-298005363
🔗 GitHub
https://github.com/gabrielgodoiii