Help & Support
Send Feedback
Gmail to Spreadsheet
Adds inbox and sent email into spreadsheet rows and creates charts to help analyze data. Automatically runs daily. + Premium parser.
13 users
Works with
Install
Overview
Example output: https://goo.gl/qNGXrz

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

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 email when the day is over.

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

Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu