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
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.
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.
Learn how to generate software license keys and verify them using a Crypto API. The keys can be activated offline and do not require a database.
Learn how to create a simple payment page and accept payments on your website using Zoho Payments. Customers can pay you with UPI, and Credit Cards.
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 extract email addresses and names from email messages in your Gmail account and import the email directory into Google Contacts or Outlook address book
Password protect PDF documents generated from Google Sheets. Add unique passwords to each PDF file and save them securely to Google Drive or send as email attachments.
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 JavaScript to detect the country and location of your website visitors from their IP address and serve different payment options or offer purchasing power parity.
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.
Build your own BMI calculator app with Google Forms. The BMI report is generated in Google Sheets and the user receives an email with the BMI score.
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.
Learn how to verify API keys for Google Gemini AI and OpenAI using Google Apps Script.
Quickly rename files in Google Drive with Apps Script and Google Gemini AI. The script will automatically rename the files with a descriptive name based on the image content.
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.
