Author: admin

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…

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…