Author: admin

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…

Canva is everyone’s favorite tool for creating social media graphics, YouTube video thumbnails, Instagram stories, logos, and even regular presentations. The app is jam-packed with beautiful, ready-to-use templates that make it easy for even non-designers to create unique and impressive designs. Google Slides Template Gallery Google Slides is probably the most popular app for creating presentations but its built-in template library is limited and haven’t seen any update in a long time. Cavan Presentation Templates Compare the Slides library to Canva and you’ll find thousands of presentation templates that will fit the needs of any project, be it in education,…

Yesterday marked Friendship Day, and to celebrate, I sent a personalized image to each of my friends via WhatsApp. The images were created in bulk, but each graphic had the person’s name, making the greetings unique and heartfelt. To achieve this, I did employ some automation. First, I gathered the names of my friends in a Google Sheet. Then, I designed a graphic template in Canva and imported the design in Google Slides. The template had a placeholder – {{Friend’s Name}} – that would be replaced with actual values from the Google Sheet. The Source Template Here’s the source data…

You are organizing an online event – maybe a meeting on Zoom or a training session hosted on Google Meet – and you would like the attendees to add the event to their own calendars. Once added to their calendar, the event will act as an automatic reminder and attendees will get a notification when the conference is about to start. There are two way to go about this: You can create a new meeting in your online calendar (Google, Outlook or any other calendar) and add the individual attendees as guests so the event automatically gets added to their…

Google Apps Script has received a significant upgrade ever since it was first released to the public more than a decade ago. Apps Script now uses the V8 JavaScript Engine – it is the same runtime that is used inside the Google Chrome browser and the popular Node.js environment. This essentially means: Developers can write code using modern JavaScript syntax like Arrow Functions, Classes, Array Destructuring, Template Literals and more. The V8 Engine is fast, powerful and continuously improving, It will likely improve the performance and memory utilization of your Google Scripts. Developers can use new JavaScript ES6 features like…

Are you planning to explore some of the most beautiful Indian destinations in the new year? Uncover the finest places to visit in India in 2025 and find inspiration for your next remarkable vacation. From the pristine beaches of Goa to the majestic forts of Rajasthan, the serene hill stations of Kerala, and the breathtaking cold desert of Ladakh, India boasts a plethora of captivating destinations that provide a variety of experiences for every traveler as part of India tour packages. Here are 15 perfect places in India to visit in 2025 for an unforgettable experience. Rajasthan Rajasthan, often known…