Posts tagged with: automation

A macro is a simple way to automate repetitive tasks in Google Sheets. Using a macro, you can record a set of actions and then reuse them in the future with just a single click.

Instead of inserting charts manually, you can use Macros to automate this process.

Learn how to automatically send PDFs from your Google Drive to your Kindle device using Apps Script. Streamline your reading and save time with this easy setup.

Automate reminders for recurring annual events using Google Sheets and Calendar

In this post, I'll teach you how to automatically email a Google Sheet as as a PDF attachment from within Google sheets itself.

Learn how to use Google Sheets and email reminders to remember birthdays.

Learn how to use Apps Script to center images in a Google Slides presentation.

Learn how to use Apps Script to create a slide in a Google Slides presentation for every row in a Google Sheets spreadsheet.

Learn two ways to create a copy of a Google Slides presentation using Apps Script.

Learn how to automate parts of your content creation workflow using Apps Script.

Learn how to build a simple expense report approval workflow using Google Forms, Google Sheets and Google Apps Script.

Automatically generate Google Slides presentations using data from a Google Sheets spreadsheet.

Learn how to automatically sort your Google Form's responses so you'll always see the most recent ones at the top.

Learn how to automatically import CSV files from a URL or from Google Drive into Google Sheets using Apps Script.

With just a few lines of code you can insert images from Google Drive into Google Slides using Apps Script.

Learn how to create personalized student certificates by mail merging data from Google Sheets into a Google Slides template.

Learn how to send personalized emails from Google Sheets using Mail Merge.

Learn how to programmatically insert images into a Google Slides presentation using Apps Script.

Learn how to build a simple mood tracking app using Google Sheets.

Learn how to use Google Sheets and Apps Script to receive an email every morning with a motivational quote.

This tutorial will teach you how to send an email for every row in a Google Sheet.

If you've worked in any organization of any size, you've probably had to put together and send reports on a regular basis to your team. In this post, I'll show you how to automate sending emails from Google Sheets based on a schedule.

Learn how to automatically send email notifications whenever your Google Sheets spreadsheet is edited.

Learn how to send HTML email from Google Sheets using Apps Script. I'll also show you how to create the HTML email template using Gmail and Google Docs.

Triggers enable you to automate your tasks and workflows in Google Sheets. In this article, you'll learn more about triggers, how they work and how to create them.

Learn how to implement a simple website monitoring solution using Google Sheets and Apps Script.