contact-form-to-sheets

👋 Hiii,

The small application that sends your static contact form data to the Google Sheets With Email notification.

You find this cool 👌. (We can build with no Time just Follow Tutorial).

NOTE: Email Notification is in development (You also can contribute by making a new branch).

DEMO: https://vanpariyar.github.io/contact-form-to-sheets

To see your response. https://docs.google.com/spreadsheets/d/1lFgkCv0I1ZnV6bPcGoBMB9w2KWx8FZZ6-hfiDgN6cFU/edit?usp=sharing

Tutorial

Click on URL to Copy sheet: https://docs.google.com/spreadsheets/d/1lFgkCv0I1ZnV6bPcGoBMB9w2KWx8FZZ6-hfiDgN6cFU/copy

After copy

Enter your google Creds. It will store in your Drive. Don't worry not spam 😂

THEN

IN Google Sheet

Goto Tools > ScriptEditor.

In the Newly opened window

Change as per your requirement. Publish > Deploy As app.

In Newly opened window

Set settings as shown.

• Anonymous is required.
• Run as me required to use on your website.

Copy This retrived URL.

publish the script as a web app.

NOTE: IF it is asking for the authorization goto advance > then continue to unsafe Then copy SCRIPT Url:

😅 Not any harm full code but Google does not allow any code without your confirmation. You can review my code if you feel uncomfortable it's fine.

Now where to put this URL 🤔

The answer is put in Contact.js

set URL variable in ->

var url = yourScriptUrl

This is kind an API endpoint u can use CURL, ajax, Fetch to this URL.

IT is safe because it redirects it's output to another URL. You will find after some experience.

I will share the reference.

https://developers.google.com/apps-script/reference/spreadsheet