Tag: GWAOw Sheets

GWAOw! 6 – Sign PDF with Jotform Sign

In this episode of GWAOw!!! we look at Sign PDF with Jotform Sign.

About Sign PDF with Jotform Sign

Sign PDF with Jotform Sign is a Google Workspace Add On (GWAO) that allows you to collect e-signatures for any PDFs stored in your Google Drive.

This is such a useful tool that I have moved to Sign PDF with Jotform Sign for e-signatures of my client service agreements.

The add-on has some great tools that allow you to create and edit the input fields for your document before sending it to signatories.

Continue reading “GWAOw! 6 – Sign PDF with Jotform Sign”

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! 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!