GWAOw! 3 – Crop Sheet by Eric Koleda

In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at Crop Sheet by Eric Koleda.

Crop Sheet allows you to quickly crop a Google Sheet tab by your own selection or by the data in your sheet tab.

With over 1,000,000 installs this is a simple Google Workspace Add On that completes a specific job well.

What’s the alternative? A somewhat slower process of removing outer columns and rows by a whole lot of clicking, shortcut commands and time wasted.

Eric was a Developer Relations Infrastructure Manager at Google before moving to Coda.io (An all-in-one document tool for collaboration) as their Developer Advocate. I’d be pretty confident in this add on. 😉

You can also find the code for Crop Sheet on GitHub.

Check it out on the Google Workspace Marketplace: Crop Sheet

Check out more Episodes of GWAOw! here!

GWAOw! 2 – ImportFromWeb by NoDataNoBusiness

In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at ImportFromWeb by NoDataNoBusiness.

ImportFromWeb is a powerful web scraping tool for Google Sheets that allows you to grab data from any website. The creators call it IMPORTXML on steroids.

You can use ImportFromWeb as a Google Sheets function or use one of their incredible templates.

This tool is ideal for Google Workspace businesses that need to find and store live data from websites. Whether you are scouring the web for new client prospects or keeping an eye on your competition, this might be the tool for you.

In this walkthrough, we really just scratched the surface on ImportFromWeb’s capabilities. We walk through three practical examples covering retrieving a list of books from a web store, listing the first page of Google Workspace jobs on Indeed.com and then getting the latest Tweets for Google Workspace on Twitter. I’ve added the formulas below from the video for you to try out once you installed the add on.

I also managed to score us a 40% discount when you purchase ImportFromWeb after your trial, use the code YAGISANATODE40 at check out to get the discount or use this link:

ImportFromWeb

Check it out on the Google Workspace Marketplace: ImportFromWeb

Example 1 – Book List (xpath)

URL: https://www.booktopia.com.au/search.ep?keywords=Terry+Pratchett&productType=917504

Selector: //*[@id="product-results-p1"]/li

Example 2 – Job List (css selectors)

URL: https://www.indeed.com/jobs?q=%22Apps%20Script%22&vjk=4b000129055a847f

CSS Selector: .jobTitle

CSS Selector URL: .jcs-JobTitle/href

Example 3 – Twitter (jsRendering) – Playground

URL: https://twitter.com/search?q=%23GoogleWorkspace&src=typed_query&f=top

Selector: article

Check out more Episodes of GWAOw! here!

GWAOw! 1 – Workbook Statistics by Sourabh Choraria

In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at Workbook Statistics by Sourabh Choraria.

Workbook Statistics is a FREE add-on that allows you to get intimate with all of your Google Sheets stats from your menu bar. You can grab stats on the number of rows, sheet names, pivot tables and much more from an individual Google Sheet to the entire workbook.

Check it out on the Google Workspace Marketplace: Workbooks Statistics

Sourabh, being the all-around awesome person that he is has also open-sourced the code for this Add-on. You can find it on his GitHub page.

Check out more Episodes of GWAOw! here!

%d bloggers like this: