CLIENTS: How to integrate your own google sheets into your website forms so that all submissions enter into your sheets

CLIENTS: How to integrate your own google sheets into your website forms so that all submissions enter into your sheets

  1. Email your MA - inform them you want access to all submissions for your forms (ie. application or contact list)

  2. Expect an email back, your MA should notify you that you now have access to edit the form so you may integrate 

  3. Follow these steps below

                                                                                                                           

1. Navigate to the Web Editor: https://sites.becomedistinct.com/home/dashboard/sites

2. Click "Edit" on your assigned website 



3. Click the form you would like to integrate google sheets with (ie."Contact Us")


4. Click "INTEGRATION" from the pop-up editor


5. Click "Google Sheets"

6. Click "sign into Google"


7. Choose the google account you want to sign into 


8. Click "Allow" to allow integration


9. If you have a spreadsheet with already submitted forms, click "choose existing". If you do not and need to create a new (most common), click "create new spreadsheet".


10. To see the new integrated spreadsheet, click "open spreadsheet"  


11. The new google spreadsheet will now open and be linked to that form on your website! 







    • Related Articles

    • Google Workspace Request Form

      If you need to request an update to your Google Workspace account please use this form.

    • Google Workspace Training Documentation For Clients

      This informaiton is great to share with Google Workspace clients.  https://support.google.com/a/users/?hl=en#topic=9393003

    • Using Captcha on Website Forms

      Using Captcha on website forms can reduce bots and spam, but we typically recommend clients not use captcha because it adversely affects page speed. If the bot/spam activity becomes overly annoying to the client, we can weigh pros and cons and ...

    • Client Website Shows the wrong name when searching on Google.

      We can update content on a website to indicate to Google that we would like for Google to use it. We can never guarantee how fast Google will pickup the changes or if they will adapt them. However, they should easily adapt information like website ...

    • Client Password Sharing Form

      If you need to share a password with our HQ team please use this form.