Navigation Menu

Skip to content

vanpariyar/contact-form-to-sheets

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

12 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

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 πŸ˜‚

contact form to sheets

THEN

contact form to sheets

IN Google Sheet

Goto Tools > ScriptEditor.

Screenshot from 2020-03-27 20-31-02

In the Newly opened window

Change as per your requirement. Publish > Deploy As app. Screenshot from 2020-03-27 20-31-55

In Newly opened window

Set settings as shown.

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

Copy This retrived URL. Screenshot from 2020-03-27 20-32-36

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

About

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

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published