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

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! 







    Visit our Online Community

    Distinct is launching a vibrant online community that is totally free! Talk with others in your industry, download free graphic packs, take advantage of exclusive workshops, and more!

    Click here to sign up for our community.

      • Related Articles

      • 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 ...

      • How to Add/Update the Form Recipient on DUDA Form

        Click on the form. Click Manage Form. In the pop-up window, select Submissions. Click New Submission Notification. Update, add, or edit the email recipient and subject as needed. Close the pop-up once finished. Changes are saved automatically. Click ...

      • SEO Questions for using PDFs and Graphics on website.

        From an SEO perspective, it's always best to NOT use a PDF/ Graphic and instead post as written content on the website. One compromise to ensure SEO and well-kept records is to post the written text, similar to a blog, and have a link to the PDF ...