Digital Inspiration
Tech, a la carte
Send Personalized Emails with SMTP and Mail Merge in Google Sheets
[2024-04-30 1:30 pm]The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail…
The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail…
An Improved SUBSTITUTE Function for Replacing Multiple Values in Google Sheets
[2024-04-24 1:30 pm]Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For…
Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For…
How to Extract Email Addresses from Gmail Messages
[2024-04-12 1:30 pm]A fintech startup is preparing to host its first-ever networking event for professionals within the industry. Over the course of their…
A fintech startup is preparing to host its first-ever networking event for professionals within the industry. Over the course of their…
How to Move Files Uploads from Google Forms to Specific Folders in Google Drive
[2024-04-11 1:30 pm]The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File…
The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File…
How to Add Password to PDF Documents in Google Drive
[2024-04-05 1:30 pm]The Document Studio add-on helps you create personalized PDF documents from Google Sheets. You can generate invoices , certificates…
The Document Studio add-on helps you create personalized PDF documents from Google Sheets. You can generate invoices , certificates…
How to Request UPI Payments with Google Forms
[2024-04-03 1:30 pm]Cake Studio is a local bakery that accepts orders through Google Forms. When a customer places an order, the customer automatically receives…
Cake Studio is a local bakery that accepts orders through Google Forms. When a customer places an order, the customer automatically receives…
How to Access Secrets from Google Secret Manager using Apps Script
[2024-03-29 1:30 pm]Google Secret Manager is a cloud service where you can store sensitive data such as passwords, database credentials, encryption keys or any…
Google Secret Manager is a cloud service where you can store sensitive data such as passwords, database credentials, encryption keys or any…
How to Email Screenshots of Google Sheets on a Schedule
[2024-03-27 1:30 pm]The finance team has created a revenue dashboard inside Google Sheets to track the company's sales performance over time. The dashboard has…
The finance team has created a revenue dashboard inside Google Sheets to track the company's sales performance over time. The dashboard has…
How to Create Multiple Sub-folders in Google Drive Automatically
[2024-02-28 1:30 pm]A teacher would like to create separate Google Drive folders for each student in her class. Within each student's folder, there will be…
A teacher would like to create separate Google Drive folders for each student in her class. Within each student's folder, there will be…
How to Schedule Form Availability and Limit Submissions in Google Forms
[2024-02-27 1:30 pm]When you create a Google Form , it is public by default meaning anyone who has the link to the form can submit a response. There forms…
When you create a Google Form , it is public by default meaning anyone who has the link to the form can submit a response. There forms…
How to Send Email Reminders for Google Forms Automatically
[2024-02-21 1:30 pm]You are using Google Forms to collect registrations for an upcoming event and would like to send email reminders to all the registered…
You are using Google Forms to collect registrations for an upcoming event and would like to send email reminders to all the registered…
How to Automatically Copy Google Forms Responses to any other Spreadsheet
[2024-02-19 1:30 pm]Google Forms is a perfect tool for collecting data, from event registrations to customer feedback. By default, your Google Form responses…
Google Forms is a perfect tool for collecting data, from event registrations to customer feedback. By default, your Google Form responses…
How to Verify API Keys for Gemini AI and OpenAI with Google Apps Script
[2024-02-15 1:30 pm]Are you developing Google Sheets functions or Google Workspace add-ons that tap into the power of Google Gemini AI or OpenAI? This…
Are you developing Google Sheets functions or Google Workspace add-ons that tap into the power of Google Gemini AI or OpenAI? This…
How to Send Confirmation Emails with Google Forms
[2024-02-01 1:30 pm]You have a Google Form and you would like to send an auto-confirmation emails to the person as soon as they submit the form. The…
You have a Google Form and you would like to send an auto-confirmation emails to the person as soon as they submit the form. The…
How to Find the Wi-Fi Password of your Current Network
[2024-02-01 1:30 pm]Imagine this scenario - your computer is connected to a Wi-Fi network but you do not remember the password that you previously used to…
Imagine this scenario - your computer is connected to a Wi-Fi network but you do not remember the password that you previously used to…
How to Automatically Rename Files in Google Drive with Apps Script and AI
[2024-01-28 1:30 pm]Do you have image files in your Google Drive with generic names like IMG_123456.jpg or Screenshot.png that offer no context about what…
Do you have image files in your Google Drive with generic names like IMG_123456.jpg or Screenshot.png that offer no context about what…
How to Send Google Forms Responses in an Email Message
[2024-01-13 1:30 pm]Google Forms are a perfect tool for creating online forms and surveys. The forms are responsive and mobile friendly, and they look…
Google Forms are a perfect tool for creating online forms and surveys. The forms are responsive and mobile friendly, and they look…
The Best Google Add-ons for Docs, Sheets, Slides and Google Forms
[2024-01-10 1:30 pm]The availability of third-party add-ons for Google Docs, Sheets and Google Slides have certainly made the Google productivity suite more…
The availability of third-party add-ons for Google Docs, Sheets and Google Slides have certainly made the Google productivity suite more…
PR Hacks for Media Coverage - How to Pitch Journalists and Influencers with Mail Merge
[2023-11-08 1:30 pm]John is a public relations professional and he is often required you to send press releases and event invites to journalists, bloggers and…
John is a public relations professional and he is often required you to send press releases and event invites to journalists, bloggers and…
Conditional Email Notifications with Google Forms - Route Responses to Different Email Addresses
[2023-11-03 1:30 pm]The Google Forms Email Notifications add-on lets you send Google Form responses in an email message as soon as a respondent submits the…
The Google Forms Email Notifications add-on lets you send Google Form responses in an email message as soon as a respondent submits the…
How to Save Password Protected PDF Attachments from Gmail to Google Drive
[2023-10-31 1:30 pm]Credit card companies and banks often send their financial statements in the form of password-protected PDF files. These PDF attachments may…
Credit card companies and banks often send their financial statements in the form of password-protected PDF files. These PDF attachments may…
How to Send Google Forms with Pre-filled Answers
[2023-10-31 1:30 pm]Prefilled Google Forms , where some of the fields in the form are pre-populated with answers you already have, make the process of filling…
Prefilled Google Forms , where some of the fields in the form are pre-populated with answers you already have, make the process of filling…
How to Send Base64 Images in Email with Google Apps Script
[2023-10-25 1:30 pm]Base64-encoded images can be embedded directly inside HTML emails without having to host the image on a remote server. This offers several…
Base64-encoded images can be embedded directly inside HTML emails without having to host the image on a remote server. This offers several…
Monitor Your Stock Portfolio with Google Sheets and Receive Daily Email Reports
[2023-10-24 1:30 pm]I have a Stock tracker spreadsheet built inside Google Sheets that keeps track of my fictional stock portfolio. The stock prices in the…
I have a Stock tracker spreadsheet built inside Google Sheets that keeps track of my fictional stock portfolio. The stock prices in the…
How to Embed Images from Google Form Responses in Documents
[2023-09-19 1:30 pm]The Document Studio add-on lets you create pixel-perfect documents from your data in Google Sheets and Google Forms. For instance, someone…
The Document Studio add-on lets you create pixel-perfect documents from your data in Google Sheets and Google Forms. For instance, someone…