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 […]
VentureBeat: Google’s Area 120 launches Tables, a rules-based automation platform for documents. “Google’s Area 120 incubator today launched Tables, a work-tracking tool with IFTTT-like automation features and support for Google products, including Google Groups, Google Sheets, and more. Currently in beta in the U.S., Tables automates actions like collating data, checking multiple sources of data, […]
Digital Inspiration: How to Highlight Duplicates in Google Sheets and Remove. “The Email Extractor app pulls emails addresses of your contacts from Gmail into a Google Sheet. You can then use Mail Merge or Document Studio to send personalized emails to your contacts from within the sheet itself. That said, the imported mailing list may […]
More Digital Inspiration, because it’s too Amit to quit: Measure Core Web Vitals of your Websites with Google Sheets. “If you are looking to automatically measure core web vitals for multiple websites, maybe that of your competitor’s websites as well, here’s a Google Sheet that can help. The spreadsheet will not only help you measure […]
Digital Inspiration: Google Maps Formulas for Google Sheets. “You can bring the power of Google Maps to your Google Sheets using simple formulas with no coding. You don’t need to sign-up for the Google Maps API and all results from Google Maps are cached in the sheet so you are unlikely to hit any quota […]
TechCrunch: Google Sheets will soon be able to autocomplete data for you. “Google today announced a couple of updates to Google Sheets that will make building spreadsheets and analyzing data in them a little bit easier. The most interesting feature here, surely, is the upcoming launch of Smart Fill. You can think of it as […]
Digital Inspiration: How to Add Options in Google Forms Questions from Google Sheets. “As with everything else in the world of Google Forms and Google Sheets, we can easily automate the process of adding question choices in Google Forms in bulk with the help of, you guessed it right, Google Apps Script.”
Alphr: Understanding If /Then Statements In Google Sheets. “If/Then statements are often considered complex. But in reality, they’re not at all difficult to pull off. Plus, they can be more useful than you realize when working with specific data sets or expressions in a spreadsheet.”
Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script. “You can hide entire rows in Google Sheets manually or use filters to hide any rows that matches the specified criteria. For instance, if you have a sheet containing orders from different countries, you can set up a country filter […]
Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File. “In the past two tutorials on Google Drive API with Python, we have covered how to obtain credentials here and search for a specific file in Google Drive by its name here. In this tutorial, we […]
Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets. “When people submit your Google Form, a new row is inserted in the Google Sheet that is storing the form responses. This spreadsheet row contains a Timestamp column, the actual date when the form was submitted, and the other columns in the sheet […]
The Next Web: Holy sheet: Even YOU can budget… with Google Sheets. “There are lots of budgeting spreadsheet templates available on the web. Many of them require quite a bit of work, like filling in all of the specific transactions you conduct. However, that isn’t really necessary for a consistent, personal budget, especially if you […]
The Next Web: Holy sheet: How to track your stock portfolio with Google Sheets. “Recently, millennials have been bombarded with a slew of new personal finance apps. It seems as if budgeting, saving, and investing is all the rage nowadays, and that everyone’s aiming for FIRE (Financial Independence Retire Early). But again, you don’t really […]
Digital Inspiration: How to Send SMS Messages with Google Sheets and your Android Phone. “There are services, Twilio and Vonage for example, that let you send text messages programmatically to any phone number in the world. You can either build an SMS solution on top of these messaging APIs or you can take a simpler […]