Automating Google Forms Submissions with Python

Key Takeaways

what's up guys welcome to another video and in this video i want to talk about this article i wrote called automating form submissions with python what i did here was i set up an automation to automate the process of filling in web forms using selenium and beautiful soup and i'm going to walk you through how to do that let's get started i turned my article into this kind of like slide presentation because i wrote it on jupiter notebooks which is pretty cool because now i can easily explain and go to the codes let's start by taking a look at well first we get the imports basic stuff the steps are going to be set up your answers as a csv file then we'll inspect necessary web elements by type of input and then we'll set up the url in the driver we'll access the web address we'll send the keys for the text-based inputs we'll send clicks for checkbox to type inputs and then access and click the submit button to finish and loop over the database and submit the answers for each user so let's get started so first things first we set up a i set up a easy simple google forms so that i can use it as a template generated data for the people using python's faker framework and then i said i put that in the database and you know now i have uh i have the data here um what i did is i inspected necessary web elements five type of input i go to the google forms link and i inspect each element to get what i need so that i can automate the process of filling in that platform so in this case i just went through the previous link of my google forms i had three questions and were two are tech space and one was multi-select so these were the web elements that i had to use after that i set up the the elements here so text quest text question element class check box question class submit element class which is great because now i can just set up the url and the driver this is the url for the form and this is the driver with where i set the executable path to my chrome driver for my machine and now let's go through then finally i access the web address and then i send keys for text-based inputs which looks a little bit something like this this is the function i wrote for doing i this is the answer name age so i get a name age text answers text questions and then i send the keys to send the answers using the driver and then i return the driver so that i can continue to go through the automations after that i send the clicks for checkbox inputs and here are the it's a color index dictionary for the different colors and then this is the function to insert the checkbox and then i return the driver again finally i access and click the submit button to finish that's how i do that that submit find element by xpath return to driver again and then i loop over the database and i submit the answers for each user so i have my database that i created with uh python's fake framework and now i just i'm just look over the database and submit the answers from that database i have my database i then loop through the user ids in the database and then i submit the answers and that's pretty much it python is a great way to experiment with different types of automations and different things that you can do so that you can be more productive either using browser or you know using your desktop in general and that's it cheers