Automatic event blog publisher by the help of google form and sheet.
-
Create a google form
-
Link form to googlesheet
Go to
response
of the created form and link with googlesheet. -
Publish googlesheet to public
File > Publish to the Web > Publish
-
Copy google sheet ID
Copy the id between /spreadsheets/ and /edit in the url: https://docs.google.com/spreadsheets/d/1fvz34wY6phWDJsuIneqvOoZRPfo6CfJyPg1BYgHt59k/edit
-
Clone/Fork repository and add googlesheet ID
First clone or fork the repository and add google sheet id in secrets. The key should be
SHEET_ID
. This is required for googlesheet-actions
- When new event posted through
google form
it update googlesheet. - Other side in every 5 mins data collects from googlesheet (as json) by the help of googlesheet-actions.
- Once it's
googlesheet-actions
finds new data it updatedata.json
and build workflow triggred on every push. - After that vercel deployed the site.
- There might be a case where first row will be empty in googlesheet. Plese remove the empty row.
- There is no empty data checks.
- If all fields are optional in
google form
in that case only timestamp will generate. - There is no encryption mechanisam available right now.