pd2gs

pd2gs — Simple tool to export pandas dataframes to google sheets.

Installation

Simply install with pip:

$ pip install pd2gs

Preparation (get credentials)

This package uses Google Drive API so you need to authenticate yourself via Google:
1. Go to Google Console (you should have an acoount) and create a project (or use existing one)
2. Enable Google Drive API in API Manager
3. Go to Credentials (API Manager) and select New Credentials > Service Account Key
4. After creating Service Account Key you download your credentials.json

Usage

This package is very simple:
1. You create your Google Sheet in Google drive and copy its Spreadsheet Id
2. Upload your pandas DataFrame to Google Sheets via ConnectGoogleSheet.write()

Code Example

import pandas as pd      
from pd2gs.pd2gs import ConnectGoogleSheet 

df = pd.DataFrame()         
sh = ConnectGoogleSheet('credentials.json', 'spreadsheet_key')    
sh.write(df)