Google Form Automation Assessment

A script that programmatically reads user data from a local file and submits multiple google form responses automatically.

Installation & Running

1. Install dependencies (Python 3.8+ required):

   pip install -r requirements.txt

2. Download ChromeDriver matching your Chrome version and ensure it's in your PATH or the script directory.(You can skip this step if chrome is already downloaded on your system)

3. Run the automation:

   python automator.py

   or run

   python automator.py --headless

   to run the automation in headless mode

Input Data

• data.json: It contains the list of entries to submit, it is in the format below

[
    {
        "fullName": "Ada Lovelace",
        "email": "[email protected]",
        "country": "UK",
        "experience": "2 years",
        "comments": "Excited to participate!"
    },
    {
        "fullName": "Grace Hopper",
        "email": "[email protected]",
        "country": "USA",
        "experience": "8 years",
        "comments": "Looking forward to this opportunity."
    }
]

Output

• Screenshots , which serve as the proof of each submission are saved in the screenshots/ folder.

Improvements (if given more time)

Parallel Processing: For a very large number of submissions, we could easily consider using multiprocessing library to run multiple browser instances concurrently.

Entry id scraping Scraping to obtain the entry-ids themselves, would be a more scalable way that works for any kind of google form whatsoever, since we would be able to dynamically obtain the entry id for every single input field.

Input Type Scraping: Also still under the id scraping, i would find the corresponding input type for each entry id by using the xpath.