Better Sheets - 100 Testimonials
Hi,
I just made a new page on my site, and the backend is a Google Sheet.
I've create a testimonials page. That can be added to by you.
π Bettersheets.co/testimonialsβ
You can read the 100+ reviews from AppSumo customers there, already. And submit your own if you're a Better Sheets user. I know you might not be.
Let me tell you about this page and the sheet.
Basically I got a regular sheet, with a form attached. But instead of just leaving it as a sheet, I wrote 3 lines of Apps Script that allows me to deploy a web app on Google's Servers that the site reads and gets all the testimonials.
β
β
But wait...
what if someone writes something that's well.. not good.
Not a bad review, I mean like someone finds this form and enters dirty words.
What I've done is created a form intake, and then each review I click a checkbox in a column marked "Approve" and that then shows up on the "Display" tab. Which is the tab that the website is reading.
On the website, it's a single fetch call to a web app url, in a google server, to my google sheet.
In the sheet, it's a filter on the "Display" tag from the google form responses.
You can see the Formula with FILTER(). It takes the approved testimonials and shows them on the "Display" tab.
β
Hey wait...
What if someone writes something that's too long. Or too word. Or too verbose.
I click a checkbox in the Edit column, and an onEdit() apps script copies the line and puts it unapproved just under the row.
That way, I can edit the text and approve it.
This isn't to edit bad review to good ones. It's just to clean up some of the long reviews. Or fix any spelling mistakes, while being able to keep the original in it's original form.
β
β
If you want to learn EXACTLY how to do this, I'm going to be recording a video very very soon about this process. But the parts are all explained in existing Better Sheets tutorials
I'd recommend first starting at this course: Spreadsheet Automation 101β
βAvailable on Better Sheets, free for members. And available separately on Udemy.
And if you finished that course, and still don't know how to what I show in this email. Reply to this email and say "HELP ME DEPLOY A WEB APP" and I'll reply and let you know when this specific tutorial is out.
If you're looking for design focused tutorials, to just make your spreadsheet look better, check me out on Tiktok
βhttps://www.tiktok.com/@bettersheets.coβ
Been doing some fun checklist and task list videos this week.
This weekend will drop some free tools videos. Showing you what Google Sheet add-ons I've made and are available.
-Andrew
βBettersheets.coβ
Older messages
BetterSheets.co Looks Different
Monday, August 7, 2023
Hi, Just wanted to email you and let you know what I'm doing at BetterSheets.co Because there are lots of little changes, and some big changes happening. First, let me tell you the goals, then I
Free Email Validation (Up to 1,000 a month in Google Sheets)
Thursday, August 3, 2023
saw a few email validation tools on AppSumo over the past few weeks. Of course, I thought "well I could do that in Google Sheets" but then, I moaned... "IF only there was a free API
Make a Business with a Google Sheet
Wednesday, August 2, 2023
Hi, Today, I updated 100 Business Ideasβ They're yours for free. The free Google Sheet includes 100 ideas of businesses you can build using Google Sheets. Use it for lead magnet ideas. New revenue
The Results are In
Monday, July 31, 2023
Hi, I did a study on spreadsheet usage. I asked you, and others all about your usage of sheets. I asked members of Better Sheets , and non-members alike: How often do you use Spreadsheets? The results
Sheetshot
Monday, July 24, 2023
What is a Sheetshot? A sheetshot is a screenshot of a spreadsheet. Specifically: A screenshot of a Google Sheet. Made a little "tool" called SheetShot at BetterSheets.co/sheetshotβ You paste
You Might Also Like
Chapter 2: Static Societies
Sunday, January 12, 2025
The second chapter from the documentary I'm creating is now live. Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν
I'm lucky to be able to write this
Sunday, January 12, 2025
Plus, how to grow your newsletter without social media and why you should trash your productivity system Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν
Food for Agile Thought #475: Natural Agility, Fake Product Transformations, AI Product Management, Fail a Lot!
Sunday, January 12, 2025
Also: ICPs, BugsOptional? Agile Losing Steam, Devs Hating Meetings? Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν
For Authors: 1-Day Facebook Groups Book Posts to 250,000+ Readers
Sunday, January 12, 2025
Group Posts to 250K Facebook Readers "ContentMo is at the top of my promotions list because I always see a spike in sales when I run one of their promotions. The cherry on my happy sundae with
He sold his company (and is still totally lost)
Saturday, January 11, 2025
He's both post-achievement AND post-financial Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν
Book Proofreading Services by ContentMo
Saturday, January 11, 2025
π Two sets of eyes are better! π β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β π Two sets of eyes are better! π Accurate & Affordable
Explain a Movie Plot Badly -- The Answers
Friday, January 10, 2025
Louis Tully is underrated β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β β
π§ββοΈ How to stop getting your pitches ignored
Friday, January 10, 2025
Here's what to do insteadβ¦ Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν
π€ The SWIPES Email (Friday, January 10th, 2025)
Friday, January 10, 2025
The SWIPES Email β Friday, January 10th, 2025 βAn educational (and fun) email by Copywriting Course. Enjoy! β β Swipe: Creeping up as my 5th most popular traffic source last year: ChatGPT! ai-chatbot-
7 Tips for Writing a Book From Entrepreneurs Who Have Done It
Friday, January 10, 2025
Tips from authors who have overcome the struggle. Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν Ν