Tag: GWAOw

GWAOw! 5 – Insert Special Characters by Sheets Help

In this episode of GWAOw!!! we look at Insert Special Characters by Sheets Help.

About Insert Special Characters for Google Sheets.

As the name suggests, the Insert Special Character Add-on allows you to access the complete list of special characters like maths symbols, shapes and arrows, currency symbols, dingbat and Greek and Coptic symbols from the sidebar of your Google sheets.

This is all accessible from the convenience of the sidebar within your selected Google Sheet.

https://youtu.be/1msdhSy1woQ

Features

The Insert Special Character Google Workspace Add-on comes with some handy features. You can:

  1. Modify the colour and size of the characters before installing them.
    Modify colour and size before inserting special character into Google Sheet
  2. Insert Multiple characters into one cell.
    Insert multiple special characters into a single cell in Google Sheet
  3. Filter the character list by:
    1. Arrows
    2. Geometric Shapes
    3. Currencies
    4. Maths Symbols
    5. Dingbats
    6. Greek and Coptic Symbols
      Filter special characters lists in Google Sheets
  4. Use the search bar to search for a specific character.

Search for a special character in Google Sheets

Pricing

The add-on comes with a 7-day free trial followed by a very reasonable one-time $7 purchase, but…I spoke to Adam from Sheets Help and managed to get you 20% off.

I don’t know how long the offer will last so I recommend that if you find this Add-on useful, take advantage of the discount while it is still available.

Use the code SPECIAL20 at checkout to get the discount. You can find the code in the description below this video.

About Sheets Help

Along with their recent publication of the Google Workspace Add-on Insert Special Characters for Google Sheets, Sheets Help provides a wide variety of tutorials, tips and tools to help you with your next project.

 

Get the Add-on

Check it out on the Google Workspace Marketplace: Insert Special Characters

Or learn more from the add-on’s homepage.

 

GWAOw! 4 – Forms History by Martin Hawksey

In this episode of GWAOw!!! we look at the Google Workspace add-on, Forms History by Martin Hawksey.

About Forms History for Google Forms

Unlike Google Docs and Google Sheets, there is no version history in Google Forms. Forms History is Martin’s solution to this problem. This free add-on allows you to review the version history of your form and make saves at critical points in your form build process.

This is a must-have tool for teams collaborating on a Google Form.

You don’t need to install Forms History for all users who are collaborating on your form for it to run. The add-on will keep track of your edits and provide opportunities for you to make saved versions of your form along the way.

After installation, simply click the add-on puzzle piece in the top menu of your Google Forms project and then select Forms History > Open. A sidebar will appear indicating daily versions. You can then expand these sections to see breakdowns of activity over the day.

From the sidebar, you can also save a current version or navigate to a version that has been saved previously. Intuitive icons make this process very easy.

Some Unavoidable Limitations

There are some limitations to how Google Forms stores updated data for Google Forms and you might find that small edits within around 20 minutes might be consolidated into one version. To be clear this is not a fault of Martin’s add-on it is just how Google Forms handles how it keeps track of different versions.

About Martin Hawksey the developer

Martin is one of the biggest names in the Google Workspace Google Apps Script community and is the mastermind behind the Apps Script aggregate site Apps Script Pulse and host of the long-standing apps script Google workplace YouTube series Totally Unscripted, as well as being a Google recognised Developer Expert and Google Cloud Innovator Champion. This is a fella you can trust which gives me great peace of mind when installing this app.

Get the Add-on

Check it out on the Google Workspace Marketplace: Forms History

Or learn more from the add-on’s homepage.

You can also see a great interview with Martin on Forms History hosted by Alice Keeler.

The Video

https://youtu.be/3i2j8CNbfhg

Check out more Episodes of GWAOw! here!

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

https://youtu.be/Gja5QseHbPM

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

https://www.youtube.com/watch?v=9Nv7bjeUwvY

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

https://www.youtube.com/watch?v=kIndBDeOspY

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!