AppsScriptPulse

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.

Solutions, Sheets, Beginner

Sending data from a webcaptioner.com channel webhook to Google Sheets with Google Apps Script 

Tags:
| | 0 Comments |

push data from web captioner to google sheets via webhooks built using apps script.

the problem – playing with webcaptioner.com which lets you specify a webhook url. i was experimenting with adding captions to a google doc in realtime but apps script couldn’t keep up dropping ~20% of the captions sent via the hook

Sourabh Choraria kindly helped me solve an issue I was having passing data from webcaptioner.com to Google Sheets. Click through to the source link for the full explanation from Sourabh, but in essence the problem was I was losing data because I wasn’t using the LockService.

In the meantime webcaptioner.com have also updated there channel webhooks so you can set a data chuck size so if you are looking to capture a transcript in Google Docs you can use the following published as a container bound web app:

// @OnlyCurrentDoc
function doPost(e) {
  const params = JSON.parse(e.postData.contents);
  DocumentApp.getActiveDocument()
    .getBody()
    .appendParagraph(Utilities.formatDate(new Date(), "GMT", "HH:mm:ss")+': ' + params.transcript);
}

Source: web captioner, webhooks and google apps script

Solutions, Sheets, Video Tutorial, Beginner

How to Copy a Row to another Sheet with Google Apps Script – Learn how in this tutorial from @saperis_io

Tags:
| | 0 Comments |

Tired of manually copying rows from one Google sheet to another? Automate it! I’ll show you how in my latest video tutorial.

For people just getting started in Apps Script nice little video tutorial showing how you can move rows in Google Sheets (this tutorial is the latest in a growing list of videos produced by Chanel Greco Founder & CEO of saperis).