Google Docs offers API integration, allowing companies like North Data to display their data straight onto a Google Sheets spreadsheet. This feature can be extremely useful in many ways, especially if you would like to enrich your database with the data provided by us. In this article, we will walk you through a step-by-step tutorial on how to enable this feature.
We understand that our customers consume our data in different ways. That’s why we would like to show you an alternative way to make the most of the data we provide. Google allows scripting within the Google Docs applications, making it possible for companies to link their database to Google via API. For instance, this will enable data to be transferred straight from its source into a Google spreadsheet.
For our customers, this means jumping into the driver's seat and steering our data as they wish. For example, you have a Google spreadsheet with a list of companies. You would like to know the number of employees and revenue of each company. With just a few clicks, your spreadsheet will be updated with fresh company data straight from North Data's database.
We have prepared an easy-to-understand tutorial describing every step you need to take to display our data on your Google Sheets spreadsheet. Here is what you need to do to make the most of this feature:
You now have two ways to access our data in your spreadsheet:
Option 1: With your own template
The first column (A) must contain the name of the to be searched company. The second column (B) must have the corresponding city of that company. These two columns are paramount for our database to understand your inquiry, as the company's name and the city are the keys to the information you need. Here is how it should look:
Now that you already have the keys to finding the data, you can specify the KPIs you would like to visualize. Ensure you use the exact spelling from the table below, or the script will not work correctly. The available KPIs are the following:
Fields in English |
Fields in German |
Status |
Status |
Register |
Register |
Address |
Adresse |
Lei |
Lei |
Phone |
Telefon |
Fax |
Fax |
|
|
Website |
Website |
VAT Id |
USt.-Id. |
Industry Code |
Wirtschaftszweig |
Total assets |
Bilanzsumme |
Earnings |
Gewinn |
Revenue |
Umsatz |
Return on sales |
Umsatzrendite |
Equity |
Eigenkapital |
Equity ratio |
EK-Quote |
Return on equity |
EK-Rendite |
Employee number |
Mitarbeiterzahl |
Revenue per employee |
Umsatz pro Mitarbeiter |
Taxes |
Steuern |
Tax ratio |
Steuerquote |
Receivables |
Forderungen |
Liabilities |
Verbindlichkeiten |
Pension provisions |
Pensionsrückstellung |
CEO |
Vorstandsvorsitzender |
Managing Director |
Geschäftsführer |
For instance, if you would like to have North Data's address and status in your spreadsheet, here is what it should look like:
After the columns with the desired KPIs have been added to your document, retrieve the data by selecting one of the “update” options on the “North Data” tab in the menu:
After selecting one of the “update” options, a message “Running Script” will appear. Once the action is completed, your spreadsheet will be updated with fresh company data straight from our database.
Option 2: Premade Template
On the North Data tab in the top menu, select “Premade Template’. The script will run and load our template onto your spreadsheet. The first two columns will automatically populate with example companies (column A) and cities (column B). Replace these with the companies and cities you want to search. On the North Data tab, select “update all.” Our script will again run and update your spreadsheet with the KPIs you need.
If something is wrong with the script (e.g., API key input incorrectly, script not pasted entirely, etc.), the following error message will appear:
In this case, go back to step 2 and check if you have replaced Google`s placeholder script with the North Data script completely. Then go to step 5 and check that you entered the API Key correctly.
Don’t forget to follow these basic rules when creating or editing your spreadsheet so that the data can be retrieved from our database successfully:
If you would like to know more about our Data Services, just send us an email at info@northdata.com or reach out to us by clicking on the button below.