Logger

What it does

Write messages to the Apps Script execution log for debugging.

Methods used

.clear() .log()

Related snippets

Official Google docs

Explore

Related methods

  • .log()

    Writes a message to the execution log.

  • .clear()

    Clears all messages from the execution log.

  • .getLog()

    Returns everything currently in the execution log.

More Apps Script

Better Sheets tutorials

2 New Ways To Add Emoji Reactions

2 New Ways To Add Emoji Reactions

 Revolutionize the way you react with emojis! Discover two new methods t...
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

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

Create a click Edit: Google changed how the redirect is handled. It no l...
Advanced
HYPERLINK()
Add Tasks to Google Tasks From Google Sheets

Add Tasks to Google Tasks From Google Sheets

Create tasks in Google Tasks from Google Sheets using Apps Script
Advanced
Automate Form Response to Confirmation Email

Automate Form Response to Confirmation Email

Create an email automatically when someone fills out a google form. incl...
Advanced
Automate Google Sheets With Zero Experience

Automate Google Sheets With Zero Experience

By the end of this video you should be knowledgeable about how to automa...
Beginner
Automate Help Desk Ticket Closing

Automate Help Desk Ticket Closing

Create a simple automated help desk ticketing system. • Create tickets C...
Advanced
AVERAGE() COUNTA() COUNTIF() FILTER() IF()
Automatically Backup a Spreadsheet

Automatically Backup a Spreadsheet

Make a copy and rename to BACKUP plus the Date of the backup. Execute th...
Intermediate
Basic CRM - Add a Powerful Script To Move Row Based on Status

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

we're going to be adding a very powerful script to our CRMs or any datab...
Advanced
Better Sheets Videos Checklist

Better Sheets Videos Checklist

How to create a video checklist. Create a sheet with check boxes that yo...
Data validation Beginner
COUNTA() COUNTIF() FILTER() IFNA() SORT() +1 more
Breaking Through Errors In Apps Script

Breaking Through Errors In Apps Script

See where to find errors in your apps script and how to fix them. You wi...
Intermediate
Brighten Up Your Checklist Automatically

Brighten Up Your Checklist Automatically

Create a cool function that brightens your sheet background from white t...
Intermediate
Built a Cookie Clicker Clone in Google Sheets

Built a Cookie Clicker Clone in Google Sheets

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hou...
Advanced
Can I Automatically Rename a Sheet based on a Date?

Can I Automatically Rename a Sheet based on a Date?

Change the title of a spreadsheet from within a cell in the spreadsheet.
Intermediate
DAY() MONTH() TODAY() YEAR()
Can I get alerted when a tab name is changed?

Can I get alerted when a tab name is changed?

Find out in this quick experiment if a tab name can be alerted to the ow...
Celebrate Your Completed Checklists

Celebrate Your Completed Checklists

Learn how to use apps script to add emoji animations when you complete a...
Advanced Intermediate
COUNTA() COUNTIF() FILTER() IF() IFNA() +3 more
Close Form After Certain Number of Responses

Close Form After Certain Number of Responses

Create automatic triggers that close a form after a certain number of re...
Intermediate
Create an Automated Task List

Create an Automated Task List

I've created simple automations to make an awesome automatic task list. ...
Intermediate
Create a PR Agency From Scratch

Create a PR Agency From Scratch

Go from nothing to a working PR agency. Capture sites, and Send email vi...
Intermediate
ARRAYFORMULA() FILTER() JOIN() SPLIT()
Create a Stop Watch in a Google Sheet

Create a Stop Watch in a Google Sheet

We'll create a stop watch from scratch. Including Apps Script. What it w...
Create a Timer with Apps Script

Create a Timer with Apps Script

Create a start time and end time and duration of that, with a little bit...
Intermediate
IF() ISBLANK()
Create Your Own Pride Flag Easter Egg in Sheets

Create Your Own Pride Flag Easter Egg in Sheets

If you type the letters of PRIDE in the first 5 columns in the first row...
Conditional Formatting Advanced
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

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

Find out how to automatically delete rows based on a cell's value. We do...
Advanced
Email Certain Department Based on Google Form Entries

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.
Advanced
Email Myself a Daily Random Motivational Quote

Email Myself a Daily Random Motivational Quote

Quickly make a daily email to myself with a motivational quote.
Beginner
Embed Quote and Author to Daily Quote Website

Embed Quote and Author to Daily Quote Website

Step by step tutorial to update random quote site to show both Quote and...
Advanced
Enter Google Drive File Name Get URL

Enter Google Drive File Name Get URL

Create a simple automation with an installable trigger that allows you t...
Intermediate
Fast FAQS

Fast FAQS

New Tool for you: Fast FAQs. Create a quick 10 question FAQ for any new ...
Form Automations: Close Multiple Forms When Over Limit

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations: Allow User to Reopen form without Apps ...
Advanced
Get Every Editor on Every Google File I Own

Get Every Editor on Every Google File I Own

Get every editor if you're looking for the sheets and documents you've s...
Google Maps Scraper for Outreach

Google Maps Scraper for Outreach

Get this fun template to search on google maps via API, and quickly mess...
Intermediate
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

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

There was a stories craze. Every app/platform/business was adding 24 hou...
CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more
How to Merge Cells in Google Sheets

How to Merge Cells in Google Sheets

A master class on merging cells. How to merge two cells. How to merge mu...
Beginner
CONCATENATE() JOIN()
How to Turn Background Color to Text

How to Turn Background Color to Text

This tutorial showcases a practical solution to convert visual cues into...
Intermediate
How to Validate Email Addresses

How to Validate Email Addresses

 I will show you how to validate email addresses using the Mailboxlayer ...
Intermediate
Idea Graveyard - Create a Decaying Checklist

Idea Graveyard - Create a Decaying Checklist

Build a simple function that deletes undone items in our checklist.
Intermediate
Introducing SheetFools

Introducing SheetFools

Free google sheets automations pranks you can use right now. Launching p...
Intermediate
Learn to Code in Google Sheets, For Programmers

Learn to Code in Google Sheets, For Programmers

Google Sheets uses a scripting language called Google Apps Script, which...
Intermediate
IMAGE()
LinkTree in a Google Sheet

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.
Advanced
Manage Your Wedding Guest List in Google Sheets

Manage Your Wedding Guest List in Google Sheets

Learn how to manage any event with RSVPs and multiple organizers. Use Go...
COUNTA() COUNTIF() FILTER() IFERROR() MATCH() +1 more
MicroManager: Hourly Email Reminders

MicroManager: Hourly Email Reminders

I'll show you how to set up a super powered checklist that can act like ...
Advanced
Onboarding Scheduler

Onboarding Scheduler

I will guide you through the process of creating an onboarding scheduler...
Intermediate
One Million Checkboxes

One Million Checkboxes

Check out this fun onEdit() counting you can do with checkboxes in a fun...
Beginner
Password Protecting Data In a Google Sheet

Password Protecting Data In a Google Sheet

A funky way to password protect some data in a sheet, 3 ways to do it: w...
Advanced
IF() IMPORTRANGE()
Password Protecting Data In a Google Sheet Part 2 The Basics

Password Protecting Data In a Google Sheet Part 2 The Basics

Covering some of the basics I skipped over in the part 1 video.
Advanced
IF() IMPORTRANGE()
Scoping Functions in Apps Script

Scoping Functions in Apps Script

Create multiple functions that run with the result of other functions.
Advanced
Scrape Google Maps

Scrape Google Maps

Scrape any query in Google Maps into your Google Sheets. Enter your API ...
Intermediate
Scrape Google Maps Added Phone and Reviews

Scrape Google Maps Added Phone and Reviews

Added two helper functions to get Phone numbers and reviews of the Googl...
Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Send a Daily Email with Inspiring Quote - A Little Pick Me Up

Created a daily email with a motivational quote in the subject.
Intermediate
ARRAYFORMULA() COUNTA() IF() LEN() RANDBETWEEN()
Send Better Email When Google Form Filled Out

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled...
Intermediate
Shaman: AI Blog Writer

Shaman: AI Blog Writer

I will introduce you to the power of AI writing in Google Sheets using a...
Intermediate
Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Revolutionary Method to Manage Your Video Stories! Learn how to delete o...
Advanced
CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more
Show Sheet Tabs Based on Edit

Show Sheet Tabs Based on Edit

Show a sheet or tab based on a code being entered in one sheet.
Intermediate
SOLUTIONS! Solve The Errors, Learn For Loop

SOLUTIONS! Solve The Errors, Learn For Loop

SPOILER ALERT! In this video are the full solutions to the For Loop prob...
Advanced Intermediate
Solve The Errors, Learn For Loop

Solve The Errors, Learn For Loop

Learn how to debug a For Loop. These are common errors that happen when ...
Advanced Intermediate
Spreadsheet Automation for Beginners

Spreadsheet Automation for Beginners

I start off this video with the idea to show beginners how to automate e...
Beginner
INDEX() SPLIT()
Sync Many Tabs without ImportRange()

Sync Many Tabs without ImportRange()

Sync more than two tabs with Apps Script
Advanced
Sync Tabs in Different Sections

Sync Tabs in Different Sections

How to sync different sections on different tabs. In this case we're tak...
Advanced
Sync Two Tabs Without ImportRange()

Sync Two Tabs Without ImportRange()

Get this epic script that automatically edits two tabs and keeps them in...
Advanced
Tag Emails From A List of Members in Google Sheets

Tag Emails From A List of Members in Google Sheets

Add labels to gmail emails you get from email addresses you put in a Goo...
Advanced
Take Screenshots from URLs in Google Sheets

Take Screenshots from URLs in Google Sheets

Use Screenshot One api to quickly get cached images of Screenshots and t...
Intermediate
IMAGE()
Track Every Edit (Almost)

Track Every Edit (Almost)

Create a Log sheet in Google Sheets
Twitter App Clone in a Google Sheet

Twitter App Clone in a Google Sheet

I built a twitter clone in Google Sheets
Beginner
Visicalc 2023 Design Walkthrough

Visicalc 2023 Design Walkthrough

Design walkthrough of VisiCalc 2023. Watch this if you'd like to see the...
Intermediate
Visicalc 2023 Quick Walkthrough

Visicalc 2023 Quick Walkthrough

This is a fun template I created for April 1st. Take a quick walk throug...
Beginner
SUM()

Related blog posts

Written guides about Logger in Google Apps Script.

Browse the blog

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

Read post →

How to Send Google Forms Entries Automatically with Apps Script

Google Forms provides basic email notifications for form submissions, but enhancing these notifications with detailed summaries can significantly improve productivity and response management.

Read post →

Explore Coding in Google Sheets

Did you know you can actually code in Google Sheets?

Read post →

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Explore

Academy

Tools

Add ons