Whether you are in sales, marketing, education, project management, data analysis, etc., it’s common for people to want to send emails to multiple recipients with information that is customized to each. In this episode, learn about Martin Hawksey’s mail merge solution, which helps anyone send emails with customized content from a Google spreadsheet, and Gmail.
See the YouTube description for all the links you need.
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
Everyone has their own superpowers. Whether you’re an Data Analyst, Data Scientist, Task Automater, or Programmer, you can use G Suite to support these talents. In this video, we’ll go over what tools you can use to support these different talents.
We’ve gone over the basics of App Maker, but now it’s time to explore the interface further. Alexandrina Garcia-Verdin goes over how to utilize and modify tools and widgets, in this episode of Sheets to Apps!
🗺️ Develop Locally:clasp allows you to develop your Apps Script projects locally. That means you can check-in your code into source control, collaborate with other developers, and use your favorite tools to develop Apps Script.
The Apps Script IDE is great, but with larger projects, I know I’ve wanted to be able to use a more powerful IDE. clasp (Command Line Apps Script Projects) is a CLI that allows you to start, write, test, and deploy Apps Script projects from any text editor you want.
I’m a public school teacher writing Apps Script projects to manage documentation and to make life easier in general. You can read more on my blog, blog.ohheybrian.com or follow me on Twitter, @bennettscience.
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
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.
Welcome to the Sheets to Apps Show, where we talk about how to tame endless spreadsheets into productive applications. App Maker is a tool that empowers a wide range of individuals in an organization to turn important processes that live in spreadsheets. Join us and see how App Maker can help you in your everyday tasks!
10 years ago this week we introduced Google Apps Script, G Suite’s scripting platform. What started as a small experiment has grown into one of Google’s most popular developer products. To commemorate the moment, I sat down with Mike Harm, the creator of Apps Script, to reflect back on how it all got started.
Back in May we announced a pilot release of Google Apps Script, and after thousands of hours of use, and lots of valuable feedback, we’re excited to launch Google Apps Script to all Google Apps Premier and Education Edition customers today.
This was the news posted on 19 August 2009. Accompanying the original launch post is a video recorded by Jonathan Rochelle in which you can see just how far Google Apps Script has come:
The G Suite Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with G Suite Developer technologies. These samples showcase different ways to integrate and customize the productivity tools you’re already using.