Forem

Cover image for Google Sheet + Google Drive = 🀯 - Part 1
Luke
Luke

Posted on

Google Sheet + Google Drive = 🀯 - Part 1

This is the 3rd post in my portfolio series. In a previous article, I wrote the way I implement dev.to API. I will tell you about my journey to find the way to show my repository on portfolio

This is the hardest part (with me) in this series, I repeat, the hardest part (with me)!!! πŸ€ͺ

Begin

Problem

As I said, I am a back-end guy so I want to try to make everything automatic, less manual as I can. Like articles section, I want projects section work as the same. The first solution I think is GitHub RestAPI, its usage is quite simple BUT ... when I implemented it into 80%, I realized it does not get a thumbnail of project, I be like image below when I know it
suprise
Although I can use default image for all projects, but I don't want πŸ™„. I started to research with the support of Mr.KnowEverything - a.k.a Google, and no hope πŸ˜‘.

Solution

After many and many searches, when I prepared to give up, I saw FreeCodeCamp's post about using Google Sheets to build CMS. An idea appeared in my head πŸ’‘ what if I build the CMS to store repository info - sounds possible huh?

When I found the way and connected with some research, I decided to combine Google Sheets and Google Drive to solve it 😎.

idea

System Design

Here is the sketch design of my solution

sysdesign

System Design

In this design, it will have 3 main components:

  • API Gateway: Access to get repository info (git_url, thumbnail_id, etc)
  • Google Sheets: Act like SQL data table, store repository info
  • Google Drive: Store the thumbnail of the repository and return a unique ID to save into the sheet (We will use this to load the thumbnail on the website πŸ˜‰)

Conclusion

Sound like my solution is a little bit messy, so if you have any suggestions, please tell me πŸ€—

In the next article, I will show how to implement this in code.

Happy coding and learning!

Image of Timescale

πŸš€ pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applicationsβ€”without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read more β†’

Top comments (0)

πŸ‘‹ Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay