Repository files navigation

Executes a query on MySQL database, gets the data, creates a tab in a Google Sheet and dumps the data there

To run this package, you'll need:

1. Python 2.6 or greater

2. The pip package management tool

3. MySQL connector for python
   You can install it by executing below command

   pip install mysql-connector-python

4. A Google account which has edit access to the sheet you are trying to modify

5. Google Client Library
   You can install it by executing below command

   pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib

6. Client secret JSON file
   You will need this file to access your Google Sheet
   In order to get one, Follow below mentioned steps

   1. Go to theAPI Console.
   2. From the projects list, select a project or create a new one.
   3. If the APIs & services page isn't already open, open the console left side menu and selectAPIs & services.
   4. On the left, clickCredentials.
   5. ClickNew Credentials, then selectOAuth client ID.
   6. SelectWeb application as application type for your project
   7. If this is your first time creating a client ID, you can also configure your consent screen by clickingConsent Screen. You won't be prompted to configure the consent screen after you do it the first time.
   8. ClickCreate client ID
   9. Download the newly created oAuth2.0 client id as JSON
   10. Put the json file in src folder with namecredentials.json

   Referthis for more help.

1. Follow instructions inautomate.py
2. After you have made all the required changes
3. Open terminal in the project directory and execute below command

   python automate.py