2. I have created a google form with the questions i would like to ask.
The issues begin here:
1. I am unable to see this google form in my forms location on my google account. The only way i can access it is by running the below code and clicking on the resulting url. Why can't i see the resulting google form on my google account?
form_metadata = form_service.forms().get(formId=FORM_ID).execute()
print(form_metadata)
print(form_metadata['formId'])
print(form_metadata['responderUri'])
2. I am able to fill out the form but am not sure how to retrieve the answers to the form? When looking online its says i need to also connect to the google sheet associated with the form but i am unsure how to do that.
Just to review, i have created a google form that i can only access through a url in python and i do not know how to access the answers to the form.
Here is the code i used to create the form (create_from.ipynb), update the form as needed (update_request_api.ipynb), delete certain parts (delete_request_api.ipynb) and my attempt at retrieving answers (retrieve_responses.ipynb)
Happy to chat and get this figured out. I'd hate to give up given how far i've come