Parseur lets you easily send your data extracted from emails and documents to Google Sheets. Let's see how.
Note: this article assumes you already have created and configured your Parseur mailbox. Check out this page to get started if that is not the case.
You can follow the steps written below or in our tutorial video:
Step 1: Go to Export > Google Sheets
Exports to Google Sheets are very straight forward. By default, Parseur gives you 3 links to get your data in 3 different formats: Excel, CSV and JSON.
Fortunately, Google Sheets has a very handy formula named
IMPORTDATA() (see documentation) that takes a URL with CSV format and automatically imports it in a Sheet. This is the formula we are going to use.
We have already prepared that formula for you.
Go to Export, click on the Google Sheets tab and copy the formula using the button before the formula.
Step 2: Copy the formula to your Google Spreadsheet
Connect to your Google account
Go to your Google Sheets dashboard
Create a new Sheet (or open an existing one)
Paste the IMPORTDATA() formula we gave you in one of the sheets (typically in cell A1)
Wait for the data to finish loading
That's it ! Your data is now in Google Sheets.
Google Sheets will now be automatically updated every hour or so with new data processed by Parseur.
Step 3 (optional): Refining your data
Filter export by date
By default, Parseur will export all the data of your mailbox to Google Sheets. If you only want to get a subset of the data, you can use the filters by year, month and day on the export page.
Export Table Field data
If you use Table Fields, you will see that you have additional formula to use on the export screen.
The default document formula will create one row per document processed. Table field rows will be added as columns. This is usually not the desired result when having table fields.
The Table Field formulas will create one row per table field row processed. Non table fields will be repeated on each row. This is usually the preferred option.
Correctly format dates and numbers
Parseur lets you format Dates and Number fields.
For numbers, it will send number fields using a stop (
.) as decimal separator. If your Google Sheets is set in a locale that uses comma (
,) as separator, numbers may not be properly formatted.
For dates, it will send the data according to the format you indicated in your Default format preferences.
You can fix this by changing your Spreadsheet locale configuration.
To change your Google Sheets locale config:
open your spreadsheet
click on File
then click on Spreadsheet settings
in the drop-down for Locale, choose your own locale (for example, United States)
Step 4 (optional): Going further with Zapier
The default export is using
IMPORTDATA() and has a few limitations:
Data is not added in real time but refreshed every hour or so
You cannot change the order of the columns
You cannot add new columns to the right of the data (they will be overwritten at the next refresh)
Large amount of data can sometimes fail to load
If you find those limitations a problem, you can use Zapier to send your parsed data to Google Sheets. Using the Zapier integration to Google Sheets, you'll get:
Data added to your spreadsheet in real time
You'll be free to decide on the column ordering
You'll be able to add columns on top of the ones sent by Zapier
You'll be able to post process your parsed data in Zapier
If you would like to know how to connect Parseur to your Google Spreadsheet with zapier, check out this article.