Filter Google Sheets from one sheet to the other
As a Google Sheets user, there’s no doubt that you’ve already heard of (and used) the importrange formula. This formula allows you to import a range of cells from sheet A into sheet B, in real-time. This formula has its restrictions though. If you are a heavy Google Sheets user, and have multiple different sheets connected with importrange, you might experience random error messages, and therefore conflicted sources of truth.
But the biggest shortcoming of this formula is that you can only transfer data of an entire range to another sheet, instead of only specific, filtered data that you want to share with others. Learn below how to Filter Google Sheets from one sheet to the other and easily monitor who has access to your data.
Step 1: Install Sheetgo
Once inside the web application, click on +Create workflow and then Connect to create your first connection.
Step 2: Choose your data source
First, give the workflow a name (Filter Google Sheets for example).
As a data source, we then select the Google Sheets file we want to filter to another. I select my Product Inventory file from inside my Drive.
Step 3: Set the filter condition
Press Continue to come to the Filter section of the connection editor.
Here, Sheetgo gives you 3 options: Filter by condition (select data by column, number, date, text or value), Filter by Query (write a query using SQL syntax), or Filter by color (select data by cell color).
In this example, I am going to filter out only the products that are in high demand. I choose to Filter by condition: Column G: Demand, Text contains: High.
Step 4: Select your data destination
Once you’ve set your filter condtion, decide to what Google Sheet you want to send this data to.
Either choose an already existing file from inside your storage, or let Sheetgo automatically create a new Google Sheets for you.
If you choose the latter, give the new file a fitting name (here: Products to order), and don’t forget the new file tab’s name as well (High demand).
Finally, click on Finish and save to create your Filter Google Sheets connection.
The filtered data from our Product inventory sheet will now flow into the new Products to order sheet that Sheetgo created.
Step 5: Automate the workflow
If you want this data transfer to happen regularly, turn on the automatic updates.
On the floating bar of your workflow, click on Automate. Here, you can set the frequency of updates to hourly, daily, weekly, or monthly.
This is how you automatically Filter from one Google Sheets to the other.
Read the following blog post if you want to learn how to merge multiple Google Sheets into one.