🧙🏻♂️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 ↓
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.