2

Would like to be able to gather data using a Google Form and then display that data on a web page with a unique URL to that data. We would take that URL and then paste it in a contact record in our CRM. We have a lot of questions on that form, and it would clutter up the contact record in the CRM. Anyone know of a way to do this?

1
  • Have you checked out the add-ons? – aparente001 Sep 20 '17 at 12:26
1

Yes its Possible

i know this is an old post but this answer is for anyone else looking for the same solution to a similar problem quite recently.

Heres a simple workaround -

collate the correct data you want to display onto a new sheet - i.e. all your new responses - make your own histograms/ graphs / pivots or charts etc - save these all onto one single sheet & then simply publish that single read only anylitical data sheet to the web & share that link with your participants.

lets say for example you want to share the form responses data or you have made your own analytical summary charts & pivots & graphs based off that data you received on one particular sheet & you would like to share that analysis sheet publically

so for example i want to share just the form responses sheet with my particapiants, heres what i will do

on the main menue of the google sheet linked to the form responses

click on "file"

click on "publish to web"

You get two options - a public link which you can share - or the embed code

on the link section

click on the drop down & select "form responses 1"

Click on "Publish"

You will get a publically sharable weblink of just the form responses sheet that will auto update evry 5 minutes, like wise you can share any of the other sheets aswell not just the form responses sheet.

it basically converts any of the sheets you would like to publically share into a single 'read only' simple webpage.

be careful though - if you select "entire document" your whole google sheet will be shared with all its sheets publically visible to anyone with the link

On the second dropdown below " Published content & settings"

Select the same sheet name as you selected in the first drop down "form responses 1" or select any other sheets that you want to share aswell simentensously

click on "publish"

When you want to stop sharing your sheet or sheets just click "stop publishing"

-3

it is necessary to use a site google with integration of graph or table and put the url of this google site in your crm cordially

2
  • This answer could use a lot of improvement. Why is this the correct answer? Are there help articles for the product that back this up? Or have you test / tried alternatives that didn't work? – Folk Sep 20 '17 at 13:31
  • Google Sites is one product which could be used to do what is asked. But there are many others - and I don't think that product recommendations is within scope of the discussion here. – MaryC.fromNZ Sep 20 '17 at 13:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.