Google Forms


Google Forms




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 Google Form 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 Google 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.





How to 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.



4. Please move this tab to the most right corner of your Google Sheet (after Advanced tab):



5. 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:

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 }

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.



How to turn on email notifications for new responses in Google Forms


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