How to use FILTER Function in Google Sheets: Everything You Need to Know
The ultimate guide to the FILTER function Google Sheets with advanced formula examples: FILTER nested with UNIQUE, SUM, REGEXMATCH and other functions.
Author: Zakhar Yung
Connect BigQuery to Google Sheets and Import Your Data Automatically into Spreadsheets
Explore how you can automate export of SQL queries from BigQuery to Google Sheets without coding or using a BigQuery data connector.
Why Analyze Data? A Data Analyst’s Revelation
What data analysts do, why they analyze data, how many analysts a company should have – find answers to these and other questions in this blog post.
How to Use IMPORTRANGE in Google Sheets to Import Data Across Spreadsheets
A detailed tutorial on how to use IMPORTRANGE to import data across spreadsheets, with examples and formulas.
How to Automate Harvest Data Export to Google Sheets Without Any Script
Learn how you can export time reports from Harvest to Google Sheets without any script. This solution works for Clients, Projects, Tasks and Team reports.
How to Import Custom Fields from Trello to Google Sheets
A detailed guide + formulas for exporting Trello cards data with custom fields to Google Sheets using Coupler.io.
Connect Trello to Google Sheets and Automate Data Import
Use the Google Sheets add-on, Coupler.io, to connect your Trello boards to a spreadsheet and import versatile data.
Xero Reports in a Spreadsheet: How to Pull Reports from Xero to Google Sheets
Coupler.io lets you automate the export of Xero Reports (Bank Statements, Profit and Loss, and others) to Google Sheets and pull unreconciled transactions.
QuickBooks to Google Sheets: Automate Data Export Without Coding
Connect QuickBooks to Google Sheets to import raw data, such as Invoices, Purchases, etc. No coding skills are required.
How to Merge Cells and Combine Columns in Google Sheets
All the functions to merge cells and columns in Google Sheets. Check out formula examples with CONCAT, CONCATENATE, JOIN, TEXTJOIN, SUBSTITUTE and &.