Python-Project/Auto_fill_Google_Forms.py at main · sinistergeek/Python-Project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
import csv
import time
from selenium import webdriver
from selenium.webdriver.common.keys import Keys

inputName = '/html/body/div/div[2]/form/div[2]/div/div[2]/div[1]/div/div/div/div[2]/div/div[1]/div/div[1]/input'
inputEmailID = '/html/body/div/div[2]/form/div[2]/div/div[2]/div[2]/div/div/div[2]/div/div[1]/div/div[1]/input'
inputPhone = '/html/body/div/div[2]/form/div[2]/div/div[2]/div[3]/div/div/div[2]/div/div[1]/div/div[1]/input'

Submit = '/html/body/div/div[2]/form/div[2]/div/div[3]/div[1]/div/div'

browswer = webdriver.Firefox(executable_path='C:\geckodriveer-v0.28.0-win64\geckodriver.exe')
browswer.get('https://docs.google.com/forms/d/e/1FAIpQLScBejWF809oacjZlvkciXREi50fyHcq751988KDJo3ycG7xkg/viewform')
name = []
email = []
phone = []

with open("input.csv","r") as f_input:
    csv_input = csv.DictReader(f_input)
    for row in csv_input:
        name.append(row['name'])
        email.append(row['email'])
        phone.append(row['phone_number'])
i=0
while i < len(name):
    browser.find_element_by_xpath(inputName).send_keys(name[i])
    browser.find_element_by_xpath(inputEmailID).send_keys(email[i])
    browser.find_element_by_xpath(inputPhone).send_keys(phone[i])
    sleep()
    browser.find_element_by_xpath(Submit).click()
    i+=1
    sleep()
    browswer.back()
    sleep()
browswer.quit()