What's in this article:

Adding Google Sheets as a Data Source

1. Go to app.useavenue.com

2. Click on Connect Data Source

3. Click on the Database Type drop down and select Google Sheets

4. Head over to your Google Sheet and grab the ID from the URL

5. Paste the ID into the Spreadsheet ID input.

6. Then copy the URL to your clipboard

7. Once done head back to your sheet and share with the URL as a Viewer

8. Click on Viewer

9. The last step is to click Connect Database!

Using Google Sheets in Avenue

To reference a google sheet when creating a monitor using this syntax:

Sheet1!A1:EF232

Replace Sheet1 with your Spreadsheets name and select the range your wish to pull from.

⛑️ If you need any help or have any questions please contact support by email, or at any time within the app, scroll down to the Get Help button on the left navigation bar.