How to connect Google Sheets to Adriel

Detailed instructions to help you set up the data source for Google Sheets

Lastly modified on: Tues, 11th March, 2025

Prerequisites

• Google Sheet

Instructions

Step 1: Giving Adriel Access to Google

1. Move to Adriel’s Connections page.
2. Type “Google Sheets” into the search bar.
3. Click “Sign in with Google” when the pop-up window opens.
4. Click “Continue” to allow Adriel access to the Google account.

Step 2: Connecting Google Spreadsheet to Adriel

1. Choose “Spreadsheet” and “Sheet” with which you want to connect to Adriel.
   
   1. Optional configuration is possible. If wanted, fill in the "Alternative Channel Name."
      1. No icon is provided as a default for this feature. However, there are channels that can use internally saved icons and display next to the channel name you just wrote down.
      2. Refer to this guide to input the correct name to display the icon. 
         https://academy.adriel.com/en/how-to-set-alternative-channel-name-for-file-db-data-source
   2. (Optional) Fill in the "File Name to Filter" and click "Submit."
2. Click the “Submit” button below to complete the data connection.
   
   It can take up to one working day for your data to arrive. 

Updates from a linked Google Sheet

Data from connected Google Sheets will be automatically updated in the dashboard. On occasion, it may take a short amount of time for the data to refresh as we wait for Google's API to allow us to access data.

If you still struggle with updating the data from the Google Sheets, you can try below to refresh:

1. Go to Data Sources > Settings to check your Google Sheets connection.
2. Click the Refresh button next to the data source title.
3. This will clear the widget cache to show the most up-to-date data from your Google Sheet.