Solved
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.
Best,
-Supermetrics Team