Author: admin

Google Secret Manager is a cloud service where you can store sensitive data such as passwords, database credentials, encryption keys or any other confidential information that you don’t want to hardcode in your application’s source code. You can also set up an expiration time for the secret and the Google Secret Manager will automatically delete the secret after the specified time. The following guide explains how you can use Google Apps Script to access secrets stored in the Google Secret Manager. But before we proceed, let’s first create a secret in the Google Secret Manager. Enable Google Secret Manager 1.…

Cake Studio is a local bakery that accepts orders through Google Forms. When a customer places an order, the customer automatically receives a UPI QR Code to make the payment. This QR Code is generated dynamically based on the order amount and the customer can pay the bill using any UPI app. In the above screenshot, the customer ordered a Butterscotch Cake through Google Form and they received a customized UPI QR Code that includes the exact bill amount. The amount is calculated automatically based on the selected items in the Google Form. Google Forms and UPI Payments This tutorial…

The Document Studio add-on helps you create personalized PDF documents from Google Sheets. You can generate invoices, certificates, agreements, offer letters, student ID cards and other documents in bulk and save them to Google Drive. Additionally, Document Studio now offers the option to protect the generated PDF documents with a password. This functionality is particularly valuable in scenarios where the generated documents contain sensitive information that require extra protection to stop unauthorized access. For instance, you may generate invoices, or financial reports and protect them with a password before sharing them with clients or employees. Add Passwords to PDF Documents…

The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File Upload question in your Google Form to receive PDF assignments from students, job applications, portfolio images from contestants, and more. Play ; While the file upload feature in Google Forms is handy, it does have one big limitation. For instance, when a respondent uploads a file through Google Forms, the file is stored in a fixed folder within the form owner’s Google Drive. All uploaded files are are saved to the same folder, making it difficult…

Google Sheets offers a built-in SUBSTITUTE function that can can find and replace a specific text in a cell with another value. For instance, you can use =SUBSTITUTE(“My favorite color is red”, “red”, “blue”) to replace the text red in the string with blue. The SUBSTITUTE function is case-sensitive and will replace all occurrences of the search text. Replace Multiple Values with SUBSTITUTE Now consider a scenario where you have to replace multiple values in a string with different values. For instance, if you have a template string like My name is const searchValue = opts[i]; const replaceValue = opts[i…

The Mail merge add-on lets you send personalized emails to multiple recipients in one go. The emails are always sent via your Gmail account or your Google Workspace email address. Google also imposes a limit on the number of emails you can send per day. Mail Merge with SMTP Mail merge is convenient because you can put your contacts in a Google Sheet and the add-on will individually send the emails for you. However, if you aren’t using Gmail or have a large mailing list, an SMTP service like SendGrid or AWS may be more a suitable option for sending…

Adding a custom menu in Google Sheets, Docs, Slides, and Forms using Google Apps Script is straightforward. As an illustration, the following code snippet adds a custom menu to the parent Google Sheet that reveals the spreadsheet name upon clicking. function onOpen() { const ui = SpreadsheetApp.getUi(); const menu = ui.createMenu(‘➯ Custom menu’); menu.addItem(‘Show spreadsheet name’, ‘showName’); menu.addToUi(); } function showName() { const fileName = SpreadsheetApp.getActiveSpreadsheet().getName(); SpreadsheetApp.getUi().alert(fileName); } The above code defines two functions: onOpen which executes when the app opens, and showName which is triggered when the menu item is clicked. This approach can be applied to create custom…

Let’s say you have a Github repository where you push all your code changes. Each commit has a unique commit hash, and you can use this hash to restore the code to a specific commit or a particular time. It is advisable that you take a backup of your current code before proceeding. Find the Commit Hash To get started, open your repository on Github and find the commit you want to restore. You can do this by clicking on the “Commits” tab and finding the commit in the list. If you want to restore to a particular date, you…

If you are running an online store running on WordPress, chances are you are using WooCommerce to manage your customers and orders. The holiday season in near and you may want to send your existing customers a special discount code for their next purchase. Or you may want to analyze your store’s data to see how your business is performing in various regions. You can the built-in export feature of WooCommerce to export your customers data to a CSV file and then import the CSV file into Google Sheets. Go to your WooCommerce dashboard, navigate to the Customers section, and…

Zoho Payments is a new payment gateway that lets you accept payments on your website. You can visit this sample store to see the Zoho Payments widget in action. Unlike Stripe or RazorPay which are more mature payment gateways, Zoho Payments only supports domestic payments in INR (₹). In the initial release, merchants can only accept one-time payments and customers can pay you with UPI, Net Banking, and Credit Cards. The onboarding process is simple and, once you have uploaded your KYC documents, your account is approved within few business days. There’s no transaction fee for UPI payments while credit…

You are running a small software business that sells digital downloads – apps, plugins, or even templates. When the buyer completes the purchase, you need to provide them with a license key that they can use to activate and validate the software. Here’s how you can implement such a licensing system in your software: Generate a public and private key pair using the RSA algorithm. Sign a message with the private key. The message contains the buyer’s email address and the software SKU. The signed message is the license key that is sent back to the buyer’s email address. When…

Google Docs now lets you organize your documents into tabs and sub-tabs. This change is particularly useful for managing long documents like employee handbooks and training manuals. Because the document is now divided into multiple sections, the navigation through the document is more intuitive and easier. However, this structural change significantly impacts how we work with documents through the DocumentApp service of Google Apps Script. Previously, Google Docs treated the entire document as a single entity. With the new tabbed structure, each tab is now a document itself with its own body, header, footer, and footnotes. Your Google Apps Script…