How to connect a Google Sheet to Actiondesk

Let's say you have a dataset in a google sheet that you'd like to connect to Actiondesk

The first step will be to create a named range in Google Sheets