Use WayScript to pass form submissions to a Google Sheet in 4 minutes.
For this tutorial, I have set up a Flask Python app. However, any web server will work.
Here is a link to the flask project used in this demo with setup instructions.
To begin, I have an endpoint that receives the post request for my SignupForm:
Currently, this form submission is only printing the form data to my terminal. Now, I am going to show you how to rapidly pass this data to a google sheet.
Step One - Set up your Trigger
On WayScript, drag 'Trigger' to the first step of your program
First, be sure to set the 'Trigger Type' to Webhook.
On the Trigger Module, add your form data as Outputs. In this case, I add First Name, Last Name, and Email. I also set 'placeholder values', which will be replaced when the program is triggered.
These outputs have now become variables on WayScript that can be used by other modules. Lets pass the data to GoogleSheets.
Step Two - Set up Google Sheets
First, create a Google sheet from your Google account.
Next, drag the Google Sheets module into the second step of your program.
In the Google Sheets Module, set the mode to 'Write' and select the sheet you want to write to.
In the Google Sheets Module, add your three columns and select your variables.
Step Three - Trigger the WayScript program from your form submission.
From the Trigger Module, grab your API Key and Program ID
When your form is submitted, send a post request to wayscript to pass the data.
Done! Now everytime the form is submitted, the data will be pushed to a new row of your Google Sheet in real time.