Hey Everyone, I am trying to extract data from goo...
# plugins-general
m
Hey Everyone, I am trying to extract data from google sheet tap and load into redshift. But as in documentation they have said we need to put the domain and google search api. So i am not able to understand the flow and the link between google sheet and Google search console and which domain i need to use. Questions: 1. Which domain i need to use and how Verify Site Ownership for demo purpose? So in simple words i want to know the prerequisites for implementing and try out Google sheet tap.
j
m
Yes.
@jazzy
p
@monika_rajput maybe something has changed recently but I used that tap in the past and dont remember having to do the site ownership piece. That sounds like something for google search maybe. I just clicked through their docs and getting started guide for getting an API key and it doesnt look like the ownership piece is required. What docs are you following that asked you to do the site ownership stuff?
m
This is the google doc https://docs.google.com/document/d/1FojlvtLwS0-BzGS37R0jEXtwSHqSiO1Uw-7RKQQO-C4/edit# And from here i got this doc link. They are saying we need to authenticate via domain for google sheet Integration. https://hub.meltano.com/extractors/tap-google-sheets
j
Yeah that looks incorrect and can understand why it's confusing. Perhaps try enabling the Google sheets API in your project in GCP and following the create credentials step in there
m
@edward_ryan Tagging you here for your reference .
p
Oh interesting, they link to that google doc in the tap README as well 🤔. I do remember referencing a google doc with instructions but that content looks different from what I remember
a
As an alternative, there's our Meltano SDK google sheets tap (https://github.com/Matatika/tap-google-sheets). You may bump into the same issues setting up your oauth client, I know that definitely requires access to the Google Sheets API. https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get?hl=en_GB
m
Do we have any Documentation or guide that how we can get the settings ( client_id , client_secrets and user_agent). ?
@aaron_phethean
a
Hi @monika_rajput Frankly, I find creating the client id & secret is always a pain. This is the guide from Google OAuth 2.0 Google API Documentation When running the tap yourself, this is the only option. When a SaaS service (like us) runs the tap, we connect to the google API with our client id / secret and you give consent to our service to move the data from your gsheet to a target. That makes the connection part easy.
m
Okay i am trying this right now. Hope i will able to make it possible.