Google Workspace Updates: New intelligent suggestions for formulas and functions in Google Sheets

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.”

Search Engine Journal: How to Use Google Sheets for Web Scraping & Campaign Building

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.”

My Master Designer: Using Google Sheets As Database With Python

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

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

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: How to Use Notion with Gmail and Google Sheets using Apps Script

Digital Inspiration: How to Use Notion with Gmail and Google Sheets using Apps Script. I hear from friends that they’re using Notion but I haven’t tried it yet. You? “Notion, my absolute favorite tool for storing all sorts of things from web pages to code snippets to recipes, just got better. They’ve released a public API and thus it will be a lot easier for developers to read and write to their Notion workspace from external apps.”

Digital Inspiration: Find Google Sheets Linked to your Google Forms

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

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.”

Holy sheet: How to pull contact details from a website using only Google Sheets (The Next Web)

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.

Gizmodo: 21 Tips To Make Google Docs, Sheets And Slides Work For You

Gizmodo AU: 21 Tips To Make Google Docs, Sheets And Slides Work For You. “Google Docs, Sheets, and Slides have evolved to become very component online productivity tools, enabling you to churn out documents, spreadsheets and presentations from any computer (with other collaborators, if necessary). But are you taking full advantage of everything these web apps have to offer? These 21 tips will save you time, improve your work, and help you do more with these apps.”

Dev: How to Use Google Sheets as a Database (Responsibly)

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.”