Google Sheets

View on Github

This script allows you to import AT Internet data within Google Sheets.
Once you've installed the script, you are able to call any Reporting API feed.
Please note that you have to have an AT Internet account to query the API.


If you were used to use AT Internet data within Excel but fed up with the .iqy files, you'll be thrilled to use this script to manipulate the AT Internet data within Google Sheets.

Getting started

You can download the script with the download button down below, if you want to propose improvements you can push new contents on the GitHub repository here.



Import AT Internet data to Google Sheets

This script allows you to import AT Internet data to Google Sheets.


In order to install it, follow these steps:

  1. Open your Google Sheet, and go to Tools > Script editor…
  2. Create a new script (File > New > Script file) and paste the code from to it, and save the script
  3. Go back to your sheet (it should reload). You should see a new menu on top (next to Accessibility), called AT Internet
  4. Click on AT Internet > Login, you’ll get permission alerts – accept it, and connect to your Google account (this is because the authentication data are linked to your Google account)
  5. Enter your AT Internet email and password when prompted, and confirm

You are now connected to your AT Internet account on this Google sheet. In order to logout, just click on AT Internet > Logged in as …


In any cell of your sheet (this will be the top-left cell of the imported data table), use this formula:


8 reviews for Google Sheets

  1. Alexander Grießer

    This sounds like a great idea. However, the login does not work for me.

    All I get is: “Error
    SyntaxError: Expected : found , (line 126).”

    • bdiolez

      Hello, I just pushed a new version. This should fix your issue!
      Thanks for reporting it.

    • bdiolez

      Hello, I just pushed a new version. This should fix your issue!
      Thanks for reporting it.

  2. Merino

    It seems perfect seems I had enough of iqy in excel. However there is no reload of the sheet and no new menu on top (what’s missing ?) thanks

    • rbalangue

      Hi Pilar,
      Have you managed to reload the Sheets to get access to the new menu?

  3. Chen

    Is it possible to read input values from the google sheet? e.g.{d_time_year,d_time_month,cl_377912,m_page_loads}&sort={d_time_year}&space={s:512345}&period={D:{start:'[“Start”,”Please enter a start date in the format YYYY-MM-DD”]’,end:'[“End”,”Please enter an end date in the format YYYY-MM-DD”]’}}&max-results=1000&page-num=1&sep=dot

    • rbalangue

      Hi Chen,
      I guess it is, we will add this to our to-do list.

  4. Prescillia Dethelot

    I put my API url but when i want executed the code this message appear “Paramètre formel manquant. (ligne 165, fichier “Code”)Ignorer”

    • rbalangue

      Hello Priscillia, would you be able to share your document with Thanks.

  5. Christiane

    Thank you for this evolution . But I met some problems with it :
    The script worked very well yesterday, over a fixed period of time:
    period={D: {start:’ 2018-02-19′, end:’ 2018-03-10′ }}

    But this morning, several queries were displaying an #ERREUR message as
    “an internal error prevented the execution of the function”.

    I tried to reload the google sheet, to reload each call, to log out, to relog in.
    It wasn’t working.
    Then I changed the period : period={D: {start:’ 2018-02-19′, end:’ 2018-03-11′ }}.
    This made it possible to load some requests but not all of them.

    Then i cut each API call from each cell, without changing anything in the query.
    And i re-pasted each one. it worked.
    I guess there is an issue of “cache” refresh ?
    Any idea ?

    This script is not far from being completed for a first data sharing.
    thank you for your return.

  6. Ana


    I always receive the same error message while trying to execute a request in Google spreadsheet :

    Request failed for'2017-09-18'%2Cend%3A'2018-07-02'%7D%7D&max-results=50&page-num=1 returned code 401. Truncated server response: {“ErrorCode”:1001,”ErrorMessage”:”Incorrect login or password”} (use muteHttpExceptions option to examine full response). (ligne 159).

    Even password & login are ok.

  7. Pilar

    me too ! besides it doesn’t work every time we opne the file. Even password & login are ok.

Add a review

Your email address will not be published.

This field can't be Empty
This field can't be Empty
This field can't be Empty
This field can't be Empty