Your customers are submitting their data to your google sheet.

1. Make a note of the column name that contains the email addresses. The name comes from what you used in the Google form.


Objective

Retrieve the emails from your google sheet as a Python list inside your main.py


Technical requirements

You should make changes to your data_manager.py, your main.py and your .env file.

* Add your endpoints for your "prices" and your "users" sheets to your .env file.

* Add a method called get_customer_emails() to your data_manager.py. This should return the data on your "users" spreadsheet.

* Update the __init()__ method so that you retrieve all the environment variables in one place. This should include things like your SHEETY_USERNAME , your password, but also your endpoints.


In the next step we'll send out emails to all our customers that we've retrieved from the Google sheet!



SOLUTION