Tech à la carte
Writing on tech, building software tools, since 2004.
“We strive to be independent and unbiased. We do not accept anything of value from brands or from their public relations agencies. We do not make paid endorsements of any kind nor do we produce paid content, ever.”
Digital Inspiration is a tech how-to website written by Google Developer Expert Amit Agarwal. Since its launch in 2004, this site has become a go-to resource for everything related to Google apps. We publish how-to guides and tutorials that make complex technology easy to understand for everyone.
Whether you're automating tasks in Google Sheets, creating custom Gmail routine, crafting no-code workflows or exploring the latest tech trends, our unique Google Apps Script solutions help you work faster and smarter.
Google Developer Expert
Google awarded us the Developer Expert title recogizing our work in Workspace
ProductHunt Golden Kitty
Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards
Microsoft MVP Alumni
Microsoft awarded us the Most Valuable Professional title for 5 years in a row
Google Cloud Champion
Google awarded us the Champion Innovator award for technical expertise
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.
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!
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.
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.
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.
Learn how to automatically maintain consistent formatting, styles, and date formats when new Google Form responses are added to your 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 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
Learn how to make postal addresses clickable in Google Sheets with a formula. Create hyperlinks that directly link an addres to Google Maps places.
Use Google Maps formulas inside Google Sheets to calculate distances, travel time, get driving directions, look up postal codes with reverse geocoding and more!
How to embed Google Maps to your website in a responsive manner with lazy loading. The maps will resize based on the device screen and load only when the user scrolls to the map thus making the page load faster.
Use Google Maps to find public toilets near your current location. All you need to do is type a search query in the search box.
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.
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.
How to pre-fill answers in Google Forms using data from a Google Sheet and send the pre-populated Google Forms as personalized emails.
How to use Document Studio to embed uploaded images in generated documents from Google Forms responses.
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.
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.
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.
Use AI to improve spam detection in Gmail and find legitimate emails that were mistakenly marked as spam by Google algorithms.
Amit Agarwal is a web geek, solo entrepreneur and loves making things on the Internet. Google recently awarded him the Google Developer Expert and Google Cloud Champion title for his work on Google Workspace and Google Apps Script.
