Comments (3)
I think the way to belay these concerns is to place a server-less listener in front of the required setup for the google sheet.
One such option could be AWS Lambda. Basically add CAPTCHA to reduce fake or bot generated form entries then send the request to the AWS lambda endpoint then forward the request to the google sheets. Which means the sheet that is attempting to be populated and the relevant API keys plus other identifiable information would remove all phishing, fake data insertions, data manipulation, & related concerns.
The AWS Lambda free usage tier includes 1M free requests per month and 400,000 GB-seconds of compute time per month.
Source: https://aws.amazon.com/lambda/pricing/
Maybe after bringing up this path there may be a way to create keys to only enable use to the specific spreadsheet and only allow write permissions?
- Add CAPTCHA to Form
- Use client side input sanitation via javascript
- Use some free tier or paid serverless service
- Forward the request from serverless service to the google script
- Enjoy your google sheet backend (somewhat) securely
from form-to-google-sheets.
@umeshnevase I finished its really safe.. but yout app script is public api.
i can use for google sheet backend
from form-to-google-sheets.
Hello, is it really safe?
from form-to-google-sheets.
Related Issues (20)
- Adding date and time to the sheet when the form is submitted HOT 1
- Data not showing when form is filed from any other location HOT 1
- Support for images
- timestamp not appear HOT 1
- Form Submission Landing "Thank You" Page HOT 1
- sheet not writing anything HOT 1
- Not working when sheetName other than 'Sheet1' HOT 2
- Data not being processed to form
- How to show thank you page or success message after form submission. HOT 3
- Redirecting issue when using polyfills HOT 2
- How to add captcha?
- How to have multiple forms with different sheets?
- Timestamp on the Google Sheet ?
- Redirection after POST HOT 1
- How to use in React.js
- How to redirect it to homepage instead of showing this in new tab. HOT 1
- Data from checkbox submission not showing in google sheet. HOT 1
- How to create the sheet, step 2?
- Create new issue
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from form-to-google-sheets.