How-To Geek: How to Use Interactive Dates in Google Docs. “If you want to include an interactive date in your document, Google Docs gives you simple ways to do it. Once you insert it, you can customize the format and use the date to schedule an event in Google Calendar.”
Google Workspace Updates: New intelligent suggestions for formulas and functions in Google Sheets. “Formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier. Simply begin inserting a formula in Sheets—suggestions will be automatically displayed and as you continue to type. You can view additional incremental suggestions in the drop-down menu.”
Digital Inspiration: Essential Date Functions for Google Sheets. “Master all the important date functions for Google Sheets with working formula examples. Whether you are looking to calculate the number of working days before the project is due or days until your upcoming birthday, this is the place to start.”
Search Engine Journal: How to Use Google Sheets for Web Scraping & Campaign Building. “According to Google’s support page, IMPORTXML ‘imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.’ Essentially, IMPORTXML is a function allows you to scrape structured data from webpages — no coding knowledge required. For example, it’s quick and easy to extract data such as page titles, descriptions, or links, but also more complex information.”
Digital Inspiration: Sort by Random – How to Randomize the Order of Rows in Google Sheets. “There are multiple ways to randomize the data rows in Google Sheet. You can either use the built-in SORT function of Google Sheets or create a menu-based function that lets you randomize data with a click.”
Digital Inspiration: How to Replace Accented Characters (diacritics) with English letters in Google Sheets. “The REMOVE_ACCENTED function for Google Sheets will replace all accented characters in the referenced cell, like the letters è, õ, ā, ĝ and so on with their normal Latin equivalents.”
My Master Designer: Using Google Sheets As Database With Python. “In this article, we’ll use Google Sheets as a database with the help of Python. Use SQL or NoSQL softwares when large databases and complex operations are required. A reminder before you start reading the article Google Sheets isn’t exactly database software, but it’s a simple spreadsheet program where you can store your data.”
Online Journalism Blog: What are regular expressions — and how to use them in Google Sheets to get data from text . “In an extract from a new chapter in the ebook Finding Stories in Spreadsheets, I explain what regular expressions are — and how they can be used to extract information from spreadsheets. The ebook version of this tutorial includes a dataset and exercise to employ these techniques.”
PopSugar: Celebrate Pride at Your 9 to 5 With This Google Sheets Hack That’ll Transform Any Spreadsheet. “Pride 2021 is here, and it’s a time to celebrate both on and offline! While parades and parties are a huge part of the month to celebrate and uplift the LGBTQ+ community, sometimes our computers call and we must answer. Luckily, Google Sheets is just as ready to partake in Pride festivities as we are, and the newest hack we learned just made sitting at our desks much more enjoyable.”
Digital Inspiration: Find Google Sheets Linked to your Google Forms. “When a user submits your Google Form, the response can be either saved in the Google Form itself or it can be written as a new row in a Google Spreadsheet. Multiple Google Forms can be associated with a single spreadsheet and their responses will be stored in separate sheets of the same spreadsheet. If you have multiple Google Forms in your Drive that are writing response data to the same Google Sheet, you can use Google Scripts to determine the name of the spreadsheet and the sheet where that form is storing their responses.”
Digital Inspiration: How to Perform IP Address Lookup with Google Sheets. “IP2Location is another good alternative that retrieves more detailed geolocation information for any IP address. The IP location lookup service can retrieve the client’s country, city name, region, the ISP name and more. If you have a bulk list of IP addresses, you can use Google Sheets to estimate the corresponding geographic details for each of the addresses in few easy steps.”
The Next Web: Holy sheet: How to pull contact details from a website using only Google Sheets. “Are you in a job where you regularly need to collect contact information from companies? And do you find it an annoying and unnecessarily time-consuming task to sort through ever-changing web designs, to find that one button or bit of information you’re actually looking for? Don’t look any further… help is on the way!” Brilliant use of IMPORTXML / XPath.
Dev: How to Use Google Sheets as a Database (Responsibly). “While database technology and other tools have come a long way, it’s still tough to beat the humble spreadsheet’s versatility and intuitiveness. While using them for sensitive, critical applications like storing COVID-19 patient data is ill-advised, the fact that everyone knows how to use a spreadsheet means they’re great for smaller cross-functional projects where a non-developer might need to examine or edit data. In this guide, I’ll show you how to use Google Sheets as a database, complete with an API interface accessible over HTTP.”
