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.
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:
Greek and Coptic Symbols
Use the search bar to search for a specific character.
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 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.
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.