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.
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!
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.
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.
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.
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
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.
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.
You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.
Interesting to see Google extending the functionality of Google Sheets with this official add-on
Alice Keeler’s architecture on designing your Google Forms to provide immediate feedback by utilizing branching options is fascinating and efficient.
Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be taken to a section with a tutorial or hint and a chance to answer a new question.
A short promo video from the official G Suite account showing users how to install add-ons in Google Sheets, which developers might find useful to reference or see how to structure their own add-on videos.
It’s been a while since we’ve posted updates on the Google Sheets Add-on “Formulas by Top Contributors”, but now the time has come around to make up for that !