Google Forms

Use Google Forms with Google Sheets. Learn how to automatically create a Google Form from apps script. And find out how to embed better forms than Google Forms. And learn how to use Google Forms information inside of your sheet effectively.

Tutorials

Why can't people fill in my Google Form?

The reason is because a new form has a setting to only allow those in yo...

Email Certain Department Based on Google Form Entries

Message a certain department when google form is submitted.

Advanced

Form Automations: Close Multiple Forms When Over Limit

Adding to the Form Automations: Allow User to Reopen form without Apps ...

Advanced

Close Form After Certain Number of Responses

Create automatic triggers that close a form after a certain number of re...

Intermediate

Create New Worksheet When Google Form Submitted

Automate copying a template for new form submissions with user data inse...

Advanced

Send Better Email When Google Form Filled Out

Find out how to email all the form entries each time your form is filled...

Intermediate

How to make a Pill Form Field in Google Sheets

Create rounded pill form fields in Google Sheets. Using Canva and a bit ...

Intermediate

Better Email Form on Google Sites

Submit email from a Google Sites to Google Sheets with this easy to embe...

Advanced Intermediate

Member Asks: How do I calculate from a set of Form entries?

Use arrayformula to deal with Google form entries on a sheet. Even as th...

ARRAYFORMULA()

How to Create a Google Form Automatically

How to create a form programmatically using Google Apps Script. I show y...

Intermediate

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 testi...

Advanced

FILTER() IFNA()

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a little HTML into your site to capture Emails straight to a Googl...

SUBSTITUTE()