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.
Features
The Insert Special Character Google Workspace Add-on comes with some handy features. You can:
Modify the colour and size of the characters before installing them.
Insert Multiple characters into one cell.
Filter the character list by:
Arrows
Geometric Shapes
Currencies
Maths Symbols
Dingbats
Greek and Coptic Symbols
Use the search bar to search for a specific character.
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.
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:
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.
