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
—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?
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:
Ray Dalio, "Principles"
Kelly McGonigal, "The Willpower Instinct"
Gavin Kennedy, "Everything is Negotiable"
Google Sheets and Scripts:
🖼️Galery
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
Want more content like this?
Follow Max on Twitter and Medium ↓
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.