Hello, I'm trying to create a custom extractor wit...
# getting-started
p
Hello, I'm trying to create a custom extractor with the functionality to extract data from Google Sheets. Are there any resources/tutorials available to help me with this?
r
There's already an extractor for Google Sheets: https://hub.meltano.com/extractors/google-sheets šŸ™‚
e
Hey @pranav_shirole! @Reuben (Matatika)’s suggestion is a good one. If you still need to build your own, along with AJ's

"Build Your Own Tap" tutorialā–¾

, there's also the academy playlists in Youtube and the SDK docs. For specific questions #C01PKLU5D1R is a good place
p
@edgar_ramirez_mondragon Hello Edgar, I watched the video you shared with me. I'm trying to get my code to work in VSCode. I'm creating a Tap. I typed in 'cookiecutter https://gitlab.com/meltano/sdk --directory="cookiecutter/tap-template"'. I input the fields source_name, admin_name, etc. I'm getting this error 'Import "singer_sdk" could not be resolved'. Could you please help me understand what this means?
e
Hi Pranav. You'll need to run
poetry install
to make sure the tap's dependencies are installed
p
@edgar_ramirez_mondragon, thank you!
poetry install
did work. I need to create an extractor for Google Sheets. I know there is already a Sheets Extractor available but I've been tasked to create one from scratch. I'm stuck because I understood the Rick And Morty API on the YouTube video, but the Google Sheets API documentation is much more complex. Is there a Tap Developer's Prep Worksheet for the Google Sheets API? Or any other resource that would help me create this extractor? Thank you for your time.