Google Sheets Power Up: Creating Custom Functions with Google Apps Script 🚀

Published in

Geek Culture

5 min readAug 23, 2021

--

What Are Custom Functions?

If you use any kind of spreadsheet, you know that they contain built-in functions that help you work with your data. For example, the function SUM(A1:A5) will print the sum of the values in the first five rows of the first column.

Dmitry Kostyuk

Written by Dmitry Kostyuk

Writer for

Geek Culture

Full-time GCP and Google Workspace developer, founder at Wurkspaces.dev | Hire me: https://cutt.ly/p8BgQYE | Get Medium membership: https://cutt.ly/N8BggJs

Recommended from Medium

Dmitry Kostyuk
in
Geek Culture

Steer Clear of These onEdit Traps in Google Apps Script: Top 3 Tips! 🚧

The onEdit trigger can feel unreliable and messy, but when done right it is powerful and reliable.

8 min readJan 9

--

Erdogan Taskesen
in
Towards Data Science

D3Blocks: The Python Library to Create Interactive and Standalone D3js Charts.

Create interactive, and stand-alone charts that are built on the graphics of d3 javascript (d3js) but configurable with Python.

11 min readSep 22, 2022

--

Lists

Staff Picks

333 stories87 saves

Stories to Help You Level-Up at Work

19 stories56 saves

Self-Improvement 101

20 stories108 saves

Productivity 101

20 stories120 saves

Deanne'sDiaries

Apps Script: Automatically Populate Google Docs and Save to Corresponding Folder Based on Multiple…

Disclaimer: This is written mostly by ChatGPT

3 min readMar 14

--

Eyal Gershon

Sending a Webhook for New or Updated Rows in Google Sheets

There is no doubt that Google Sheets is an extremely powerful business management tool. Not all businesses use CRM software and even when…

5 min readJan 15

--

Max Makhrov

Custom Range-A1 Functions in Google Sheets

This article describes how to use range objects in a custom function. Read it or jump to Sample Spreadsheet and see.

6 min readJan 13

--

Dmitry Kostyuk
in
Geek Culture

Using ChatGPT for Placeholder Data: Kickstart Your Projects with Google Apps Script 🚀

ChatGPT is pretty much a universal API: one endpoint to get any data.

10 min readJan 17

--

See more recommendations

Help
Status
Writers
Blog
Careers
Privacy
Terms
About
Text to speech