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.
🦸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.
Cooltables
Cooltables add-on integrates the BigQuery database and Google Sheets.
It makes your Sheets scalable and able to handle terabytes of data 💪
It also provides useful Sheet templates.
🏗️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
—Very professional, very fast turn-around, excellent communication. Got the job done in no time.
—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.
Your add-on?
Boost Your Business with Custom Google Sheets
Dear Business Users,
You aim to sharpen operations. Tools are ready for action. Manage databases like MySQL and BigQuery. Connect APIs smoothly. Seek clean interfaces or strong data displays? They are here.
Need cloud functions and chatbots? Get webhooks that deliver. Want more in Google Sheets? Create HTML inputs and automate forms. Boost your Google Drive.
Seize this chance. Transform your business now.
Best,
Max Makhrov
🏆Awards
📖Books
Personal development:
Ray Dalio, "Principles"
Kelly McGonigal, "The Willpower Instinct"
Gavin Kennedy, "Everything is Negotiable"
Google Sheets and Scripts:
Get more with Sheets
Collection of 80+ named functions for any case :)
🏅Collections
🟢Formulas
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.
🟡Tips & Tricks
🟢Formulas
Named function Sheets. It fills down values if blank from the top filled cells in each column.
🟢Formulas
Named function Sheets gives all possible combinations of 2 lists. With the new BYROW function this formula should work much faster.
🟢Formulas
It's breaking the rules!
BYROW + LAMBDA in Google Sheets can convert any function into Array Formula.
🟡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
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
MailApp,
GmailApp,
and Gmail API.
The library takes care of parameters, so you do not need to care about which method to use.
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.
🖼️Galery
