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?

Collaborate and Store Files with Team Drive

Try G Suite Free

Team Drive is your team’s solution for file management.

In this episode, Jimmy and Jenny walk through how Team Drive is different from your person Drive. It’s easy to add members to a Team Drive and change permissions to those who have Full, Edit, Comment, and View access. G Suite Administrators also have more control on what content gets uploaded, shared, and deleted.

No more missing files when a team member leaves. Also, when someone joins, all of the existing content lives in one shared Drive. You can also add outside members to the a particular Team Drive if you are working on a project together. Keep in mind your company either needs to allow this for all employees.

Update Your To-Dos with Keep

Try G Suite Free

Great ideas can surface in unexpected places. We created Keep to capture your thoughts anytime, anywhere—with smart tools to help you easily organize your notes, ideas and to dos.

Jimmy and Jenny walk through the new features for Keep, which is now a core product of G Suite. In addition, Keep now works with Docs for easier brainstorming. You can also download the Chrome extension to add special notes to URL’s you may come across. Keep’s mobile app works with Android and iOS, and across apps.

Turn your Gmail into a business account | Gmail

Try G Suite Free

It’s widely known that many small business owners have been using their personal Gmail accounts for business email. This is partially because there has never been a seamless way to migrate your Gmail account into a business account.

Thanks to the Apps team, now there’s an easy way to migrate over contacts, data, and files. (Check out more here: )

Additional benefits to owning a business account through Google is the 24/7 support just a phone call away, more storage for your Drive and email, and advanced security and spam filters.

With Google Apps you can keep all your business data and information under your administration. You can also manage your domain as well if you bought it via Google Domains. Now your domain and your email will be with one company.

Boost your productivity using Gmail | Gmail

Try G Suite Free

A recent study published by McKinsey shows that we spend on average more than ¼ of our workweeks reading, writing or responding to emails. It is a fact that employees are inefficient at organizing and prioritizing their emails. Fortunately, Gmail offers great features that help us solve these problems. In this episode, Jimmy and Drea go through their favorite Gmail labs and give us some valuable inbox productivity tips.

First tip: try to centralize your information in your Gmail as much as you can. It might be cumbersome to constantly switch tabs between Calendar, Hangout and Gmail. So why not centralizing everything in only one place? Jimmy shows us the benefits of selecting the “Right Side Chat” Lab (that you can find by selecting the Settings cog and then the Settings tab). If you’re a heavy users of Hangouts and need to be reactive to an incoming chat, this feature will allow you to see more Chat users on the right-hand corner. And in the space created by moving your Chat to the right, now you’ll be able to display your calendar window (thanks to the Google Calendar gadget) or Quick Links! Quick links is a feature that allows you to generate links to the most used sections of your Gmail (eg: your Settings section).

Second tip: improve your inbox management, by installing 4 key features. 1) Canned Responses. It is a tool that may save you hours of weekly work! If, like Drea, you constantly get repetitive questions from your clients, follow these two simple steps: first, draft a standard answer to these questions, second store them in your Gmail Canned Responses widget. Now you’ll be able to paste them in your emails in a couple of clicks! 2) Mute button: don’t forget to use it in threads where you have become irrelevant and in which you don’t need to take action. By muting these threads, you won’t be distracted at each time someone answers it. 3) “Send and Archive” feature. It is another solution to clearing irrelevant conversations. You can install the “Send and Archive” button in your Settings. Once you select this option, you won’t get notified by an answer to the email you have sent. 4) Desktop notifications: if your work is very time sensitive and you need to be aware of your incoming emails as soon as they hit to your inbox, this pop-up notification was made for you.To switch them on go to Gmail Settings. And then find Desktop Notifications.