AppsScriptPulse

Snippet, V8, Beginner, Sheets

Setting Alternate Background Colors for Rows in Google Spreadsheet using Google Apps Script

Tags:
| | 0 Comments |

This is a sample script for setting alternate background colors for rows in Google Spreadsheet using Google Apps Script.

It has already been known when the conditional formatting rule and custom function are used, this can be simply achieved. In this report, I would like to introduce the method for using Google Apps Script.

Source: Setting Alternate Background Colors for Rows in Google Spreadsheet using Google Apps Script

Snippet, Intermediate, Sheets, Web App

Get your Zoom meeting settings via the API and storing in a Google Sheet using Google Apps Script

Tags:
| | 0 Comments |

Get your Zoom meeting settings via the Zoom API and OAuth, using a Web App in Google Apps Script. Here we will access user settings in your Zoom account, specifically the meeting settings, and log the results in a Google Sheet. This provides both a way of confirming we have made a successful connection and will allow us to create subsequent Zoom meetings using these settings.

This will log the results in a Google Sheet to help you understand what is happening and the type of data that is returned.

Source: The Gift of Script: Get your Zoom meeting settings via the API

Solutions, Sheets, V8, Intermediate

Format specific word inside a Google Sheet cell using Google Apps Script

Tags:
| | 0 Comments |

Format (bold) a single word or a group of words automatically in sheets, using google apps script.

This example from Sourabh Choraria is a nice example of how you can apply text formatting to parts of Google Sheet cell values. Reading Sourabh post got me thinking if having an Add-on or built in feature that used basic markdown for cell formatting would be useful? e.g. typing `I just love **bold text**` would result in the cell being displayed as `I just love bold text`.

Source: format specific word inside a google sheet cell using apps script

Solutions, Sheets, V8, Intermediate

How to send Slack alerts from Google Sheets / Google Apps Script

Tags:
| | 0 Comments |

We run a lot of things through Google Sheets and Slack here at August. It’s a way of connecting and sharing information quickly and transparently with our clients and our team. We’ve put together a cheat sheet of a few simple Google Apps Script functions, along with the Slack API, so you can do the same.

Great post if you are looking for a quick start for interacting with Slack using Google Apps Script. As well as a detailed ‘how-to’ the post also includes a video walkthrough to help if you get stuck with any of the steps.

Source: How to send Slack alerts from Google Sheets / Google Apps Script. | August

Solutions, Sheets, Web App, Intermediate

When the Best Google Sheet is the One You Don’t Make

Tags:
| | 0 Comments |

How to build a more perfect workflow for data updates and changes by coding in Apps Script between the Sheets

Thought provoking post by Max Brawer exploring the utility and fragility of using spreadsheets as part of a decision making processes and how Apps Script can be used to overcome some of these shortcomings.

Source: When the Best Google Sheet is the One You Don’t Make

Solutions, Sheets, V8, Advanced

How to write a custom function library for Google Sheets

Tags:
| | 0 Comments |

In this article I will showcase one of the many ways you can customize your Google Workspace environment. We will implement two custom functions in Google Sheets. With these functions as an example I will demonstrate how to use Google Apps Script Libraries to organise and distribute your solution. There are multiple ways to distribute your Apps Script code within the Google Workspace, and this article will help you decide if this library method is right for you.

Always nice to have some advanced techniques in your toolbox. In this example from Jasper Duizendstra he explores how custom functions in Google Sheets can be packaged and used in Libraries.
Source: How to write a custom function library for Google Sheets

Solutions, Sheets, V8, Beginner

Finding Merged Cells In Your Google Sheet using Apps Script (And When To Be Careful)

Tags:
| | 0 Comments |

Learn how to merge cells in Google Sheets, when to use them and when to avoid them [and] finding merged cells in your Google Sheet using Apps Script

Some very useful guidance from Ben Collins on merged cells within Google Sheets. As well as how to merge/unmerge cells Ben also highlights some of the pitfalls when merging cells. The post also includes a very useful snippet for detecting merged cells using .getMergedRanges().

Source: How To Merge Cells In Google Sheets And When To Be Careful

Solutions, Sheets, Web App, V8, Advanced

Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets – Yagisanatode

Tags:
| | 0 Comments |

In this tutorial, we are going to create an interactive story chain app that we can embed into a Google Site or your own site like WordPress.

Yagi uses a simple but very effective interactive story chain app to explore and explain some very powerful Apps Script functionality all developers should know about. This includes using the LockService which can be used to prevent concurrent access to sections of code. Yagi also highlights some recent discussions around the limitations of Web Apps and concurrent users. Click through to the source for all this and more.

Source: Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets – Yagisanatode

Snippet, Solutions, Sheets, Beginner

Alexa Rank Tracker built in Google Sheets with formulas and Google Apps Script – bencollins.com

Tags:
| | 0 Comments |

Tutorial on how to build an Alexa Rank tracker in Google Sheets, using the powerful IMPORTDATA and REGEXEXTRACT functions and Apps Script.

Clever post from Ben Collins highlighting how Google Sheets functions can be used to scrape Alexa tracking data. As a bonus Ben includes a little snippet of Google Apps Script to let you archive data over time.

Source: Alexa Rank Tracker built in Google Sheets with formulas and Apps Script

Official News, Solutions, Sheets, Beginner

Collect and approve timesheets via Google Sheets and Apps Script- Sheets to Apps

Tags:
| | 0 Comments |

In this episode of Sheets to Apps, we show you how you can easily build a payroll app that makes approving timesheets easier and communication with management seamless. Watch to learn how you can build a timesheet application with zero code!

Click through to the YouTube page and check the video description for all the resources to replicate this solution.