For most website is important to collect many types of information from the users. Sheet2Site support different types of forms:

Google Forms

The easiest way to collect data from your users is to create a Google Form



Get the form link when you will click Send (top right cornver).



and put the link of this form https://forms.gle/dBmqfrcJY7zz6Fw38 as call to action.



Save responses to Google Sheet

You can save all your form responses to the Google Sheet. You don't need to use Zapier or any other third parties tools. Google Forms support Google Sheet export automatically and it can be setup just in a couple of seconds:

1. Go to responses tab in your Google Form and select "Create Spreadsheet"



2. You can create a new spreadsheet or select an existing one.



2.1 If you want to automatically add new responses your Sheet2Site website, please select your Sheet2Site Google Sheet:



3. You should see a new tab that was created in your Google Sheet.




Automatically show responses on the website


If you want that new data that was submitted by your users showing automatically in your website, you need to connect your "Form Repsonses" tab to your Card" tab with a formula. Please keep in mind that each column in "Form Responses" tab should be mapped to column in "Card" tab:

Also keep in mind that users can make mistakes when they are submitting the form so maybe try to not showing data immediately and check it manually first.

You can use something like this:

={'Form Responses'!B6:B, 'Form Responses'!C6:C, 'Form Responses'!E6:E, 'Form Responses'!F6:F, 'Form Responses'!G6:G, 'Form Responses'!H6:H, 'Form Responses'!L6:L, 'Form Responses'!K6:K, 'Form Responses'!N6:N, 'Form Responses'!A6:A, 'Form Responses'!M6:M }


Email notifications for new responses


To know when some will submit the form you can active email notifications, otherwise you will need to open this form regulary to check if someone submit it or no.

How to enable Google Form email notifications if someone will submit the form

  • Create a new form forms.new or open an existing one
  • Responses
  • Click 3 dots
  • Get email notifications for new responses




Pre-fill Google Forms with URL Parameters




The cool thing about Google Forms is that you can pre-fill your form with some specific value in the link. Let's say you list of items and the ordering form and when the user when click on the item he will open the form with prefilled item id

How to pre-fill Google Form link

  1. Create a new form forms.new or open an existing one
  2. Click 3 dots in the top right corner
  3. Get pre-filled link
  4. Select field in your form that you want to pre-fill
  5. Press Get link
  6. Press Copy link in the bottom left corner pop-up

You should get a link like this: https://docs.google.com/forms/d/e/1FAIpQLSeS97tfbZT1wrU0AM_gMBv_67_FkujKrQtSL-i5hlzwcE5X1g/viewform?usp=pp_url&entry.866939081;=id-123456

where &entry.866939081;= is your filed and id-123456 is a pre-filled value.



Native Forms




You can Google Form builder and make the form looks like a native website form




You can add embeded Google Form to your website to be able to collect data from users. For example you want to make a post a job form for your vacancy website.

You can use Google Forms as a form builder, but the form on your sheet2site website will looks like a native form. Once the user will click on the botton the form will appears as a pop-up modal.

If you will make any changes in the Google Form it will automatically update in the form on your webiste.

How to add Native Forms to your webiste:

1. Copy Google Form template

2. Add sheet2site@gmail.com as a collaborator:



3. Copy the link from your browser:



Link should looks like this (for edit Google Form not for preview it): https://docs.google.com/forms/d/1Hz4i_ie_0rxkIqPsRvOm4iDxprQdmvmcwlc193wXm-s/ edit

Do not use these links:

  • Short links: https://forms.gle/oyhMhCefmsZJGYNNGA
  • Preview links: https://docs.google.com/forms/d/e/1FAIpQLSexQk1x0Tte2J_-mkEH-yqalmdLnMlAH68NogNLTGWx3gkHUQ/ viewform

And paste it the navbar tab:



Important about Native Forms

1. Field types can be only: Short answer text



2. If you want to add an email field DO NOT press suggestion: Enable email collection setting. Just enter "Email" as a name of field and exit.