April 7, 2021

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.

Useful Stuff 0
March 9, 2021

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

Useful Stuff 0
October 7, 2020

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

Useful Stuff 0
September 23, 2020

VentureBeat: Google’s Area 120 launches Tables, a rules-based automation platform for documents

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, and pasting data into other docs for handoff.”

New Resources 0
September 5, 2020

Digital Inspiration: How to Highlight Duplicates in Google Sheets and Remove

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 sometimes have duplicate email addresses and it is thus be a good idea to clean up the data in your Google Sheet by removing duplicates before sending out the emails.”

Useful Stuff 0
August 25, 2020

More Digital Inspiration: Measure Core Web Vitals of your Websites with Google Sheets

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 vitals for multiple URLs but you can also visualize the change in various metrics over time with the help of sparklines.”

Useful Stuff 0
July 1, 2020

TechCrunch: Google Sheets will soon be able to autocomplete data for you

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 Smart Compose, the feature that automatically tries to finish your sentences in Gmail, but for spreadsheets. The idea here is that Smart Fill, which will launch later this year, can autocomplete your data for you.”

Tweaks & Updates 0
June 11, 2020

Digital Inspiration: How to Get Hidden and Filtered Rows in Google Sheets with Google Script

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 to hide all rows where the country is not the United States. If you have a Google Script that iterates through each row in the Google Sheet for performing actions on the row, like sending emails or merging documents, you can check for the hidden and filtered rows and easily skip them from the workflow.”

Useful Stuff 0
June 6, 2020

Towards Data Science: How to Download a Specific Sheet by Name from a Google Spreadsheet as a CSV File

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 are going to learn how to download a specific Sheet by name from a Google Spreadsheet into a csv file. A use case for this: you need to generate a report, which data are stored in a Google Spreadsheet that has many Sheets, but you only need one or two of them. So, instead of downloading the whole Google Spreadsheet, you can handpick the Sheets that you need.”

Useful Stuff 0
May 30, 2020

Digital Inspiration: How to Use Formulas with Google Form Responses in Sheets

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 contain all the user’s answers, one per column. You can extend the Google Forms sheet to also include formula fields and the cell values are automatically calculated whenever a new row is added to the sheet by the Google Form.”

Useful Stuff 0
April 21, 2020

Holy sheet: Even YOU can budget… with Google Sheets (The Next Web)

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 have a fairly consistent stream of income and expenses. So we’re here to provide you with an accessible way to budget — a very simple though effective (if you stick to it, of course) template; one that doesn’t require much maintenance, and still gives you a concise glance at what comes in, what goes out, and how much you’re saving per month.”

Useful Stuff 0

The ResearchBuzz Firehose is regular RB content presented as individual posts.
For digest-type posts a couple of times a day, please visit ResearchBuzz.

Want to know how to best use the Firehose for content discovery?
Check out this handy article.

Search by Category

Get RB Firehose Via EMail

Enter your email address to subscribe to ResearchBuzz Firehose and get a firehose of new posts straight to your email.

Join 1,993 other subscribers

Categories

Top Posts & Pages

Creative Commons License