How to Import Data from One Google Sheet to Another - Learn with Practical Examples
Learn how to import data from one Google Sheet to another using the IMPORTRANGE and QUERY functions. You can filter data or only import specific rows that meet certain criteria.
How to Create Print-Ready Brochures and Flyers in Multiple Languages
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!
How to Automatically Cleanup Revisions in Cloud Run Functions & Firebase
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.
How to Replace Bixby with Google Gemini AI in Samsung Phones
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.
Chat faster with AI Chatbots from Chrome's Address Bar
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.
How to Work with Document Tabs in Google Apps Script
Your documents in Google Docs can now be organized into tabs and sub-tabs. While the multi-tab feature will make navigation easier, it also impacts how you work with documents in Google Apps Script.
Create a Keyboard Shortcut for Apple Intelligence Writing Tools on Mac
The writing tools in Apple Intelligence let you rewrite emails and other text in a more professional or friendly tone. And you can quickly launch the writing tools with a keyboard shortcut on your Mac.
How to Export WooCommerce Customers to Google Sheets
Export your WooCommerce customers email, name and address to Google Sheets with Apps Script. The script copies data from the WooCommerce customers table to sheets.
How to Convert Google Slides to PNG Images with Google Script
Learn how to convert Google Slides into high-resolution PNG images using Google Apps Script. Choose between the Google Slides API and the Google Drive API based on your requirements.
How to Determine if your Mobile Phone will work in Another Country
Your mobile phone may not work in another country if the frequency bands supported by your phone don't match the frequency bands used by carriers in that country.
Send Personalized Emails with SMTP and Mail Merge in Google Sheets
How to send personalized emails using Mail Merge in Google Sheets with SMTP. You can send emails via SendGrid, Postmark, AWS SES, Zoho Mail, or any other SMTP server
An Improved SUBSTITUTE Function for Replacing Multiple Values in Google Sheets
The SUBSTITUTE function in Google Sheets lets you find and replace a specific text value in a cell with another value. If you need to replace multiple values in a string with different values, you'll need to nest multiple SUBSTITUTE functions which can be cumbersome.