Integrate - File/DB
      Back to home
      1. Adriel Academy
      2. Connect
      3. Integrate - File/DB

      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.