How to connect Google Sheets to Adriel

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

Lastly modified on: Wed, 12th June, 2024 at 10:51 AM

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.