GET STARTED
CONTACT US – 319-294-6671

Inserting Google Sheets Data with the Google Sheets Data widget

Google has made changes to their API that has caused the Google Sheets Data Widget to function differently. An update has been released, and the widget is now better than ever.

 

In your Sheet, go to File > Share>Share with others

 

 

 

 

 

 

 

 

 

 

 

 

Change the access permissions to Anyone with the link. Then click the [Copy link] button here, or copy the URL from your address bar. Click [Done] to close out of the sharing settings.

 

 

 

 

 

 

 

 

 

Now paste the URL into the Sheet ID or URL field of the Arreya Google Sheets Data widget.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Input which cell you’d like to pull data from, and press [OK]. A widget will now be inserted with your Google Sheets data.

Inserting a Google Slides slideshow with the Google Slides Slideshow widget

 

In your Google Slides slideshow, go to File > Publish to the Web…

Go to the Embed tab, set Auto-advance slides to your desired amount of time. Check the boxes for Start slideshow as soon as the player loads and Restart the slideshow after the last slide and click Publish

Now copy the entire embed code from the box and paste it into the Embed Code field in Arreya

Change Time Zone Settings on a Chrome Device

Configuring the time zone settings on a Chrome device is done in the Google Admin Console.  Settings are determined by the OU that the devices are apart of.  For help managing device settings, read this google article.  Specific information about Chrome device time zone settings can be found here.

 

Chrome Device time zone options:

  • No policy set – This is the same as ‘Let users decide’
  • Let users decide – Users can control the policy through standard Chrome OS Date and Time settings
  • Never auto-detect time zone – Users must manually pick a timezone.
  • Always use coarse time zone detection – Uses the device IP address to set the timezone.
  • Always send WiFi access-point to server while resolving time zone – Uses the location of the WiFi connection to set the time zone.  This is the most accurate option.

Inserting a calendar with the Google Calendar Widget

Google Calendar widget:

  1. From your Dashboard go to [Content] -> [Presentations]
  2. Click edit next to the presentation you would like to change
  3. Click [Widgets] near the top left and select [Google Calendar] from the dropdown
  4. Enter the ID* from the calendar to be displayed
  5. Choose the view style and your preferences for the remaining options
  6. Click [Ok] to continue
  7. The new widget will appear in the middle of the presentation
  8. The widget can now be moved, resized, or edited just like any other widget
    1. Click and drag the center of the widget to move the widget
    2. Click and drag an edge or corner to resize the widget
    3. Click on the paintbrush to edit font, text color, text size, and much more

*Locating the Google Calendar ID

1.  Navigate to Google Calendar.

2.  Click the Settings.

3.  On the left hand side you’ll see a category labeled Settings for my calendar.  From there, click on your calendar name.

  

4.  Once you have clicked on your Calendar name, click on Access permissions.  In Access permissions make sure there is a checkbox in Make available to public.

5.  After checking the above box, go to Integrate calendar and copy your “Calendar ID”

Embedding a map with the Google Maps widget

Google Maps Widget:

  1. From your Dashboard go to [Content] -> [Presentations]
  2. Click [Widgets] near the top left and click [Google Map] from the drop-down
  3. Enter in a zip code, address, city, state, province, or latitude and longitude, or click the button to find your current location
  4. Drag the zoom slider to adjust the zoom level of the map, showing more or less of the surrounding area
  5. Select the type of map you would like to use and click [Ok]
  6. The new widget will appear in the middle of the presentation
  7. The widget can now be moved, resized, or edited just like any other widget
    1. Click and drag the center of the widget to move the widget
    2. Click and drag an edge or corner to resize the widget
  8. Click the purple brush icon below the Google Map widget to open the style settings, just like any other widget
    1. In the style settings there are options for transparency, borders, shadows, and more
    2. When finished, click [Ok]
  9. If you want to adjust the widget after adding it to the page, click the purple gear icon below the widget to open the settings menu.
  10. If you need additional Google Map widgets, you can add additional maps from the [Widgets] menu and repeat these steps
  11. When you are finished, click the green [Push Live] button to update your presentations