• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Forms
  • Sheets
  • General
  • Drive
  • Gmail
  • Sites
  • Apps Script
How to GApps

How to GApps

Your life changer for G Apps

  • About
  • Contact
  • Terms and Conditions
  • Privacy Policy
  • COOKIE POLICY

SavoE

Create a Script to Send Emails from Google Sheet

May 22, 2020 by SavoE 4 Comments

Create a Script to Send Emails from Google Sheet

Sending the same email but with some personalized content to a group of people can be a boring and time-consuming process. The best solution to this is to have all the data in the sheet and use a process called MailMerge. But this option is not available in google sheets. So,  in this how-to, we will create a script to send emails from google sheet using the data from the … [Read more...] about Create a Script to Send Emails from Google Sheet

How to Use Google Meet for Distance Learning

March 26, 2020 by SavoE 1 Comment

list of classes in Google Meet

Google Meet is an app for video conferencing and it is a part of the G Suit. Now, in the situation with coronavirus and stoping the classic classroom learning, educational institutions that have G Suit for Education can now use the Google Meet app and start the classes online, the famous distance learning.What can you do with Google Meet for your online teaching:start, … [Read more...] about How to Use Google Meet for Distance Learning

Google Spreadsheet Script to create and email a PDF on Form Submission

March 5, 2020 by SavoE

script to create and email a PDF

In this how-to, we will use a script to create and email a PDF on Form submission automatically. So, this script is going to be triggered by submitting the Google Form and it will convert the sheet in PDF. In the next steps, the script is going to save the PDF in your Drive and send it as an attachment in an email.Check this article if you want to AutoFill and Email a Doc … [Read more...] about Google Spreadsheet Script to create and email a PDF on Form Submission

Add Auto Number to Google Form Response Sheet

February 27, 2020 by SavoE

To easily and uniquely identify each Google Form response is to have a key field. That field should be in the form of a number that will be autogenerated to avoid duplicates. This option is not available in Google Forms, so you have to adapt the Form response sheet to do it for you.The auto-number formulaThe formula that we are going to use to add auto number to Google … [Read more...] about Add Auto Number to Google Form Response Sheet

Generate Invoices using Google Form and Sheets

February 24, 2020 by SavoE

generate invoice google forms and sheets

In this guide, we are going to build a small web app to generate invoices using Google Form and Sheets. Basically, we are going to create a Google Form that collects the data for the invoice and sends it to a spreadsheet. In the spreadsheet, we are going to create an invoice template for printing and we are going to use formulas to get the latest data automatically.So, just … [Read more...] about Generate Invoices using Google Form and Sheets

« Previous Page
Next Page »

Primary Sidebar

Follow me on Twitter

Follow @HowToGApps

More to See

Google Form to Slides + Save to Drive and/or send it in email as a PDF

add other response to the list of choices

Google Form Script to Automatically Add New Choices from “Other:” Form Responses

google form to pdf

Google Form to PDF (save to Drive and/or send it in email)

Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email

Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email

publish to the web Google Sheets

Embed Google Form, Sheet, Chart and Doc in WordPress

Recent Comments

  • Cordial on Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
  • LinkyChan on Close the Google Form and Force the User to Submit the Responses
  • SavoE on Close the Google Form and Force the User to Submit the Responses
  • LinkyChan on Close the Google Form and Force the User to Submit the Responses
  • Chartist on Explode or expand a Pie Chart in Google Sheets

Buy Me A Coffee
Inspire me to keep the website up and running.




Recent Posts

  • How to Make One Pie Chart Slice Stand Out in Google Sheets
  • Automate Your Analysis: The Ultimate Guide to Live Google Forms Data in Sheets
  • How to View and Manage Google Form Responses Like a Pro
  • Google Sheet Template to Track Sales of Products or Services
  • Close the Google Form and Force the User to Submit the Responses

Recent Comments

  1. Cordial on Automated e-card sender – Google Spreadsheet Script to Send Birthday Cards via Email
  2. LinkyChan on Close the Google Form and Force the User to Submit the Responses
  3. SavoE on Close the Google Form and Force the User to Submit the Responses
  4. LinkyChan on Close the Google Form and Force the User to Submit the Responses
  5. Chartist on Explode or expand a Pie Chart in Google Sheets

How to GApps

  • About
  • Contact
  • Terms and Conditions
  • Privacy Policy
  • COOKIE POLICY

Footer




Recent

  • How to Make One Pie Chart Slice Stand Out in Google Sheets
  • Automate Your Analysis: The Ultimate Guide to Live Google Forms Data in Sheets
  • How to View and Manage Google Form Responses Like a Pro
  • Google Sheet Template to Track Sales of Products or Services
  • Close the Google Form and Force the User to Submit the Responses

Search

Copyright © 2025 · How to Gapps