[SMK] Social Media Knowledge


Martech Mashup: Macros in Google Sheets

Office aficionados are often proud of macro manipulations that streamline work flows. But not all productivity suites are equal.

Now, macros have launched in Google Sheets.

How to macro

Macros are series’ of actions recorded within an app, that can be replayed when needed. They can speed up your reporting a lot.

To record one in Sheets, open the ‘Tools’ menu, hover on the ‘Macros’ item and click ‘record’. Perform the actions you want recorded, then click ‘save’.

To replay the saved actions takes two clicks, or your can assign a keyboard shortcut for frequently-used favourites.

G Suite have published a pro-tip tutorial on YouTube that sums it all up in a tidy two minutes and thirty-six seconds.

Who needs code?

Macros are saved as a script that can be replayed whenever the user wants. Users don’t need to know scripting language nor write any code: the record and save buttons do all the work within the app.

That said, Google is letting code-savvy folks edit the recorded scripts directly, or even write their own macros from scratch.

Micro macros

By recording macros in Sheets, G Suite chalks another one up against rival Microsoft Office.

Indeed, the blog post that launches the capability links to a guide on how to make the leap from Microsoft’s Excel to Sheets.

What are the main obstacles that Google must yet overcome to take down Microsoft Office as the default productivity suite?

Copy Transmission is a Melbourne-based agency :: Better Brands. Loud & Clear.

Learn with SMK through March

Start your SMK: Digital Excellence 30-day free trial today and unlock unlimited, on-demand access to hundreds of hours of digital masterclasses, training courses and hands-on tutorials.

Your risk-free trial offers the perfect opportunity to expand and upgrade your digital intellectual property.

Each month SMK releases 30 hours of new and updated social media and digital marketing educational course content, ensuring you never get left behind – be it on digital strategy, tactics or implementation.

Alongside this, SMK offers live help and support weekly within the SMK Working Group. It might be a quick fix or the root of a bigger problem; either way, a problem shared is a problem halved. On a day-to-day basis, SMK’s team gives you hands-on support and fresh ideas.

Not to mention a shoulder to cry on, occasionally

March SMK Courses, Live Help & Support Options

Live Member Clinics every Monday & Tuesday from 1 pm – 2 pm AEDT

  • Live help and support from SMK’s team of analysts.
  • Book in to request a personalised discussion for 15 or 30m via Zoom within the Facebook Working Group.

Weekly Technical Labs: TikTok on Wednesdays from 1 pm – 2 pm AEDT

  • Technical Labs explore the technological process and workflows related to key digital marketing activities.

Google Analytics Masterclass on Thursdays from 10 am – 12 pm AEDT

  • Module 1: GA4 Optimisation, Key Features, Tools & Reports
  • Module 2: Setting up GA4 Conversions & Understanding Analytics Events
  • Module 3: Analytics Campaign Tracking and Report Analysis
  • Module 4: GA4 Round-up, Conversion Attribution & Visualisation

Influencer Marketing Masterclass on Fridays from 11 am – 1 pm AEDT

  • Module 1: 2023 Influencer Marketing Trends, Forecasts & Opportunities
  • Module 2: Organic Influencer Marketing Best Practices
  • Module 3: Optimising Influencer Campaigns With Social Ads
  • Module 4: Evaluation, Reporting and Influencer Commerce 

Leave a Comment