![]() ![]() It’s not about the students checking the answers for their examination papers. If you’d like more help, my original tutorial allows you to download the Google Sheet and Integromat setup ready for you to use.Note: This post will help the creator/editor of the form to view the received answers. Learning how to use Integromat (or Webflow’s new up & coming “Logic”) allows you to create solutions for any of your own needs, or the needs of clients. There are pre-canned solutions out there for submitting forms into Google Sheets, but they limit you to just that. Or even better, swap out Integromat for Webflow Logic (once it’s released) Worst case, you’ll spend $9/month for Integromat including an account that can do more than you’ll most likely need. In this case you used a free Integromat account. What you’ve just learned can be applied to thousands of different automations to run you or your clients Webflow sites. This may have seemed a “bit involved” for something so simple, but don’t let that sway you. Go back to the live site, with your native Webflow form, fill it out and submit it!Ĭheck your Google Sheet, you should now see your submission Webflow-form-submit-to-google-sheet-integromat-18 3134×2242 456 KB Use it! Tap the “Add” button and your setup should look like the below screenshot: Paste the “thank you” page url into the “Value” field. Under the Key field, add the word “Location” (spelled with a capital “L”). Tap on the “Add item” link and that’ll open up a new popup. Within the new popup, show above, change the 200 in the “Status” field to a 301. This time you only have the “Webhook response” option, select that. Tap “Add another module” off of the Google Sheet Module. In this case, to your static Webflow “thank you” page (screenshot above). Next, you need to tell the web browser that you’d like to redirect the user somewhere. Integromat passed that message to the Google Sheets module and created a new row for you. Once you’re done, tap the “OK” button for this Modules popup.Īt this point, you’ve submitted a native Webflow form into an Integromat Webhook. This will automatically add the date/time stamp for you. This last option will just tell Integromat to skip that header row.Īdd the “name” field submitted from your native Webflow form into this Integromat Modules name field.įor the “date submitted” field, tap on the “date and time” tab and select the “now” option. Next select your “Sheet”, and then select “Yes” if your table has headers (my example in the screenshot above, does). Once done, you can select the name of your Spreadsheet, listed under the “Spreadsheet” section. Now you can tap on the “Add” button under the “Connection” section and connect to your Google account. Next, search for and select “Google Sheets” for this new Module. Tap the “Add another module” button within your Integromat Scenario. ![]() Notice the button “Re-determine data structure” that means everything worked Webflow-form-submit-to-google-sheet-integromat-6 800×679 54.3 KB Make sure you’ve selected “POST” from the “Method” as well: Go back to the Webflow Designer, select your form, and paste this url endpoint into the “Action” filed. Tap the “Copy address to clipboard” button. Mine is “Submit Webflow Form to Google Sheet” so I always know what this Webhook doesĪt this point you’ve just created a “url endpoint” that you can submit your native Webflow form to. Tap the “Add” button and give your Integromat Module a descriptive name. One is “name” the other “date submitted” (screenshot above). Go ahead and create a new static page, mine is literally named “success” you do what you likeĬreate a new Google Sheet and add two columns. In this case, it’ll just be a static page with a “thank you” message. This could be a Webflow page, or any other site you like! Once your user submits the form, you need to redirect them to a new page. You’ll be returning to the form settings after you set up Integromat. This will reduce head banging errors that either waste too much of your time, or that you can never get past. Create the most minimal set up possible within this blank account. Whenever you are doing something new, create a brand new, blank project. See the screenshot above, this perfect for a quick, simple test set up. That leaves me with just a name field & label. I used a Form Block element and removed the default “email” field & label. This is straightforward, nothing fancy, just something to use as a quick test. Starting with Webflow, create a simple form on a static page. Webflow-form-submit-to-google-sheet-webflow-9 3134×2242 208 KB Let’s build it! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |