'Pulling data from a Google drive sheet for account creation on third party site

I am looking to automate account creation for employees at my work.

I have a Google sheet with 5 columns of data that need to be applied to the site I am using to create accounts.

Email, username, Full Name, and Type (either A or B)

I have created a simple script in Selenium to confirm I can create accounts on the site without bot detection shutting me down.

What I need to do now is pull he data from the google sheet and apply it to the user creation page on the site.

How would I go about doing this with Selenium and Python?

I am about 3 hours into my first python course and have used selenium to update text fields on websites before.

Thanks in advance for the help!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source