Category: Tutorials
-
How to Import JSON Data from Any API into Google Sheets Using SQL
If you’ve ever wanted to bring live JSON data from an API into Google Sheets for analysis, automation, or visualization, this guide is for you. By using SQL queries in combination with Google Sheets, you can extract, process, and display data effortlessly. Let’s dive into the step-by-step process. Step 1: Install the SheetQuery Add-On Google…
-
Conditional Mass Update of Data in Google Sheets Using SQL
Categories: TutorialsOne of the tasks that cannot be solved using standard Google Sheets tools but can be handled with an SQL query is mass updating data with conditions. For example: Task: Increase the Annual Salary by 10% for all employees working in the “IT” department who have more than 5 years of tenure. SQL query for…
-
SQL in Google Sheets: Calculating Salary Shares using window functions
Categories: TutorialsGoogle Sheets is a powerful tool, but some advanced tasks—like calculating an employee’s salary as a percentage of their department’s total—can be challenging. SQL, especially with window functions, makes this analysis straightforward. The Challenge Given a dataset with employee details (id, name, department, and salary), calculating salary shares in Sheets requires manual grouping, matching, and…