The ultimate guide to the FILTER function Google Sheets with advanced formula examples: FILTER nested with UNIQUE, SUM, REGEXMATCH and other functions.
Explore how you can automate export of SQL queries from BigQuery to Google Sheets without coding or using a BigQuery data connector.
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.
A detailed tutorial on how to use IMPORTRANGE to import data across spreadsheets, with examples and formulas.
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.
A detailed guide + formulas for exporting Trello cards data with custom fields to Google Sheets using Coupler.io.
Use the Google Sheets add-on, Coupler.io, to connect your Trello boards to a spreadsheet and import versatile data.
Coupler.io lets you automate the export of Xero Reports (Bank Statements, Profit and Loss, and others) to Google Sheets and pull unreconciled transactions.
Connect QuickBooks to Google Sheets to import raw data, such as Invoices, Purchases, etc. All you need is a GSheets add-on, Coupler.io.
All the functions to merge cells and columns in Google Sheets. Check out formula examples with CONCAT, CONCATENATE, JOIN, TEXTJOIN, SUBSTITUTE and &.