This Google Sheet powers the Testimonials page

A few days ago I emailed you about this testimonials page on my site that's powered by a Google Sheet.

And now, I just dropped a behind the scenes breakdown of the sheet, for members here: https://bettersheets.co/tutorials/how-to-power-testimonials-with-google-forms-and-sheets​

In the video, I show you the sheet that powers it all.

And you get the sheet, (if you're a member).

I also highlight all the apps script: the doGet() function, and the onEdit() function and the onOpen() function too.

Each one of these plays an important part of how the sheet works and how you can use it too.

If you're a member, can you please watch the video, and the first thing that's unclear, reply here and let me know.

I'm happy to make more videos further explaining parts of the sheet/script.

Most of the Apps Script can be learned by taking the Spreadsheet Automation 101 course. Not all. but most. If something is hazy about Apps Script, I'd start there.

Disclaimer: I do not go over the doGet() function in Spreadsheet Automation 101. Might add that to some updates later.

doGet() is featured in the Embedded apps scripts in these videos:

• ​Embed a headline in a website​
• ​Embed a Number in a Website​

And it's sister function: doPost() is featured in this video

• ​Send Emails to a Google sheet From a Website​

These are both powerful functions built into Google Apps Script that can be used in countless ways.

If you don't know how you could use it, reply with what you're working on, or your site and say "I DON'T KNOW". Happy to brainstorm a bit for you.

-Andrew

​Bettersheets.co​

​