How to use the custom connector with Google Sheets API

Let's say I want to pull in data from one google spreadsheet into another google spreadsheet. I know I can do this using importrange function but just wondering if I could do so using the Supermetrics custom connector for google sheets and the Google Sheets API. If so, what would I enter as the http headers?

  • Hi Hugh,

    to our knowledge, this is not feasible, because the Google Sheets API uses OAuth which requires some more complex login to handle the authentication.


    -Supermetrics Team

Login to post a comment