Max Makhrov

.online

Max Makhrov is a blogger, and developer at cooltables.online.

He posts solutions for working with data in Google Apps Script, and Google Spreadsheets.

Since 2015 he's running a video blog about tables. His videos have been viewed more than 500 thousand times.

Currently, he's developing add-ons and accounting systems for clients from Ukraine, Israel, Germany, and the USA.

🦸Projects

As a Google Apps Script developer, my work was central to ARPAL's operational transformation. I created an automated dashboard and data entry system for their factory shops, making their production more time-efficient and cost-effective. 


This custom-built system enabled real-time tracking and planning of their manufacturing processes, making it possible to accurately determine the production timeline for each product. The backend of the system was powered by Google Sheets, Apps Script, and MySQL database, providing a strong and reliable platform for data management. 


My work not only helped to reduce costs but also empowered ARPAL to make informed changes to their production model, contributing significantly to their success.


I participated in the Spreadsheets Developers Gauntlet, a Google Sheets-focused competition hosted by Coefficient. I created a 'Chocolate Dashboard' using advanced formulas and conditional formatting, without any scripting involved. 


My work was recognized and featured by special guest referee, Ben Collins.

Add-ons

My add-on presents a revolutionary and innovative approach to image conversion from selected ranges, a feat that was previously thought to be unachievable. 

This tool effortlessly converts your chosen range into a .png image, which is subsequently saved to your Google Drive™. Notably, the operation of this add-on creates a designated folder named 'Range2Image' in your root directory for easy location of your converted images.

User Internal add-on

This project involved the development of an internal Google Sheets Add-on for a CEO, predominantly to access Data for CEO API. For this, I implemented functions that run tasks in parallel, a feature that significantly improved speed and efficiency. 

One of the key parts of the project was integrating Google's BigQuery for data analytics, which added a high level of depth to data analysis within the Google Sheets interface. This functionality gave the CEO remarkable detail and ease in their data examination process. 

Synterrix

AI add-on for Synterrix utilizes HTML service to overcome the standard 6-minute script runtime limit. 

With extended hours of operation, it can handle the processing of millions of words. 

Developed using a modern framework, it has an appealing HTML interface and generates custom user outputs—an ideal solution for those requiring bulk data handling in 'fabrique' mode.

🏗️Industries

Max works with IT, manufactures, SaaS.

Designers Team

API, MySql, Jira

Manufacture

Gas, Formula, DataStudio

Road Service

Gas, Formula

Marketing Agency

Big Query, API, Gas

Ingeneering Company

Gas, Formula

SaaS Owners

API, GDS-Connector

Business-Consultants

Gas, Formula, GlideApps

Truckers

Gas, Formula

Thomas Wiecki, CEO & Founder at PyMC Labs

—Very professional, very fast turn-around, excellent communication. Got the job done in no time.

Richard Garvey Founder and CEO at Different Digital

—Max was great in every aspect! Quick, effective, great communicator - highly recommend for anyone with any google sheets or SQL needs!

Max D., founder of Synterrix

My experience with Max has been nothing but positive. We successfully built the MVP. He helped me not only to build and shape the product but also with the Google verification process, which is pretty tough.

He's been supporting me every step of the way. Honestly, I underestimated how difficult building a seemingly simple Google Sheets add-on could be and I realized that without Max's help, I would not have been able to build this product and ship it to the market. 

If you're looking for some help with Google Sheets, building simple automation, or creating an actual add-on, whether for internal or external use, I highly recommend you work with Max. Thank you.


👀See more reviews


Your add-on?

Enhance Your Business Operations with Custom Google Sheets Solutions!

Dear Business Users,

I'm excited to extend a limited-time offer to elevate your business performance. As a specialist in crafting tailor-made Google Sheets add-ons, I can create precisely what you need to streamline your operations.

Whether you need to manage databases (MySQL, BigQuery, Firestore), create seamless API connections, design intuitive user interfaces, or visualize data with Looker Studio, I have you covered. Furthermore, my expertise spans developing Cloud functions, chatbots, and webhooks to generate a comprehensive solution, complete with advanced features such as dependent lists for Sheets, HTML inputs, forms automation, and more for an enhanced Google Drive experience.

Important: This offer is time-restricted! I am currently developing a proprietary add-on, CoolTables, which will mark my transition from freelancing to running my own enterprise. 

Don't let this exclusive chance to transform your business processes with advanced Google Sheets add-ons slip by! Hire me on Upwork today, and together, we can harness the power of Google Sheets to reshape your business for optimum efficiency.


Best regards,

Max Makhrov

🏆Awards

2023 

 Google Workspace Innovator Champion 2  years in a row.

2022 

Google Workspace Innovator Champion

6 works featured by Apps Script Community

Featured work on Spreadsheets Gladiators Challenge

2021

Google Sheets gold on StackOverflow

Nominated: Google Developer Experts program.

📖Books

Personal development:

Google Sheets and Scripts:


🖼️Galery

Get more with Sheets

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.