Vietnamese version here
Someone send us a Google-form, and we need to fill it everyday or maybe every hour to report something. It seems to be boring, so I just think to write a script to automate the process using Python 3
This is a simple and lightweight script to automatically fill and submit a Google form with random data. The script is customizable, allowing you to fill the form with the data you need.
It's also include a request body generator for those who prefer to manually input data, you can simply copy and paste a 8000 Google form URL, eliminating the need for manual inspection.
This document will guide you through the process of creating a Python script to automatically fill and submit a Google form.
- Supports multiple pages Google forms
- Supports Google Forms that collect email addresses (Responder input)
- Automatically generates the request body using the
form.pyscript - Auto-fills the form with random values (customizable) and submits it
- Python 3.x
requestslibrary (pip install requestsorpip install -r requirements.txt)
If you only want to fill and submit a Google form with random data, or customize the script to fill the form with the data you need, you can skip to the AutoFill and Submit section.
Below are the steps to create a Python script to fill and submit a Google form. If you want to skip the manual inspection step, you can use the form.py script to automatically generate the request body (as described in the Extract information Automatically section).
The URL of the Google form will look like this:
https://docs.google.com/forms/d/e/form-index/viewform
Just copy it and replace viewform to formResponse
https://docs.google.com/forms/d/e/form-index/formResponse
Just copy the Google form URL and run form.py script. The script will return a dictionary which contains the name attributes of each input element and the data you need to fill out.
python form.py <your-gg-form-url>The result will be printed to the console (by default), or saved to a file if the -o option is used.
For more information, please use the help command
python form.py -hExample:
python form.py 'https://docs.google.com/forms/u/0/d/e/1FAIpQLSdwcwvrOeBG200L0tCSUHc1MLebycACWIi3qw0UBK31GE26Yg/formResponse' -o results.txtOpen the Google form, then open DevTools (inspect) for inspecting the input element.
Each of the input elements which we need to fill data has format: name = "entry.id"
Try to fill each input box to know its id
- If the form requires email, please add the
emailAddressfield - For multiple pages forms, please add the
pageHistoryfield with a comma-separated list of page numbers (starting from 0). For example, a 4-page form would have"pageHistory": "0,1,2,3"
Create a dictionary in which keys are the name attributes of each input element, and values are the data you need to fill out
# example
def fill_form():
name = get_name_by_day()
date, hour = str(get_gmt_time()).split(' ')
date = date.split('-')
hour = hour.split(':')
if (int(hour[0]) < 10):
hour[0] = hour[0][1:]
value = {
# Text
"entry.2112281434": name,
# Dropdown menu
"entry.1600556346": "Sài Gòn",
# Date
"entry.77071893_year": date[0],
"entry.77071893_month": date[1],
"entry.77071893_day": date[2],
# Hour
"entry.855769839": hour[0] + 'h',
# Checkbox
"entry.819260047": ["Cafe", "Fences"],
# One choice
"entry.1682233942": "Okay"
}
print(value, flush = True)
return valueJust use POST method in requests
def submit(url, data):
try:
requests.post(url, data = data)
print("Submitted successfully!")
except:
print("Error!")
submit(url, fill_form())Done!!!
Run the main.py script with the Google form URL as an argument to automatically fill and submit the form with random data
python main.py <your-gg-form-url>For example:
python main.py 'https://docs.google.com/forms/u/0/d/e/1FAIpQLSdwcwvrOeBG200L0tCSUHc1MLebycACWIi3qw0UBK31GE26Yg/viewform'Use -r/--required to only fill the form with required fields
python main.py 'https://docs.google.com/forms/u/0/d/e/1FAIpQLSdwcwvrOeBG200L0tCSUHc1MLebycACWIi3qw0UBK31GE26Yg/viewform' -rThe main.py script is a simple example of how to use the form.py script to automatically fill and submit a Google form. You can customize the fill_form function to fill the form with the data you need.
Please note that this script currently operates only with Google Forms that do not require user authentication.