Hey there stranger!

Sign up to get access.

How to Trigger Macros Daily

About this Tutorial

Automate your apps script and macros you can record.

Featured Formulas

Video Transcript

 All right. Right now we're gonna be doing one of the most time saving things ever. We are going to add a column and then copy and paste today's data along with today's date into the next column. This is really cool. Right now we have today's date, literally saying today's date Here, we have columns that have numbers here, and we have our numbers, and we wanna say, Hey, this follower account, or this sales, or this revenue came on this day.

Okay, so how do we do that? First, we're gonna use a function today. This is gray function that literally changes every single day. It tells you the date. Pretty simple, right? What We're going to record a macro and then run it every. Actually, what we're gonna do is we're gonna record a macro, we're gonna edit it, and then we're gonna run it every day.

So we're gonna right click insert, right? This is what we're gonna do. We're gonna insert that. We're gonna take this column, 'em, copy paste values. We're gonna format this to a date and. That's our what? That's what we're gonna do. Okay, so how do we do that? You already know where to record a macro. So let's record a macro for tools.

Record macro recording a new macro. Click here, you're gonna right click. Insert one to the right, go back. We're gonna copy click paste. Values only. Click in the C1 format number eight. Cool. That's it. Save. We're gonna do save daily data. Now we could do a shortcut here, but we don't want a shortcut.

We want the computer to run it every single day. Okay. First we're gonna edit the. So there's a couple things we have to do to it in order to let it run every day. So here's our macro. What that exactly as we recorded. I haven't changed anything yet. What I'm gonna do is I'm gonna delete this activate cuz we don't need it to activate.

It's gonna run without us. We want it to run on set sheet by Nope. GI sheet by. And we are going to use daily. We don't need this activate active sheet cuz there is no active sheet. It's daily. I'm gonna do command S and look, we have, let's go over what this is. It's getting the range B. It's saying insert a column, it says offset it, then copy two.

It's copy. And then it's pasting the values over here. Okay. We can also get rid of this activate, and that should go to c1, which is now the new column, and set that number format. Okay, so let's see if it doesn't. Let's go to tools. We always wanna check our macros. We'll run the macro. It's running the.

Okay, so one of the problems that I just realized is that you actually do have to include the activate if you are not on it, or it will go to a relative wherever your cursor is. So leave those activates in there and now we can be anywhere. Let's do, let's delete these to see if it works, so we can be on summary, let's run that.

Macro

and it's running the macro. Cool. So now we want this to happen every day, right? Whoever puts in these numbers might not remember to add this row, add this column and copy paste this, right? So how do we do it every single day? This is gets, it's gonna get a little complic.

Okay, so if you are in here and you wanna run a macro, you're like, Hey, this macro that I've been using every day, I would rather it just happen without me. You're gonna go to script editor.

You could probably have to dismiss this message. It's just a message telling you that they're updating. We have a macro. We know our macro is saved daily data, so you're gonna go to edit current projects triggers. We're creating a trigger here,

and so here we have a list of all the triggers. Right now we have zero triggers, so let's add one. Let's move my face over here. I'm gonna add a trigger and it's gonna choose a function. We, if you have more than one function, it's gonna be listed here. You can save daily data. You don't have to change this.

There's nothing. Change it to you do wanna change the select event source from spreadsheet to driven and instead of every hour, you wanna do it every day. You could do it every hour. That's. 24 times 365 select the time of day. Maybe just midnight to 1:00 AM is fine. If it fails, you're gonna be notified every day.

You should say that you should get this because it'll give you an email to really helpful email. I've been notified sometimes when it used to have, there used to be a limit to. The sheet size. So if it, it couldn't add a column, it would notify me. Or there was a weird thing where you needed essentially a blank.

It's it finds the last non blak. I had a script where it found the last non blank row, and then added a row after that. But if there was no blank rows, it would. And so I didn't realize this, somebody had filled in that last final row, not adding the blank row. And so it, it pinged me and said, Hey, failed.

It was very helpful. So let's save it. So now we have here owned by me head save time base, save daily desk. So you saw that information before and it's gonna run every day. And now you have a sugar that runs every. That's it. Bye.

Courses

Sheet Stories / Video Notes + ADDED: Email Notifications

00:00:00

ChatGPT Clone in Google Sheets Part 2

Fast FAQS

Why Different Cell References in AI Integration in Sheets?

Show Sheet Tabs Based on Edit

Add Title Case to Google Sheets

How to Power Testimonials with Google Forms and Sheets

Getting Started Coding in Apps Script

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 1

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

00:29:08

Hold a Giveaway Raffle in a Google Sheet

Embed a Headline in a Website from Google Sheets

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Quickstart Tutorial OpenAI API in Google Sheets

Create a new Spreadsheet from just a Name in a Sheet.

00:05:21

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

00:05:43

Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets

Create an Email Campaign Stats Calculator

00:35:13

Twitter App Clone in a Google Sheet

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet

00:11:22

Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

00:12:29

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Sync Two Tabs Without ImportRange()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

00:00:00

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case

00:07:35

Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode

00:05:10

Write Your First Script

00:08:31

Find Keywords in Any Column. Create quick search dropdown to find keywords

00:09:37

Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator

00:11:20

Let's Make a Bookmarklet!

00:12:37

Troubleshooting Bitly in a Google Sheet Script

00:07:07

Unique Features - Design a Better Dashboard Part 2

00:04:13

How To Set Up Stripe Webhook to Google Sheets with Google Script

00:22:10

How to Edit a Macro

00:08:22

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

00:35:10

Add A Timestamp to Task Lists (without Now Formula)

00:07:44

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

00:17:58

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

00:23:26

New Syntax for WhatChanged Formula in Google Script

00:07:14

How to Record Macros

00:06:20

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

00:09:53

Deep Inside Dark Habits Google Script

00:18:54

How to Trigger Macros Daily

00:06:58

5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Apps Script

00:15:01