Translate an IP to a physical location using this IP geolocation function directly from your Google Sheets. A free external API is used for fetching the necessary data.

​Read Article

Get the latest COVID-19 data by country into your Google Sheets with the click of a button. Learn how to fetch data from external APIs using Google Apps Script.

​Read Article

Do you want to search your emails and write the data directly into Google Sheets? If yes, then check how to incorporate some GAS functions that will allow you to search your mailbox using patterns.

​Read Article

Learn how to use Google Sheets to send multiple emails to different recipients. No need for an external application anymore. Just implement this custom GAS code and start sending emails like a pro!

​Read Article

Transform your typical, boring column charts into good-looking charts that will enhance the presentation of your data. Adjust this custom GAS function and create a beautiful column chart in a few seconds.

​Read Article

Learn how triggers and events work in Google Sheets. Create a simple logger and see how you can make Google Apps Script run any function automatically if a certain event occurs.

​Read Article

Get the latitude and the longitude of a given address (geocoding) in Google Sheets, or do the exact opposite (reverse geocoding). These GAS functions are ready to be used, without the need for an API key. Online examples are also included.

​Read Article

Learn how to create your first custom GAS function in Google Sheets. This step-by-step guide will teach you everything you need to get started with Google Apps Script. No prior experience is required!

​Read Article