Formulas in Google Sheets Disappear When New Rows Are Added - The Solution

The formulas in Google Sheets may get deleted when new rows are added in the sheet or when new responses come in through Google Forms. The fix is simple!

How Teachers can Email Parents of Students from Google Forms

Learn how teachers can automatically send emails to the parents of a student on behalf of the school after they submit a Google Form.

How to Calculate the Percentage Score in a Google Forms Quiz

Learn how to find the percentage score of a quiz in Google Form with the help of a Google Sheets formula.

How to Auto Format Google Form Responses in Google Sheets

Learn how to automatically preserve the formatting in Google Sheet when new Google Form responses are submitted.

How to Change the Date Format in Google Sheets

You can customize the date format in a Google Sheet with the TEXT function and completely change the way the date and time values are displayed in the worksheet.

Useful Regular Expressions for Validating Input in Google Forms

Collection of regular expressions to validate user input in Google Forms quizzes and surveys.

How to Use Notion with Gmail and Google Sheets using Apps Script

How to use the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.

Find Google Sheets Linked to your Google Forms

How to find the destination Google Spreadsheet and Sheet that is storing responses of the current Google Form with Google Apps Script

How to Add Options in Google Forms Questions from Google Sheets

Learn how to bulk add options in dropdown lists and multiple-choice questions in Google Form using values from Google Sheets

How to Copy a Formula Down an Entire Column in Google Sheets

Learn how to use the ARRAYFORMULA function in Google Sheets to quickly apply a formula to an entire column in the spreadsheet. The formula is also added to new rows automatically.

How Spammers Avoid the Gmail Spam Filter through Google Forms

How spammers use a simple setting in Google Forms to send junk emails through Google's own mailing servers and completely avoid the Gmail spam filters.

How to Use Formulas with Google Form Responses in Sheets

Learn how to add autofill formulas with Google Form responses in Google Sheets. The cell values are automatically calculated when a new Google Form response is submitted.

How to Send Google Forms with Pre-filled Answers

Learn how to prefill answers in Google Forms using data from a Google Sheet and send the pre-populated Google Forms as personalized emails.

How to Move Files Uploads from Google Forms to a Specific Folder in Google Drive

Learn how to organize file uploads and attachments from Google Forms and move files to a specific folder in Google Drive.

How to Send a File to Participants After they Submit your Google Form

Google Forms for Giveways! How to send a file attachement like PDF ebook or MP3 music to form respondents after they complete the quiz or survey and submit your Google Form.

Build a COVID-19 Self Assessment Tool with Google Forms

How to create a self-assessment form for COVID-19 that your employees and students must complete prior to entering the work premises. The form will automatically send a confirmation email to the respondent based on the results of their self-assessment.

How to Receive Push Notifications for Google Forms on your Mobile Phone

Receive instant push notifications on your iPhone and Android phone when someone submits your Google Form. Tap the notification to view the complete form response

How to Create Forms that Allow File Uploads to Google Drive

Learn how to build file upload forms for Google Drive and receive large files from anyone. The form respondent does not have to be signed in to their Google accounts

How to Send Emails with Google Forms Based on User's Answers

How to Get Google Forms Responses in an Email Message

How to send Google Forms data in an email message after a respondent submits the form. You can send a copy of the form answers to the submitter as well.

How to Get the Quiz Score in Google Forms with Apps Script

Teachers can easily create an online quiz using Google Forms and students can view their test scores immediately after form submission.

How to Generate PDF files from Google Form Responses

Add the Edit Response URL of Google Forms in Google Sheets

How to Track your Study Time with Google Forms and Sheets

Send SMS with Google Forms

How to Schedule your Google Forms and Limit Submissions

How to Automatically Create PDFs with Google Form Responses

The Most Popular and Useful Google Scripts

Create Trello Cards from a Google Form with Google Scripts

Post Google Forms Submissions to Slack with Google Scripts

Replace Adobe Forms Central with Google Forms

Post Google Forms Reponse into Insightly CRM

How to Add a Picture Password to your Google Forms

How to Send Confirmation Emails with Google Forms

How to Receive Files in your Google Drive from Anyone

Run a Poll on Twitter with Google Forms

Restrict Google Forms to only Allow One Entry Per Person

How to Password Protect a Google Form

Why Google Forms are Perfect for Creating Online Surveys