Skip to main content

ETL for Parature emails routed to Gmail account

Project description

# Parature Gmail Feed
## Description
The Parature Gmail Feed:
* Retrieves emails cc'd to a Gmail account originating from Parature
* Extracts Parature specific content from each email
* Creates a record from the extracted content
* Loads the record to a MongoDB database

## Installation
Install with pip
pip install paraturegmailfeed

**Project requires MongoDB**

[See MongoDB documentation for installation instructions](

## Getting Started
### Setting up your config file

Create a new .py file. For example ``
# Gmail API Variables
CLIENT_SECRET_FILE = 'Exported from your Google application account'
SCOPES = 'Scopes for your Google application'
APPLICATION_NAME = 'Name of your application'


TARGET_LABEL_QUERY = 'The label name '

# MongoDB Variables

### Example of usage:
from paraturegmailfeed import ParatureGmailFeed

def main():
feed = ParatureGmailFeed('')

### Running for the first time
Be sure to have `mongod` running.

You will be prompted to authorize the application to access your Gmail account.
After accepting, the application will run automatically.

[See official documentation for assistance](

## Design Decisions
### Why MongoDB?
* Flexible schema. As requirement grow/change the data schema can to!
* Native functionality. Simple upserts (unlike most SQL databses).

### How are duplicate records prevented?
* Gmail API message query is restricted to all messages that do NOT have the "Processed" label.
* The pymongo `update_one` method is used with the `upsert` option. This means that if a record already exists based on the composite key (ticket number and timestamp) the action will simply update the record (essentially do nothing).

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for paraturegmailfeed, version 0.65
Filename, size File type Python version Upload date Hashes
Filename, size paraturegmailfeed-0.65.tar.gz (5.7 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page