AppsScriptPulse

Snippet, Beginner, Gmail

[Solved] Inline images break when embedded from the htmlBody of an existing Gmail draft

Tags:
| | 0 Comments |

Handy snippet from Andras Sztrokay to handle inline images when using Gmail draft messages as part of your script projects. As highlighted by Romain Vialard in the Google Apps Script community:

Google added the ability to easily retrieve the inline images in an existing draft via the getAttachments() method on October 30, 2018 (see Apps Script release notes)

Source: Inline images break when embedded from the htmlBody of an existing draft [GmailApp] [Apps Script]

Snippet, V8, Intermediate, Slides

Inserting Text on Image using Google Apps Script

Tags:
| | 0 Comments |

This is a sample script for inserting a text on an image using Google Apps Script. The flow of this sample script is as follows:

  1. Retrieve the image size using ImgApp.
  2. Create new Google Slides with the custom page size using DocsServiceApp.
  3. Put the image and text.
  4. Export the result image

Source: Inserting Text on Image using Google Apps Script

Snippet, Solutions, Sheets, Intermediate

Create a Zoom meeting via the API using Google Apps Script

Tags:
| |

Create a meeting in Zoom via the API and OAuth, using Google Apps Script and a Web App. The details for the meeting will be collected from a Google Sheet.

Zoom meeting details in a Google Sheet

Zoom meeting details in a Google Sheet

Source: The Gift of Script: Create a Zoom meeting via the API

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

Snippet, Solutions, Web App, Video Tutorial

Connect to Zoom API with Apps Script and OAuth

Tags:
| | 0 Comments |

How to connect to the Zoom API via OAuth. Using Google Apps Script and a Web App. An alternative to JSON Web Token. Includes a tutorial video.

Source: The Gift of Script: Connect to Zoom API with Apps Script and OAuth

Snippet, Solutions, V8, Intermediate

How to Share User Properties between Google Apps Script Projects – Digital Inspiration

Tags:
| | 0 Comments |

The Properties Service of Google Apps Script is used by developers to store app configuration and user specific settings. The properties data is scoped to a specific user, or a specific project, and cannot be shared between different projects. … In some specific cases, we may want to give access to our store data to another user so they may build upon the existing configuration rather than having to build everything from scratch.

Amit Agarwal shares a useful snippet for letting users export and import data from PropertiesService. There are some nice touches in this solution including using the JavaScript File Reader API.

Source: How to Share User Properties between Google Apps Script Projects – Digital Inspiration

Snippet, V8, Intermediate

How to Create JSON Web Token (JWT) with Google Apps Script – Digital Inspiration

Tags:
| | 0 Comments |

You can use Google Script to create JSON Web Tokens (JWT) that can be provided to secure routes so that only authenticated requests that contain a valid token can connect to the APIs (e.g., the Zoom API)

Nice little snippet from Amit Agarwal for both creating and decoding JSON Web Tokens (JWT).

Source: How to Create JSON Web Token (JWT) with Google Apps Script – Digital Inspiration

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

Snippet, Beginner, Sheets

The Gift of Script: Search spreadsheet for multiple criteria

Tags:
| | 0 Comments |

Search through rows of a Google Sheet simultaneously looking for certain criteria all in one single loop. I needed a way of doing this without multiple loops despite searching for separate information and here is a way of achieving that via true/false flags.

Rows of email address and role in spreadsheet

Screenshot of spreadsheet data to search

Source: The Gift of Script: Search spreadsheet for multiple criteria