This is an experimental library to deal with Google Analytics Measurement Protocol and Google Spreadsheet.
Once you've installed this library into your python environment, you can get data from Google Spreadsheet and send those data to Google Analytics with Measurement Protocol.

• Python 3+ (Would work with Python 2.7+, but it's not been tested.)
• Google Spreadsheet
• Google API's service account secret json.
  • You will be required to create "service account" which enable you to access Google APIs. For this library, you also need to have service account keyfile in JSON format.
    Please take a look at following document to get service account keyfile.
    • Google Identity Platform
    • Google Sheets API - Python Quickstart

pip install git+https://github.com/yukoga/mpdemo.git

mpdemo module support for sending pageview and event hit by send_pageview() and send_event() method. Here is sample implementations.

from mpdemo.tracker import Tracker

# Instantiate tracker object.  
tracker = Tracker(tracking_id='UA-XXXXXXX-YY', output=True)

# send pageview.
params = {
  'cd1': 'This is custom dimension 1 value.',
  'cg1': 'Measurement Protocol parameters other thatn cid and dp is set as params.'
}
tracker.send_pageview(client_id='12345.67890',
                      page='/some/page/path.html', params=params);

# send event
params = {
  'cd1': 'This is custom dimension 1 value.',
  'cg1': 'Measurement Protocol parameters other thatn cid and dp is set as params.'
}
tracker.send_event(client_id='12345.67890',
                   category='offline tracking',
                   action='store visit',
                   label='store name',
                   value=10000,
                   params=params);

The sample script ( example/send_mp_from_spreadsheet.py ) is used for demonstration which send Measurement Protocol based on data stored in Google Spreadsheet.

To use sample script ( example/send_mp_from_spreadsheet.py ), you need to follow below steps.

1. Get service account credentials in JSON format from Google API service account page.
   For more details, take a look developer guide for Google Identity Platform
2. Download sample script from https://raw.githubusercontent.com/yukoga/mpdemo/master/example/send_mp_from_spreadsheet.py and locate it into a directory where service account keyfile exists.
3. Set your own value into the following parameters in the sample script.
   • TRACKING_ID : Google Analytics property ID.
   • SHEET_URL : Google Spreadsheet URL.
   • RANGE : Spreadsheet range which contains data to be sent to Google Analytics by Measurement Protocol.
   • KEY_FILE : service account keyfile path.
4. Execute sample script as follows:
   • python send_mp_from_spreadsheet.py

This sample script can send any data on Spreadsheet specified by RANGE parameter, but it should have following format as required.

• Column A is assigned for last update timestamp which is populated by send_mp_from_spreadsheet.py.
• The row just above data should contains Measurement Protocol parameter name like cid, dp ... etc.

Take a look at this example spreadsheet.