A guide to XTRF for Google Sheets Add-On

Have you ever wanted to transfer your XTRF Platform data to the external spreadsheet? XTRF for Sheets enables you to export your data stored in XTRF Language Business Platform to Google online spreadsheets where you can process them further.

In an easy and expedient way you can prepare the desired data view in XTRF Platform for Projects, Quotes, Vendors or Clients and transfer this data to the Google spreadsheet. In addition, you can strictly define which data you want to share with your associates and how the data should be displayed.

Want more? The exported data can be automatically refreshed in real-time, therefore each change made in XTRF Platform can be transferred to the Google spreadsheet immediately. The concept behind that is to make browsing data available in the external sheet where your associate only needs to have a link to the required view in the XTRF Platform and a generated access token.

Do your associates use their own tool while working on data? XTRF for Sheets is a perfect solution whenever your partner uses any external application to process data without gaining access to XTRF Platform directly.

Tired of the copy and paste options whenever exporting your data to Google documents? Not anymore with XTRF for Sheets. Exporting your data to the Google spreadsheets gives you an opportunity to export your data. Afterwards, you can enhance your data using any other external Add-Ons available in the Google Add-Ons library.    

The purpose of this guide is to present you how to:

  • Install the add on.

  • Generate an access token for a newly created abstract user account to set up a connection between XTRF Language Business Platform and Google Sheets.

  • Prepare a customized view in XTRF Language Business Platform with a list of data which you want to share with your associate.

  • Gather all information which should be transferred to your associate to allow displaying the required data in Google Sheets.

Synchronizing data

XTRF for Sheets is a tool that automatically synchronizes data between any Smart View pane and the Google Sheets platform. Using simple steps, you define the range of cells into which data are to be inserted and provide the URL of the Smart View pane from which data is to be imported (the URL is the address taken from the browser bar when displaying data in XTRF).

Many different views can be synchronized within one sheet simultaneously, and data can be synchronized on demand by means of the "synchronize all" option. A very useful option is automatic synchronization: with just one click you can switch the extension into a mode in which data is imported from XTRF automatically every hour, even if the sheet is not actually open in a browser window!

XTRF for Sheets 01

How to start

All that you need is access to the API in your XTRF installation. Then download XTRF for Google Sheets from THIS LINK and install it.

XTRF for Sheets 01

Your "add-ons" menu will now have the "XTRF for Sheets" option. After selecting "Import Smart View", a mechanism for synchronization with XTRF will appear on the right.


The configuration process is simple - you need only two items: API access token and a URL of a Smart View containing your data.

Access Token

To use, enter the "XTRF API access token" created in your XTRF user settings under the "Access token" tab. We encourage you to use a dedicated API user account instead of you own to access the API - detailed instructions can be found here.

Smart View URL

You can import data of any XTRF Smart View. When logged in to XTRF, simply copy the URL of the smart view from your browser and use it in XTRF for Sheets.

The detailed guide of SmartViews configuration is available here.

XREF for Sheets 02

Assuming you know how to manage Smart Views in XTRF, we mention only a few important aspects:

  1. The view needs to be accessible to the user for which an access token has been created. If you want to access the view of other user it has to be shared by this user (Use the Share option in the view configuration).

  2. You can use Custom Fields and Custom Columns (aka. Virtual columns) - they will be displayed correctly.

  3. Mind the formatting  - the date, currency and number formats you use in XTRF should match your settings in Google, so it can be understood correctly by Sheets (as values, not as simple text).

Multiple Configurations

You can now define further data sources by linking a Smart View pane in your XTRF instance with the Sheets cell address where the data is to be inserted.

The spreadsheet can contain as many data sources configured as required by your reports. If you do not need configuration anymore, use the Remove button available at the bottom in the configuration edit mode.

Automatic refresh

Your data can be always up to date. Simply enable automatic synchronization at the bottom of the screen and all the configuration will be automatically refreshed once an hour.

Token change

The token may be changed by using the "key" button at the bottom of the page. The token is shared by all configurations so your spreadsheet can access one XTRF instance at the time.

Dynamic URL's

To make your request to XTRF even more flexible, it is possible to change the URL to a Smart View on the fly right in the sheet. Here is how:

  1. Prepare your XTRF Smart View URL in a preferred cell of the sheet. You may use formula calculation rules and functions for regular sheet cells, so your resulting URL reflects your preference, i.e. you may limit the date range by applying current date as a filter value in the URL.
  2. Now, instead of using the URL in the connection configuration pane, set a Sheet!A1 notation reference to the cell containing the URL. The connector will be using the URL value from the sheet instead of the hard-coded one.

Price & Support

The add-on is available for free, however it requires enabled access to Home Portal API.

Seek assistance and contribute to discussions on this XTRF User Echo.

Read more

How can XTRF be connected to Analytics systems?

Selected Availability Experimental Feature

This article was helpful for 5 people. Is this article helpful for you?