Google Sheet CRUD Tools
🚀 Just dropped a new NPM package: google-sheet-crud!If you've ever worked with Google Sheets as a database, you know the pain—Google's API returns everything as a massive array, which can be a he...
How to Build a Data App with Google Sheets Backend Using Evidence
In this article, we will introduce the process of building a data app with a spreadsheet backend using Evidence. We will also explore the use cases where Evidence is particularly well-suited.
In the ...
Published an OSS Repository That Continuously Stores GitHub Repository Metrics Using GAS
Hey Devs!Previously, I explored how we can monitor OSS activity metrics based on GitHub repository data.
Consideration of OSS Activity Metri...
How to Build a Internal Data App with Google Sheets Backend Using Streamlit
In this article, we’ll walk you through the process of building an internal-use data app using Streamlit with a spreadsheet as the backend. We’ll also explore scenarios where Streamlit is a parti...
Integrate Google Sheets with Python: A Step-by-Step Guide
Want to learn how to connect your Google Sheets with Python to fetch and manipulate data? By using the gspread library alongside pandas, you can easily automate tasks, analyze data, and even save it i...
Mastering Web Scraping with Google Sheets
Web scraping doesn’t always have to be a complex, code-heavy task. Google Sheets—yes, the simple spreadsheet tool you already know—can do the job. If you’re a data-driven professional, you’l...
Calculate Average Scores By Category using Google Sheets Pivot Table
During player evaluations for a sports organization, each player is evaluated across multiple categories. The scores must be averaged and totaled. This data is then used to make decisions for the foll...