Google Sheets > Vibe Integration

Google Sheets > Vibe Integration

Vibe's Google API module helps you to connect your Google Sheets data to your Vibe digital signage.

Step 1 - Google API project setup

Create a Google Cloud project

  1. Go to https://console.cloud.google.com/projectcreate
  2. Enter Vibe fyi integration as the project name, and make sure that an organization and location are selected
  3. Click [Create]

Enable Google APIs

  1. Go to https://console.cloud.google.com/apis/library
  2. Search for Google Drive API
  3. In the search results, click the first result, and click [ENABLE]
  4. Next, search for Google Sheets API and repeat step 3
  1. Go to https://console.cloud.google.com/apis/credentials/consent
  2. Set the project as an "external" app and click [Create]
  3. In the OAuth Consent Screen page...
    1. Enter Vibe.fyi as the app name, and select an email address as the user support email
    2. Under Authorized Domains, click [Add domain] and enter your vibe.fyi portal URL (assuming that your portal’s domain name is _____.vibe.fyi)
    3. Enter support@vibe.fyi as the developer email address 
    4. Click [Save and continue]
  4. In the Manually Add Scopes page...
    1. Click [Add or remove scopes]
    2. In the Manually Add Scopes input, enter https://www.googleapis.com/auth/spreadsheets and click [ADD TO TABLE]
    3. Make sure that "../auth/spreadsheets" is ticked, and click [UPDATE]
    4. Click [Save and continue]

Create Credentials

  1. Go to https://console.cloud.google.com/apis/credentials
  2. Click [Create credentials] and select oauth client id
  3. In the Application type dropdown, select web application
  4. In the Name field, enter your site's name or URL
  5. Under Authorized Javascript Origins, click Add uri and enter your site's domain name (including https) 
  6. Under Authorized redirect URLs, click Add uri and enter a URL (e.g. use your site's domain name https://{example.vibe.fyi}/Modules/GoogleApi/Authenticate.ashx)
  7. Click [CREATE]
  8. Next, send your client ID & secret to support@vibe.fyi or login to your Vibe admin console and enter the details in the Google API global module settings
Alert
Please wait at least 10 minutes before proceeding to step 2 below

Step 2 - Connect your Google Account

  1. Login to your admin console
  2. Open Developer Tools > Modules > Global Module Settings
  3. Open Google API
  4. Use the [Authenticate New User] option to authenticate one or more Google Accounts
Idea
If your browser has a pop-up blocker, please adjust the settings to allow the 'Google sign in' page to load.

Step 3 - Link to your Google Drive folders

  1. In Google Drive, open the folder (where your sheets will be stored) and copy the folder ID in the address bar
  2. In the Vibe.fyi admin console
    1. Open Developer Tools > Modules Global Module Settings
    2. Open Google API
    3. Paste the folder into the Google Drive Folder IDs field
  3. Repeat steps 1 & 2 as needed

Step 4 - Prep your Google Sheets 

Create your Google Sheet using a Vibe data template

1) Create your slide and download the Vibe data template
  1. In your Vibe portal, create a new slide and select the template that you'll be using to share your Google Sheets data
  2. In the slide editor, select the 'File Upload' content source option to access the data template (XLSX)

2) Upload the Vibe data template to Google Drive and save it as a Google Sheet
  1. In Google Drive, upload the data template (XLSX) file into one of your connected Google Drive folders
  2. Open the data template (XLSX) with Google Sheets and save it as a Google Sheet
  3. Return to your Google Drive folder and delete the XLSX file
  4. Open the saved Google Sheet and edit as needed

Idea
Use these tips to help you finalise your google sheet - Data Entry and Data Templates.
Alert
When you have finished editing, check all sheets in the data template and delete all empty colums and rows.

Wait 30 minutes
* before you proceed to step 3. *This wait time can be adjusted in the admin console - refer to Caching.
3) Connect your Google Sheet to your slide
  1. In your Vibe portal, open the slide created in step 4.1 above
  2. Select 'Google Sheets' in the Content Source dropdown
  3. Select the file that you want to use to manage your content in the Google Spreadsheet dropdown

Data Entry

Empty cells

Empty columns and rows affect the API's ability to pass data from your google sheet file to Vibe. Please ensure that you delete all empty columns and rows to avoid errors occurring.
  1. In Google Drive, open your google sheet
  2. Select all empty columns and delete
  3. Select all empty rows and delete

Alert
If this error occurs while attempting to delete empty rows, open View > Freeze and select No Rows. Then retry the deletion steps.

Images

Valid URLs can be used to add images via your Google Sheet. We highly recommend hosting images locally on your website, a secure site or an FTP folder with 'Read' permissions.
To link to an image URL, enter =image("<add URL between quotations>") in the cell.

Caching

The 'Minutes to cache Google API calls' global setting determines how long it takes for documents and changes within the linked Google Drive folder(s) to be updated.
To edit the minutes to cache setting, open Developer Tools > Modules > Global Module Settings > Google API in your admin console.


    • Announcements

    • Available Now: Sports Tournament Infotainment

      Get ready for the Women’s Rugby World Cup! We’ve updated our Sports Tournament Infotainment slide with fixtures and live leaderboard updates. Perfect for keeping your workplace in the spirit of the game. You'll find it in the Infotainment Category when
    • Template Design Guide

      Our Template Design Guide is for external designers, we recommend reviewing it if you plan to design your own Vibe templates: 👉 Vibe Template Design Guide This guide is designed to support brand and design teams in preparing template briefs—not building
    • Coming Soon: New Look for System Settings

      Behind the scenes, our team has been busy building a new System Settings interface in the Portal. This refreshed design will make managing Vibe smoother, faster, and more intuitive. Over time, we’ll be migrating all administration features and settings
    • Vibe.fyi Achieves ISO/IEC 27001:2022 Re-Certification

      Security isn’t optional — it’s foundational. We’re proud to share that Vibe.fyi has achieved ISO/IEC 27001:2022 re-certification, proving our commitment to: ✅ Protecting client data ✅ Managing risks in a fast-changing digital landscape ✅ Keeping our security
    • Free Mini Program: AI Adoption & Compliance in your Workplace

      AI is everywhere, but knowing how to use it safely and effectively at work can be tricky. That’s why we’ve created a free mini program for all Vibe clients to use as is or adapt to their own policies. Your team will learn how to: Use AI confidently and