Automate Google Form Filling Using Python and Selenium
Filling out forms manually is a tedious task, but with Python and Selenium, we can automate it in just a few steps! 🚀
Step 1: Create a Google Form
-
Head over to Google Forms and create a form similar to this:
-
Name (Short Answer)
-
Mobile Number (Short Answer)
-
Email (Short Answer)
-
Publish your form and copy the form URL (e.g.,
https://forms.gle/ZVKdhTJYqeHT4W1o6
). -
Open the form in Google Chrome.
-
Right-click on each input field, select Inspect, then right-click on the
<input>
tag and select Copy XPath. -
Save the XPath values for later use.
Step 2: Automate Form Filling with Python
Install Dependencies
First, install Selenium:
pip install selenium
Also, ensure you have the Chrome WebDriver installed and placed in your system's PATH.
Create form_fill.py
Open Visual Studio Code and create a file named form_fill.py
.
from selenium import webdriver
import time
# Initialize WebDriver
web = webdriver.Chrome()
web.get('https://forms.gle/ZVKdhTJYqeHT4W1o6')
web.maximize_window()
time.sleep(2) # Allow the page to load
# Fill out the form
sname = "RM.Chandrasekaran"
name = web.find_element('xpath', '//*[@id="mG61Hd"]/div[2]/div/div[2]/div[1]/div/div/div[2]/div/div[1]/div/div[1]/input')
name.send_keys(sname)
time.sleep(2)
mobile = "999999999"
mobil = web.find_element('xpath', '//*[@id="mG61Hd"]/div[2]/div/div[2]/div[2]/div/div/div[2]/div/div[1]/div/div[1]/input')
mobil.send_keys(mobile)
time.sleep(2)
email = 'abc@a.com'
emai = web.find_element('xpath', '//*[@id="mG61Hd"]/div[2]/div/div[2]/div[3]/div/div/div[2]/div/div[1]/div/div[1]/input')
emai.send_keys(email)
time.sleep(2)
# Click Submit Button
submit = web.find_element('xpath', '//*[@id="mG61Hd"]/div[2]/div/div[3]/div[1]/div[1]/div/span/span')
submit.click()
time.sleep(5) # Wait before closing the browser
print("Form Submitted Successfully! 🎉")
# Close the browser
web.quit()
Step 3: Run the Script
Simply run the script using:
python form_fill.py

And just like that, your form gets submitted automatically! 😎
Conclusion
Automating repetitive tasks like form filling can save time and effort. This method can be expanded for bulk form submissions or integrated with databases to auto-fill dynamic values.
Happy Coding! 💻✨
No comments:
Post a Comment