AppsScriptPulse

Solutions, Sheets, V8, Video Tutorial, Beginner

How to access an API with Google Apps Script and API calls and Google Sheets manipulation

Tags:
| | 0 Comments |

In this video you will learn how to access an API with Google Apps Script.

Chanel Greco has created this video tutorial which walks through some different ways you can interact with other sites with Google Apps Script to get data into Google Sheets. For the tutorial Chanel uses the Weather API and by coincidence Luxman Ravindrakumar has also shared a similar tutorial on Medium explaining how to use the OpenWeather API. So if you prefer learning by watching or reading you’ve no excuses :). Check the sources links below for both tutorials.

Sources: How to access an API with Google Apps Script (YouTube) and API Calls & Spreadsheet Manipulation With Google Apps Script

Solutions, Gmail, Sheets, Video Tutorial, Beginner

Create multiple labels in Gmail with Google Apps Script

Tags:
| | 0 Comments |

With this reusable script you can create multiple labels in Gmail whenever you need to do so. All you have to do is create the script as shown in the video and then use it to create multiple Gmail labels in one go.

Continuing the Gmail label theme in this latest video tutorial from Chanel Greco you can learn how to batch create Gmail labels from data in a Google Sheet.

Solutions, Sheets, Video Tutorial, Beginner

Google Apps Script: How to export Google Sheets as PDF – YouTube 

Tags:
| | 0 Comments |

In this video you will see how you can use Google Apps Script to export a Google Sheets document as a PDF

It’s been a while since we featured a video tutorial from Chanel Greco, but that doesn’t mean she hasn’t been busy. In this recent tutorial from Chanel you can learn how to use Google Apps Script to export a Google Sheet as a PDF Document. You can watch this and other videos from Chanel on the saperis YouTube channel.

Source: Google Apps Script: How to export Google Sheets as PDF

Snippet, V8, Video Tutorial, Beginner, Docs

Google Apps Script Tutorial: Letterhead in Google Docs

Tags:
| | 0 Comments |

In this Google Apps Script tutorial you will learn how to automatically create a letterhead in Google Docs.

This is a nice short video tutorial from Chanel Greco highlighting how you can manipulate a Google Doc header using Google Apps Script.

Solutions, Gmail, V8, Video Tutorial, Beginner

How to Automatically Archive Gmail Messages and update your Gmail signature with Google Apps Script

Tags:
| | 0 Comments |

Chanel Greco at saperis has shared some useful video tutorials that should help beginner Google Apps Script developers with working with Gmail:

In this Google Apps Script tutorial we will learn how to automatically archive Gmail messages.

In this video tutorial you will learn how to create an email signature in Gmail.

Solutions, Sheets, YouTube, Video Tutorial, Beginner

Google Apps Script Example: Automated YouTube Stats Workflow

Tags:
| | 0 Comments |