Sheetgo Blog

Your go-to resource for all things spreadsheet related

Introducing Sheetgo workflow automation

Introducing Sheetgo workflow automation

Workflow automation Today, we are announcing our new vision on workflow automation. Sheetgo was actually supposed to kick-off in 2010. Which is when Google saw it and said, “wow, you created an ERP with our spreadsheets, online? We didn’t know that was possible.”...

read more
The Ultimate Guide to structuring your workflow in 2019

The Ultimate Guide to structuring your workflow in 2019

Accomplishing any task involves knocking off a series of intermediate activities in a predefined sequence. We can simply term this as workflow - the flow of events to get work done. This is applicable to any context that involves accomplishing a task. A manufacturing...

read more
How to visualize your Google IMPORTRANGE connections

How to visualize your Google IMPORTRANGE connections

For most of us, dealing with data is commonplace. And spreadsheet applications such as Google Sheets are a great means of working our way through these heaps of data sets. One of the challenges with data is that it has so many variations to it. So, we cannot treat it...

read more
How to better manage your IMPORTRANGE connections?

How to better manage your IMPORTRANGE connections?

We deal with a lot of data in our daily lives and usually manage that with spreadsheet applications such as Google Sheets. It makes sense to use a separate spreadsheet for each individual purpose. Because for one thing, we can't store everything on one file. For...

read more
How to transfer formatted Google Sheets

How to transfer formatted Google Sheets

Spreadsheets have become an integral part of our lives. They have advanced so much over time that embracing them into our work makes more sense by the day. Their evolution manifested them from standalone desktop applications to cloud-based applications that can be...

read more
How to efficiently merge dozens of spreadsheets

How to efficiently merge dozens of spreadsheets

It won't be an understatement to say that most of us handle our data and reports using spreadsheet applications like Google Sheets. The primary reason being they are inexpensive (read free). But they have also come very far in terms of form, functionality,...

read more
Automatically import filtered data in Google Sheets

Automatically import filtered data in Google Sheets

The ubiquity of the internet and deluge of wireless devices certainly made our daily lives easier. They paved the path for cloud-based applications such as Google Sheets. This application lets us collaborate and work on the spreadsheet data regardless of the location...

read more
Inventory Management: Definition and best practices

Inventory Management: Definition and best practices

Inventory, in simple terms, is the list of goods in stock. For any organization, it is crucial that they keep tabs on the levels of their inventory at any given point in time. And that they keep their inventory in line with the present and projected demand for their...

read more
How to manage workflows in spreadsheets

How to manage workflows in spreadsheets

A workflow is a predefined sequence of steps that we can use to get our work done with. The best part about a workflow is that we can illustrate the process in the form of a sequence diagram. In the context of spreadsheets, how relevant are workflows? Can we...

read more
How to analyze BigQuery data within Google Sheets

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

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