Email Parser & Analytics

Rated 4.50 out of 5 based on 2 customer ratings
(2 customer reviews)

$ 0

 

Email Parser & Analytics is an add-on for Google Spreadsheets, that reads Gmail messages and adds them to Spreadsheets. It also can dig unique values from Emails, create charts for analytics and autoremove old rows.

Categories: ,

Description

Adds inbox and sent email into spreadsheet rows and creates charts to help analyze data. Automatically runs daily. + Premium version can parse additional data from your emails.

Live example: https://goo.gl/qNGXrz

How to start:

  • Open Add-ons menu, choose Email Parser & Analytics
  • Enable it and authorize if you still didn’t
  • In submenu Settings choose keywords to label your emails with (one per line)
  • Start it with Run Parser submenu

Parser will add last weeks emails to spreadsheet. And will add previous day’s emails daily automatically.

How to use premium parser:

  • Choose keywords to filter messages you want to parse data from
  • Set up regular expression, it will be used when the parser runs next time
  • Parser will add first occurency that matches regular expression

Examples of regular expressions:

  • Letters + :// + Alphanumeric ._- + . + Letters = URL parsed
  • Letters + . + Numbers + – + Numbers = XXX.111-11111 parsed
  • Alphanumeric ._- + @ + Alphanumeric ._- + . + Letters = EMAIL parsed

Data and privacy policy

This add-on works with your personal data – it requires full access to it to work properly. Upon installation you will be asked to provide this permissions to add-on:

How those permissions are going to be used

We will only use these permissions to run the above mentioned free and premium features of the add-on and to display you purchase options inside the app.

  1. Application will access your Gmail messages in read-only mode, that means – your emails will not be deleted, labled, answered, marked unread. They will only be collected to a spreadsheet.
  2. Application will use Send email feature to notify you about addon related issues and reports as well as to send Newsletter campaigns created by you.
  3. Application will have access to a spreadsheet where it was installed to add data from emails to it, and create and manage related pages and charts.
  4. Application will connect to external service – Google Analytics, which collects only anonymous software usage details related to source of your installation.
  5. Application additional pages will display third-party web content – button leading to Yandex Money payment system.
  6. Application will perform it’s duties daily at a set time-driven triggers, even if you are offline, as long as it is authorized to do so.
  7. We will ask for your email to provide you with premium features, if you purchase Premium.

We will not store your personal data, except for the email address, which is required for:
-notifications about application updates
-provision of paid additional features inside the application

We will not share your personal data that an Application will have access to with third parties.

 

2 reviews for Email Parser & Analytics

  1. Rated 4 out of 5

    Anton Karpov

    Regular expression builder is poorly designed, I would rather use it exactly the same way it is used in javascript or other programming languages. But I guess author decided it would be complicated for other users.

  2. Rated 5 out of 5

    Yung

    This plugins seems to have a better precision when parsing values, comparing to a Zapier’s one, which often provides wrong results.
    However, I would appreciate more options and an ability to disable data collection for sent emails, I don’t need that.

    Overall it’s a good piece of software that does it’s job well.

Add a review

Product Video