Retrieving Google Form Responses from Python - Struggling

46 views
Skip to first unread message

Pranav Menon

unread,
Sep 11, 2024, 11:46:37 AMSep 11
to Google Apps Script Community
Hi,

I am in the process of creating a google form through the google form API. These are the steps I have taken:

1. created a project here: https://console.cloud.google.com/apis/credentials/consent?project={project name} with the google forms api activated

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

Reply all
Reply to author
Forward
0 new messages