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.
- Category: Google Apps Script
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.
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.
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.
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.
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!