AppsScriptPulse

Solutions, Docs

Students use Google Apps Script to quickly identify overused words in a body of text

Tags:
| | 0 Comments |

Great to see some new young Google Apps Scripters at work

Docs, Forms, Sheets, Slides

TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥

Tags:
| | 0 Comments |

In my previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.

Source: TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥

Snippet, Solutions, Docs, Drive, Gmail, Sheets

Bulk save emails from Gmail

Tags:
| |

Screenshot of setup sheet for tool.

Screenshot of setup sheet for tool.

This tool is designed to bulk save emails (and associated attachments) from a specified Gmail label into a Google Drive folder, with relevant threads combined into a single PDF document.

Source: The Gift of Script: Bulk save emails from Gmail – overview

Snippet, Solutions, Docs, Drive

Convert Doc to PDF and move into a new folder with Google Apps Script

Tags:
| |

Create a PDF version of a Google Doc, move it into a new folder, remove its parents so it only exists in the new folder (typically also exists in My Drive) and then trash the Doc.

Source: The Gift of Script: Convert Doc to PDF and move into a new folder

Add-on, Solutions, Docs

Use Google Apps Script to Securely Share Google Docs

Tags:
| | 0 Comments |

It actually is really easy to add the Virtru SDK to your project, as I’ll demonstrate through the construction of a “Protect & Share” Google Docs add-on.

I’m not familiar with Virtru but in this post from Trevor Foskett (Senior Solutions Engineer at Virtru) shows how their product can easily be integrated into Google Docs as an add-on. You’ll hopefully find this post useful to find out about Virtru as well as how client side and server side processing can be handled using Google Apps Script.

Source: Use Google Apps Script to Securely Share Google Docs

Solutions, Docs

Send automatic FYI emails for Meeting Action Items

Tags:
| |

Now you can get the Action Items (AIs) delivered right to your inbox! Joanna Smith’s (@dontmesswithjo) custom solution to integrate Google Docs with Apps Script allows you to send everyone a personalized list of their AIs at the end of every meeting.

Source: Send automatic FYI emails for Meeting Action Items

Solutions, Docs, Forms, Sheets, Slides

Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode

Tags:
| | 0 Comments |

 

I wanted to update one of my free Google Add-on apps that works with colour. What I had is just the standard HTML color input element where the user selects from the palette and that hexadecimal colour code … had always wanted to create a tool for a sidebar or dialogue box that would allow the user to easily access the standard colours or use the custom palette provided by the HTML color input”

Continue reading this post to find out how you can implement your own copy of the colour picker

Source: Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides – Yagisanatode