Record macros in Google Sheets


Try G Suite Free

Introducing G Suite Pro Tips, quick tutorial videos to help you automate simple tasks at work. In this video, a G Suite Developer Advocate explains how to record macros in Google sheets with Macro Recorder, a tool that lets you record time-consuming actions in Sheets and play them back.

Telephony Solutions with G Suite


Try G Suite Free

Alongside messaging and video conferencing, phone calls are a critical business communication channel. G Suite has been working to make it easier for customers to deploy and manage telephony solutions integrated with other applications in the suite. Join us to hear about exciting new ways we are bringing telephony to G Suite. This session will give you an overview of our overall approach and roadmap in this space.

Record macros in Google Sheets


Try G Suite Free

We want to help companies automate work by approaching macros differently: cloud-first. The Google Sheets macro recorder lets you record actions (no matter how micro) and play them back on command without having to write any code.

Starting today, you can record macros in Sheets. Let’s say you need to format new data imports or build the same chart across multiple sheets of quarterly data. Repeating the same steps manually can take hours, but the Sheets macro recorder lets you record those actions and play them back on command without having to write any code.
Record macros in Sheets, skip mundane tasks

Here’s how it works: when you record a macro, Sheets converts the macro actions into an Apps Script automatically. If you want to update your macro, you can simply edit the script directly instead of having to re-record the macro from scratch. You can also write your own Apps Script functions and import them as new macros.

The best part about Sheets Macros is that they’re built for use in cloud-based files, which means that teams can run macros at the same time that others are working in the sheet without interrupting them. For example, a finance team having a budget meeting can run macros while reviewing the same spreadsheet. It also means that coworkers or clients won’t be forced to download sensitive files to use your macros. Since your Sheets files are in the cloud, you can keep tighter controls over who can view and re-share your data.

Secure Your Business Data with Google Vault


Try G Suite Free

Jimmy and Kevin tackle cookie….er, I mean…data security for your business. Using Google Vault with your G Suite products (Gmail, Drive, Hangouts, Groups) you are able to:

– Make sure the right data from your company is there and secure
– Get the data you need when you need it. Legal request, compliance requests, etc.

They walk through how to set parameters for your admins, teams, and individuals within your organization.

Smart Reply for Gmail


Try G Suite Free

It’s pretty easy to read your emails while you’re on the go, but responding to those emails takes effort. Smart Reply, available in Inbox by Gmail and Allo, saves you time by providing pre-written responses to your messages.

It already makes up 12% of replies in Inbox on mobile. And starting today, Smart Reply is coming to Gmail for Android and iOS too.

New Video Conferencing Experience with Hangouts Meet


Try G Suite Free

Hangouts Meet is a new video meeting experience with one goal: make joining meetings effortless so that people can be as productive as they are when they’re face-to-face.

Jenny and Lily share the latest updates on Meet.

1. Unique, short URLs for each video meeting, automatically set up when you add your first guest.
2. Dial-in access to every video meeting with a randomly allocated US number and PIN.
3. New enterprise focused, lighter UI which uses fewer client resources, loading faster and running more reliably.
4. Meet app for two-click access to meetings with vivid detail of presentations.
5. A scalable experience such that up to 5 active participants are visible while less active participants are included in an expanded toggle-able participant list. Currently, 25 devices can be added to a meeting (30 for Enterprise).

Create Apps Easily with App Maker


Try G Suite Free

Kevin recently joins the G Suite Show and wants to get to know all of the different teams we work with. With the help of App Maker, he’s able to develop an app to help organize teams.

App Maker is a low-code, application development tool that lets you quickly build and deploy custom apps tailored to your org’s needs. Build in days instead of months. Today’s example include onboarding new team members with a directory. Using G Suite tools, your business’s IT department or citizen developers (analysts or system admins) can quickly iterate and prototype all the way to deployed app.

Have an idea for an app that can help with your business?