Sheetgo Blog

Your go-to resource for all things spreadsheet related

How to Analyze BigQuery Data Within Google Sheets

What is BigQuery? BigQuery is Google's solution to enterprise-level data storage. It is a cloud-based service that offers rapid SQL querying for big data at an affordable price. Because it is a Google product it is reliable, secure, and always improving. With...

read more

How to Get Data From BigQuery to Google Sheets Automatically

What is the BigQuery Data Connector for Google Sheets? BigQuery connectors allow users to integrate BigQuery with other platforms—either data sources or analytics tools. Google recently launched a BigQuery connector for Google Sheets which allows greater accessibility...

read more

Best of 2018: Sheetgo’s top 10 blog posts

Let's get ready for 2019...We want to look back on an amazing Sheetgo year by presenting you with the top 10 blog posts that provided you with tips and tricks on how to use Google Sheets and all its possibilities, but also the extremely handy Sheetgo Templates that...

read more

Manage team training sessions with Google Calendar and Sheets

What is the Training Management System? Have you ever spent hours checking colleagues calendars trying to find the most suitable date and time for a training all the while checking for room availability? Have you ever had to manually insert every training in a shared...

read more

Automated Income Statement Template for Google Sheets

What is the Income Statement Template? The income statement is one of the three main Financial Statements that a company must maintain. It summarizes your revenues and expenses over a period of time. It differs from a Cash Flow Statement in that it is based on the...

read more

Budgeting Template in Google Sheets

Overview of Sheetgo’s Budgeting Template This system is designed for a CFO or controller to collect budget inputs from a company's department head so that they can create a company-wide budget. It includes a central budget for the CFO / controller and individual...

read more

Working with data in Google Sheets

A spreadsheet is all about the data present within the file. So it is a good idea to understand our way through handling it. In this blog post, we will have a look at the various ways of working with the data within Google Sheets. Key in data within a cell As we are...

read more

Data filters and sorting in Google Sheets

Google Sheets is capable of holding huge data sets. But huge data can mean difficulties with handling it. Especially in terms of organizing it in a way that we can traverse through easily. In this article, we will explore the data filters and sorting methods that will...

read more

Supplier Invoice system using Google Sheets

Sheetgo’s Invoicing Solution helps you organize and track invoices from multiple suppliers. Invoices are received through many sources so it is easy to lose track of them. Therefore, it can be difficult to control all invoices when they are scattered all over the...

read more

Bug and Ticket Tracking System using Google Sheets

Services used  Google Sheets  Google Forms  Google Apps Script   Gmail Department  Product Development Time to setup  15 minutes Bug Tracking Ticket System This blog post presents an easily configurable bug tracking ticket system which integrates various components of...

read more