Sheetgo Blog
Your go-to resource for all things spreadsheet related
BigQuery Data Connector for Google Sheets: How to Get More Than 10,000 Rows
We highly recommend you to read our blog “Analyze BigQuery Data Within Google Sheets” before reading this one. The New BigQuery Data Connector for Google Sheets If you are using the new BigQuery Data Connector for Google Sheets, you are probably loving how you can...
read more
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
Simple Recruiting Tool using Typeform and Google Sheets
Services used Google Sheets Typeform GmailDepartment Human ResourcesTime to setup 20 minutesIntroduction: What is the Candidate Recruitment Template? The process of recruiting can be very daunting and time-consuming. This is...
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