TechReport

Learn how to automatically generate brochures, PDF flyers or reports in multiple languages. It uses Google Translate for translation and is perfect for reaching an international audience! source https://www.labnol.org/create-multilingual-documents-250618

Whether you are running a serverless function on Google Cloud Run or Firebase, you can automatically remove inactive revisions and reduce clutter in your Google Cloud project. source https://www.labnol.org/remove-inactive-cloud-run-revisions-250520

Bixby is the default voice assistant in Samsung Galaxy phones. You can easily replace it with Google Gemini and use the same power button to launch the Google voice assistant. source https://www.labnol.org/gemini-replace-samsung-bixby-250401

Instantly query any AI chatbot directly from Chrome's address bar and save precious time. Type @plex to chat with Perplexity AI or @claude to talk to Claude AI. source https://www.labnol.org/ai-chatbots-chrome-250130

Learn how to automatically maintain consistent formatting, styles, and date formats when new Google Form responses are added to your Google Sheets. source https://www.labnol.org/auto-format-google-form-responses-220601

The best Mac apps to boost productivity and get things done faster on your  Mac OS. source https://www.labnol.org/software/essential-mac-utilities/9479/

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. source https://www.labnol.org/extract-images-google-docs-slides-230913/

The recent release of Apple Intelligence has added a new set of helpful AI writing tools to your Mac. You can proofread emails, summarize documents and, the most useful of all, rewrite emails in professional or casual tone. You can access the writing tools wherever you type text on your Mac - in the Mail app, Gmail, Safari browser, and any other text editor. Apple Intelligence is available on Macs running macOS Sequoia 15.1 and the device language is set to US English. The built-in AI integration means you can enhance your writing directly in your current app, without jumping back and forth between ChatGPT or Copilot in a separate window. To access the AI writing tools inside your current app, you can select the text you want to edit, right-click and select Writing Tools > Show Writing Tools from the context menu. Launch AI Writing Tools with a Keyboard Shortcut If you prefer to use a keyboard shortcut to launch the writing tools on your Mac, here’s how you can do it. L...

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 the buyer activates the software, the license key is verified using the public key. The Advantages The advantage here is that the public key can be included in the software’s source code, there’s no need to use a database, and the buyer can verify the license key offline without the need to connect to your server. Let’s now go through the implementation steps in detail. 1. Generate Public and Private K...

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 card transactions are subject to a 2% fee (excluding GST) How to Accept Payments with Zoho Payments In this tutorial, we’ll create a simple payment page in Google Apps Script and accept payments on our website using Zoho Payments. Assuming that you have signed up for Zoho Payments, you can visit the dashboard to find your “Account ID”. Next, go to Settings > Developer ...

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 you’ll find an option to download the customers list as a CSV file. If you are however looking for a more efficient way to export your WooCommerce customers to Google Sheets, you can use Google Apps Script to create a custom script that will export the customers to a Google Sheet. Step 1: Create an API Key in WooCommerce To get started, you’ll create an API key in WooCommerce. Go to your WooCommerce dashboard, na...

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 can use the calendar dropdown to see all the commits for that day and find the one you want. You may also use the command line to find the commit hash. git log --oneline Once you have found the commit you want to restore, you can create a new branch at that commit. Let’s call this branch working-branch . git checkout -b working-branch < commit-hash > This git command will create a new branch named working-branch pointing to the specified commi...

Document Studio can convert Google Slides into high-resolution PNG images. This can be useful if you want to create multiple variations of the same slide in bulk - create a single template in Google Slides and then use Document Studio to generate PNG images with different text or images, pulled from a Google Sheet or Google Forms. Internally, the app uses the Google APIs to generate high-resolution thumbnail images of the slides and uploads the individual slides to the Google Drive of the current user. In this tutorial, we’ll explore two methods to achieve the slide-to-png conversion using Google Apps Script. Approach #1 - Use the Google Slides API You can use the Google Slides API to get the thumbnail images of the slides, fetch the blob of the image, and then upload the image to Google Drive. const generateSlideScreenshot = ( ) => { const presentation = SlidesApp . getActivePresentation ( ) ; const presentationId = presentation . getId ( ) ; // Get the o...