🧙🏻‍♂️Online automation. Google Sheets & Scripts

This site was created by Max Makhrov, a Google Innovator champion and Google Sheets enthusiast with over 17 years of experience. Max has honed his skills to become a professional developer. 

You can hire him for custom projects, including Add-Ons, Reports, API integrations, SQL-based accounting systems, or anything involving Apps Script and Google Workspace.

Max enjoys sharing his insights on Twitter and Medium. Below are some useful tips for you ↓

Convert range 2 image in Sheets.

Medium  Marketplace  Git Hub

🟣Add-ons

Collection of 80+ named functions for any case :)

Collection

🏅Collections

🟢Formulas

See decimal points for the small numbers in the report.

Tweet

🟡Tips & Tricks

This is a sample formula + conditional formatting for creating shapes in a Spreadsheet grid.

Template Galery   Spreadsheet Sample

🏅Collections

🟢Formulas

My 🍫 dashboard in the Spreadsheet Gladiator Challenge.

Featured work   Spreadsheet Sample

🟠Challenges

🟢Formulas

Use "CONDITION_ONE_OF_RANGE" hidden function to filter the range by multiple matches from a list.

Tweet

🟡Tips & Tricks

🟢Formulas

BENCHMARK named function to test the speed of your formulas.

Tweet

🟡Tips & Tricks

🟢Formulas

🐇Gantt Chart ArrayFormula

Tweet  Spreadsheet Sample

🟢Formulas

Named function Sheets. It fills down values if blank from the top filled cells in each column.

Tweet  Spreadsheet Sample

🟢Formulas

Named function Sheets gives all possible combinations of 2 lists. With the new BYROW function this formula should work much faster.

Tweet  Spreadsheet Sample

🟢Formulas

It's breaking the rules!

BYROW + LAMBDA in Google Sheets can convert any function into Array Formula.

Tweet

🟡Tips & Tricks

🟢Formulas

Put 1 range above another with this elegant formula.

Tweet

🟡Tips & Tricks

🟢Formulas

=QUERY({A4:C};"where Col1 matches 'West|East'") 

Did you know about the OR condition for QUERY in #GoogleSheets 

'West' 

OR

'East' 

🟡Tips & Tricks

🟢Formulas

TYPE function

TYPE function in #GoogleSheets helped me to figure out why 2 of my cells are not equal.

🟡Tips & Tricks

🟢Formulas

Bar-Code with a formula

Challenge — create your own Bar Code Formula using the SparkLine function.

🟠Challenges

🟢Formulas

Want more content like this?

Follow Max on Twitter and Medium ↓

TwitterMedium

Dependent drop-down lists can be used to create a dynamic list of choices in Google Sheets.

Automate tasks in Google Sheets, Documents, Forms, Drive, and other Google services.

➡️Apps Script Tools

😽GitHub

Please see my Git-Hub Repo

It has 200+⭐stars, but it's still messy. One day I'd like to take care of the beautiful description and better structure of the files later.

Any ideas are welcome!

Library lets you send emails, using 

The library takes care of parameters, so you do not need to care about which method to use. 

🖨️Sheet2PDF

Library for converting Google Sheets™ Into PDF.

Featurs:

⚙️ All PDF settings including colontitles = custom headers and footers.

🔌Input parameters is a single plain object.

Jsonatags is a library that enables the use of the Jsonata.js 

It helps you to manipulate jsons with a query-like language.