Intro

GlobalReader Google Connector is designed for a simple way to export reports data from GR system to Google Sheets. The connection can be a one-time data export or scheduling the exports. Other possibility is to import planned Order list to GlobalReader for micro-planning in Planner or for Operator feedback Operator (Shopfloor Feedback)

Installation

  1. Open a blank Google Sheets document or Sheet

  2. Install GlobalReader Connector. Open menu Extensions →Add-ons → Get Add-ons.

    Untitled

    Search for GlobalReader and Install. Allow the requested access rights.

    Untitled

  3. Open the GlobalReader Connector from menu Extensions → GR connector → Open

    Untitled

Set up the Google Connector

  1. Open the GlobalReader Connector from menu Extensions → GR connector → Open

  2. Insert your GlobalReader API token. If you don’t have a token, then please contact GlobalReader support ([email protected])

    Untitled

  3. Select your timezone. Note: all dates and times in the resulting export will be in the selected timezone.

  4. Click Connect

Use-case 1. One-time data export

  1. On Reports tab select a Report
  2. On Reports tab select a Device(s)
  3. On Reports tab select a time period Start and End
  4. On Fields Tab specify the output Columns