Set up automated email notifications based on Google Sheets data. Super simple apps script to start this. Learn how to automate this for users very easily with a custom menu and programmable Triggers.
A brief description of types of automation. I go way more in depth in “Master Spreadsheet Automation” on Udemy and “Spreadsheet Automation 101” on Better Sheets- Built-in Formulas that seem like automation IF()- Custom Functions in Apps Script- Time Driven Triggers- Event Driven Triggers
How to imbue your sheets with a little bit of magic to delight your customers without learning Apps Script. Using the IF/ISBLANK formula combination.
A video I did summarizing the 3 things you can do to help people who share your sheet, not do it, or at least get some value from it.More info on the course: sellingspreadsheets.com→ Get OnlySheets
Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.→ Get Spintax
Updated the Spintax tool to allow you to generate Spintax. Instead of having to come up with it all yourself, you can let AI generate the Spintax for you. Create variations on headlines, or phrases, or emails.
Learn how to add random movie quotes and famous quotes to a Google Sheet. We'll use RapidAPI to get the code and just have a little bit of editing to the code to be able to use it in Google Sheets.
Curated sites, articles, and more web resources super easily into a Google Sheet. Create a bookmarklet automatically with this apps script tool.
Built a Domain Availability Checker in Google Sheets. You can build your own with the code provided. Use RapidAPI and Domainr.com to get an APIEKY for your own free checker.Learn how to integrate sheets with a TLD Availability API.
Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself. Check out Josh's Tweet about the sheet.and check out his Podia. The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.
Create nice colorful sheets (contrasting colors) that look and feel like an extension of your site. Add some padding around text. Decrease text and make your sheets awesome.
Get the freebie here at @abloommedia on TikTok or on Abloommedia.comSorry no sheet available even for members. Get the AI code in the video mentioned: Upgrade AI to GPT 4
Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.