How-to Guides - Page 3 of 128

How to Save Password Protected PDF Attachments from Gmail to Google Drive

Learn how to save password protected PDF attachments from your Gmail to Google Drive automatically. The PDF files will be saved to Google Drive as unencrypted PDF documents that can be opened without entering the password.

How to Send Google Forms with Pre-filled Answers

How to pre-fill answers in Google Forms using data from a Google Sheet and send the pre-populated Google Forms as personalized emails.

How to Send Base64 Images in Email with Google Apps Script

Gmail will not render base64 images embedded inside HTML emails but with Google Apps Script, you can use blobs to send the base64 encoded images

Monitor Your Stock Portfolio with Google Sheets and Receive Daily Email Reports

How to use Google Sheets to monitor your stock portfolio. Get daily performance reports in your email inbox at a scheduled time.

Schedule a Phone Call to Yourself and Politely Escape any Boring Situation

How to Embed Images from Google Form Responses in Documents

How to use Document Studio to embed uploaded images in generated documents from Google Forms responses.

How to Mail Merge with Outlook and Google Sheets

If you are an Outlook or Microsoft 365 user, you can still use Google Sheets to send personalized emails to multiple people at once with the help of Mail Merge.

How to Extract Images from Google Docs and Google Slides

Learn how extract all the embedded images from a Google Document or Google Slides presentation and save them as individual files in a specified folder in your Google Drive.

How to Mention Someone in a Slack Message from Google Forms

Learn how to send messages to Slack from Google Form and Google Sheet. You can also tag or mention a Slack user in the chat message.

How to Edit Any Web Page in your Browser

How to Use Cron Expressions to Create Time Triggers in Apps Script

How to work with Cron Expressions inside Google Apps Script and setup time triggers for scheduling task at recurring intervals.

How to Enable Duet AI in your Google Workspace

Duet AI is an AI-powered assistant for Google Workspace that can assist in you in tasks like drafting emails, formatting tables or crafting compelling presentations.

Post Google Forms Responses to Discord Channels

Learn how to automatically send form responses collected through Google Forms on a Discord channel with the help of Document Studio. The tutorial also provide instructions on how to use Apps Script to post form responses to Discord using webhooks.

How to Enable Push Notifications for File Changes in Google Drive with Apps Script

How to setup push notifications to monitor changes in your Google Drive files with Google Apps Script

How to Create Personalized Images in Bulk with Google Sheets

Learn how to auto-generate personalized images in bulk with Google Sheets. You can create uniqe and personalized business cards, employee badges, student certificats and more with minimal effort.

Emojis in Google Sheets

Learn how to use emojis in Google Sheets and the challenges they pose during conversion of Google Spreadsheets to PDF files.

How to Link Postal Addresses to Google Maps in Google Sheets

Learn how to make postal addresses clickable in Google Sheets with a formula. Create hyperlinks that directly link an addres to Google Maps places.

How to Email Google Sheets Automatically on a Recurring Schedule

Email spreadsheet reports and dashboards on a recurring schedule. You can email entire spreadsheet, specific sheets inside a workbook or even range of cells.

Create a BMI Calculator using Google Forms and Google Sheets

Build your own BMI calculator app with Google Forms. The BMI report is generated in Google Sheets and the user receives an email with the BMI score.

SlideCasts - Sync YouTube Videos with your Google Slides Presentation

How to Transcribe Audio and Video Attachments in Gmail

Learn how to automatically transcribe audio and video files in Gmail messages with the help of OpenAI speech recognition API and Google Apps Script

How to Send a Welcome Email to Google Form Respondents

This tutorial explains how you can send a welcome email automatically to people who fill your Google Form. You can also attach files from Google Drive to the email notification.

How to Create Zoom Meetings with Google Script

How to use the Zoom API to automatically create and schedule Zoom meetings with Google Apps Script

How to Sort Google Sheets Automatically with Apps Script

If you are working with a Google Sheet that has a large number of tabs, it can be difficult to find the sheet you need if they are not organized properly. Use Google Apps Script to sort sheets automatically

Find Free Udemy Courses with Google Sheets and the Udemy API

Learn how to use the Udemy API with Google Apps Script to find free programming courses on Udemy on any topic.