/MySQL-to-GoogleSheets-Python

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

Primary LanguagePythonMIT LicenseMIT

Export MySQL query data to GoogleSheets using Python

Project website: https://know.tirth.dev/MySQL-to-GoogleSheets-Python/

Description

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

Prerequisites

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 the API 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 select APIs & services.
    4. On the left, click Credentials.
    5. Click New Credentials, then select OAuth client ID.
    6. Select Web 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 clicking Consent Screen. You won't be prompted to configure the consent screen after you do it the first time.
    8. Click Create client ID
    9. Download the newly created oAuth2.0 client id as JSON
    10. Put the json file in src folder with name credentials.json

    Refer this for more help.

How to use this script

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

If you are facing any issues with the script, you can email me at contact@tirth.dev