AppsScriptPulse

Add-on, Official News, Sheets

Build Apps Powered by Language with Semantic ML with the new Semantic Reactor Google Sheets Add-on

Tags:
| | 0 Comments |

In this post, I’ll show you how to use beginner-friendly ML tools–Semantic Reactor and TensorFlow.js–to build an app that’s powered by natural language.

NEW: Semantic Reactor has been officially released! Add it to Google Sheets here.

We’ve previously highlighted how TensorFlow.js can be used in Google Apps Script. In this latest example the new Semantic Reactor Google Sheets Add-on published by Google Research is highlighted. Semantic Reactor is designed to make it easier to start exploring Natural Language Understanding (NLU) and with this tutorial you can learn how you can deploy your model to code.

Source: Build Apps Powered by Language with Semantic ML

Add-on, Solutions, Sheets

Lessons Learned building an Apps Script Add-on | Two Octobers

Tags:
| | 0 Comments |

After joining Two Octobers this March, I was overjoyed to be able to focus on building tools that we can use to help grow client revenues. One tool that I had percolating in the back of my mind was a Google-Sheets-based Add-on for building and managing Google My Business Posts. Our team, codenamed “Skunkworks”, got to work and built our Add-On, AgencyAutomators – POSTS. While in the moment it felt like one small step for each of us, it felt like a huge leap for Two Octobers. We learned a ton along the way that I’ll be sharing with you here.

A very comprehensive guide on the challenges and solutions for developing Google Apps Script projects in teams. The post has lots of tips and tricks Noah and his team at Two Octobers learned along the way including hurdles overcome as part of the Add-on publication process. Follow the link for more details.

Source: Lessons Learned building an Apps Script Add-on | Two Octobers

Add-on, Gmail

Building a Gmail Add-on with Apps Script

Tags:
| | 0 Comments |

I recently sent an email where I typed code inline in the message body. I spent a good 15 minutes going through and formatting each line of code to look like, well, code. I wanted an extension like Code Blocks that would instantly format my text to a specific preset style.

A well chronicled article by Kelsey Kripp on how to dive right into Apps Script for G Suite to build your own Gmail add on!

Source: Building a Gmail Add-on with Apps Script

Add-on, Docs

Code Blocks – Syntax Highlighting for Google Docs

Tags:
| | 0 Comments |

Syntax highlighting for Google Docs

With the Code Blocks add-on for Google Docs you can create formatted code blocks using a wide variety of themes and language support for syntax highlighting. This is a great add-on for anyone wanting to create technical training materials in Google Docs.

Source: Code Blocks – G Suite Marketplace

Add-on, Docs

Docs to Markdown Add-on

Tags:
| | 0 Comments |

Drive add-on that converts a Google Doc to simple, readable Markdown or HTML.

This add-on is helpful for anyone doing technical writing or producing technical content. With Docs to Markdown, you can easily export the content of your Google doc for publication on a variety of other web-based platforms or CMSs.

Source: Docs to Markdown – G Suite Marketplace

Add-on

Adobe’s new Gmail add-on lets you access Creative Cloud – 9to5Google

Tags:
| | 0 Comments |

Back in January, Google widely launched G Suite Add-ons to allow third-party integrations across products like Calendar and Drive. Adobe today announced a plug-in that lets Gmail users quickly access Creative Cloud.

“While new collaboration channels are all the rage, business email is actually on the rise with individuals sending and receiving more emails every day. Bringing Creative Cloud into G Suite enables our mutual user base to simplify routine tasks while staying productive in their inbox,” says Sid Arora, Product Manager, Adobe Creative Cloud.

Always nice to see well established third parties using Google Apps Script.

Source: Adobe’s new Gmail add-on lets you access Creative Cloud – 9to5Google

Add-on, Official News

G Suite Updates Blog: G Suite Add-ons now generally available in Calendar, Gmail, and Google Drive

Tags:
| | 0 Comments |

Take action without leaving G Suite

Image credit: Google – Take action without leaving G Suite 

Last year we announced the beta of G Suite Add-ons, a new cross-suite platform that connects G Suite to your favorite workplace apps. Beginning today, G Suite Add-ons will begin rolling out to all users.

Whilst the Add-on ecosystem is being extended making them generally available to end users developers will have to wait until you can start developing new add-ons for G Suite:

Organizations can also build their own add-ons using Apps Script. Note that the developer feature will be fully available in early February

Source: G Suite Updates Blog: G Suite Add-ons now generally available in Calendar, Gmail, and Google Drive

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

Add-on, Community News, Sheets

QUERYX allows you to use SQL queries in sheets

Tags:
| | 0 Comments |

QUERYX allows you to use sql queries in sheets.

Those familiar with Google Sheets will probably want to know how this is different to the built-in QUERY() function, the answer is this is add-on enables a full SQL. Following the source link gives information on how to access this add-on.

Source: [PROMO] QUERYX allows you to use sql queries in sheets. – Google Groups

Add-on, Solutions, Sheets

Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets

Tags:
| | 0 Comments |

Learn how to use Goal Seek in Google Sheets. The Goal Seek feature enables you to change input values to make a formula result match the goal you specify.

We’ve highlighted the new Goal Seek Add-on previous in Pulse, but if you missed it or wanted to see some more practical use cases Ben Collins has expertly covered how to setup and use it.

Source: Goal Seek in Google Sheets – How To Use Goal Seek In Google Sheets