Academy ↓
Hey there stranger!
Sign up to get access.
How to Trigger Macros Daily
About this Tutorial
Sheet Resources
Featured Formulas
Video Transcript
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
Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1
Tips to Navigating Thousands of Lines of Code In Apps Script
How to Write a Function - Learn to Code in Google Sheets Part 2
From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3
Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4
Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5
Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6
Write Your First Script
00:08:31
How to Record Macros
00:06:20
How to Edit a Macro
00:08:22
How to Trigger Macros Daily
00:06:58
Automatically Uncheck A Daily Checklist
How do I reference a different spreadsheet in Apps Script?
Sheet Stories / Video Notes + ADDED: Email Notifications
00:00:00
Fast FAQS
ChatGPT Clone in Google Sheets Part 2
Create an Internal Google Sheets Add-on
Why Different Cell References in AI Integration in Sheets?
Show Sheet Tabs Based on Edit
Add Title Case to Google Sheets
Getting Started Coding in Apps Script
How to Power Testimonials with Google Forms and Sheets
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
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Embed a Headline in a Website from Google Sheets
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