Open an existing spreadsheet in Google Sheets and head to the Apps Script menu (refer to the steps above). We deleted the existing code and entered a code below to convert the sheet into a table.

This script produces a mini-app that does repetitive and time-consuming actions for you. Macros came to Sheets in 2018, but the feature has yet to make its way to Docs and Slides.

Here are the things you can manage. LAST_N_DAYS = 30 This sets the number of days the script looks back from today. If you want to use a longer lookback window, simply increase this number.

Learn how to use and get the most from Google Docs, Sheets, Slides, Meet, Keep, Forms, Gmail, and other apps in Google’s Workspace productivity suite. From its humble origins as a collection of ...