Step-by-Step tutorials to embed Google Sheets into Websites.
- Add Testimonials powered by Google Forms and Google Sheets.
- Create a simple email form from your site to Sheets without Forms
- Create a daily motivational websitef
Includes
10 Tutorials
Free for Members
10 Tutorials
Quickly Build a Daily Random Motivational Quote Website
Build a website from scratch using a little bit of Google Sheets as the backend. Using Carrd to build a html website from the data and display a random quote every time you refresh the page. All the code including the HTML embed is in the sheet below.
Better Email Form on Google Sites
Submit email from a Google Sites to Google Sheets with this easy to embed html form instead of using Google Forms.
Embed a Headline in a Website from Google Sheets
One of the most requested videos, Ever. How to put data, a number, some text, from a Google Sheets onto a website without having to embed the entire Google Sheet. This is the way!
SUBSTITUTE()
Create a Vote Button from Google Sites to Google Sheets
Connect your published Google Site to Google Sheets with Apps Script and a Button. Great to use for Voting, upvoting, NPS, or anything you want feedback on, at the click of a button from your Google site to a Google Sheet.
Embed Email Form and Name Form into Website to Google Sheets
Add names to the Email2Sheet apps script and code.
Embed a Number in a Website from a Google Sheet
Ever wanted to display some data from a google sheet on your site? Without using 3rd party tools here is the javascript, html and the sheet you will need. and step by step instructions on how to use it.
Embed Quote and Author to Daily Quote Website
Step by step tutorial to update random quote site to show both Quote and Author separately. Example site: https://todayquote.carrd.co/
Quick tutorial to show you how to build a random quote site →Here
Quick tutorial to show you how to build a random quote site →Here
Add NPS to Your Google Site
Create buttons on your Google Site to get an NPS, or Net Promoter Score directly to a Google Sheet.
AVERAGE()
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Embed a little HTML into your site to capture Emails straight to a Google Sheet. I've written the apps script and the html and the javascript for you. As easy as copy and pasting. Use my referral link if you choose to use Carrd for this: https://try.carrd.co/kamphey
SUBSTITUTE()
How to Power Testimonials with Google Forms and Sheets
I show you how I use a Google Form and a Google Sheet to power the testimonials page on BetterSheets. I walk you through the process of collecting testimonials, approving them, and displaying them on the website. I also explain how I implemented the functionality using Apps Script. If you're interested in learning about spreadsheet automation and how to leverage Google Forms and Sheets for your own projects, this video is for you!
And Spreadsheet Automation 101 is a great way to learn most of what I go over in this video.
And Spreadsheet Automation 101 is a great way to learn most of what I go over in this video.
IFNA()
FILTER()