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.